Slide 14
Slide 14 text
© 2022 DATUM STUDIO Co. Ltd. PROPRIETARY & CONFIDENTIAL. 13
SQLが複雑すぎる
✓ SQLを複数ファイルに分割
• デプロイは気にせずOK
✓ 複数の層に分割
• staging
• 簡単な変換
• intermediate
• joinなど
• dwh
• モデリング(dimensional
modeling, data vaultなど)
• mart
• BIから参照する
長くなったSQLは分割→ファイル追加するだけでOK
with hoge as (
…
),
fuga as (
…
),
piyo as (
…
),
…
final as (
)
select *
from final
with hoge as (
…
),
fuga as (
…
),
final as (
)
select *
from final
with piyo as (
…
),
…
final as (
)
select *
from final