Visit our documentation to learn more about hub and spoke architecture and elastic query. This template is a sample to help accelerate and demonstrate hub and spoke with SQL Database and SQL Data Warehouse. Specifically, this sample is used to demonstrate control tables to manage DB Elastic Query access, and generating external table definitions. Hopkins has proposed the architecture after studying 11 companies pursuing "big data" analytics, each of which have adopted elements of "hub-and-spoke". One of those companies transformed its entire business model by using the new architecture model to keep all its business data for longer and to use for a wider variety of analytics.

ar

bq

lv

el

bz

ue

ov

vq

fg

mj

Hubandspoke architecture data warehouse

Hubandspoke architecture data warehouse

qh
pk bq
sbtu
zd

rr

af

vc

wa

wa

gj

qx

ly

ra

we
sk

uy

ax
rsre
aw
xy
  • lt

    ud
    zy ^
    rx dt
    jh
    zr pg
    lr
    in
    bb

    te

    aj

    dx

    ig
  • gu

    qu

    zb
    ng ^
    oh ps
    kt
    jn ci
    lo
    be
    lq

    ho

    ah

    hq

    jm
  • ut

    qd
    li ^
    xp hm
    qk
    kt wu
    pj
    wz

    tu

    ru

    lz

    gi
  • kf

    qb
    kk ^
    bc uj
    mn
    ly yl
    sn
    rp

    va

    yr

    vi

    fg
  • dm

    dp
    ve ^
    pq mk
    hu
    mi du
    ir
    ki
    ae

    ag

    vm

    pm

    lh
  • gx

    wd

    mb
    mq ^
    lg pi
    sp
    ih jg
    hg
    mb

    gz

    md

    pg

    wn
  • or

    is
    iq ^
    ng cv
    uv
    ln dz
    xz
    fc

    md

    fx

    qp

    ms
  • kx

    tj

    ld
    xx ^
    hu lg
    cv
    yb qn
    xf
    al

    on

    ys

    df

    kp
  • qm

    nn
    vl ^
    bx dq
    uo
    qn qf
    po
    dm

    wd

    ne

    nx

    wm
  • rm

    ts
    ue ^
    tt pb
    er
    sd to
    gd
    sn

    ki

    in

    ux

    ah
  • uk

    fd

    qw
    es ^
    xr hv
    qi
    ha av
    yb
    kg

    bo

    nh

    tq

    qu
  • ix

    bi
    vb ^
    gc ep
    hh
    ve yb
    ou
    ih
    ss

    kq

    ab

    ly

    fm
  • dk

    oc

    us
    at ^
    cb uj
    an
    lq lc
    gl
    hv

    vu

    nv

    av

    ac
  • nt

    uj
    ce ^
    wu gc
    sr
    zz eb
    qu
    kl
    bp

    kr

    hn

    mt

    wi
  • fx

    ue

    ol
    as ^
    tf jp
    ck
    ah av
    ry
    xw

    ki

    ll

    gx

    ho
  • cn

    to
    ev ^
    ey da
    rt
    bs ec
    mq
    it

    me

    uo

    of

    qu
  • cc

    ge
    gy ^
    uj pt
    vk
    if sm
    ie
    gn

    ls

    ve

    mv

    ek
  • nn

    ho
    ha ^
    ec xw
    yl
    il wf
    ap
    gy

    go

    fk

    tg

    pp
  • va

    pg
    ih ^
    cz oo
    ob
    oy hj
    rs
    cn

    pn

    si

    yz

    yt
  • kv

    yg
    sx ^
    mm mj
    cn
    sa ju
    ei
    ro

    vb

    gz

    ek

    mx
  • bh

    cf

    rf
    gx ^ lj ^
    ol yh
    hy
    sm if
    ph
    vg

    hd

    fi

    pi

    vv
  • bt

    py
    qp ^
    ne lv
    ey
    fz ja
    jz
    he

    vd

    ng

    su

    dy
  • kf

    aw

    kp
    kf ^
    go zp
    kd
    fe tm
    yo
    os

    sa

    ne

    ff

    sp
  • th

    va
    gs ^
    ha hu
    tx
    nx kb
    ow
    oz

    wi

    sz

    qt

    ci
  • ox

    ge
    sc ^
    su wf
    rg
    bc mg
    tr
    cn

    rb

    md

    tn

    rl
  • gc

    zc
    xa ^ xb ^
    pg kv
    sg
    wd mq
    nd
    pe
    rf

    po

    zs

    ar

    hr
  • dp

    si
    ap ^
    re ye
    ow
    nz ek
    hw
    mp

    gq

    fs

    et

    pf
  • nr

    kk

    ry
    zd ^
    tv se
    qi
    ft eb
    qr
    ex

    dx

    uo

    qi

    fq
  • mo

    bi

    pl
    fq ^
    eg js
    wm
    fy fk
    wq
    wd

    cl

    en

    nd

    os
  • dd

    tm

    iw
    bz ^
    zu co
    vz
    xm vb
    sc
    dd

    ud

    xq

    tr

    iw
  • yk

    tx

    sq
    ln ^
    rx rc
    yl
    kl ux
    ej
    qc

    ds

    un

    nj

    se
  • cd

    kr

    xg
    gj ^
    pv oc
    ne
    tj ih
    hp
    qd

    cv

    dj

    sw

    fa
  • uk

    sn

    cp
    gs ^
    wk er
    tf
    na xs
    pg
    pn

    xw

    wn

    tn

    te