dbt macro tips Advent Calendar 2022

データ変換ツールである dbt (https://www.getdbt.com/) に関して、macroと呼ばれる機構がある。このmacroを使いこなす上でのtipsを書き続けるアドベントカレンダーです。

SUN	MON	TUE	WED	THU	FRI	SAT
				1 ikeda-masashi	2 ikeda-masashi	3 ikeda-masashi
4 ikeda-masashi	5 ikeda-masashi	6 ikeda-masashi	7 ikeda-masashi	8 ikeda-masashi	9 ikeda-masashi	10 ikeda-masashi
11 ikeda-masashi	12 ikeda-masashi	13 ikeda-masashi	14 ikeda-masashi	15 ikeda-masashi	16 ikeda-masashi	17 ikeda-masashi
18 ikeda-masashi	19 ikeda-masashi	20 ikeda-masashi	21 ikeda-masashi	22 ikeda-masashi	23 ikeda-masashi	24 ikeda-masashi
25 ikeda-masashi

12/1

ikeda-masashi

dbtにおけるmacroとは

https://zenn.dev/mashiike/articles/5e099abb1a8b6d

dbt macro tips advent calendar 2022 day 1 - dbtにおけるmacroとは
12/2

ikeda-masashi

一番簡単なmacro

https://zenn.dev/mashiike/articles/ceaa13bf0017d1

dbt macro tips advent calendar 2022 day 2 - 一番簡単なmacro
12/3

ikeda-masashi

macroの引数

https://zenn.dev/mashiike/articles/79fd09a3a1a7cc

dbt macro tips advent calendar 2022 day 3 - macroの引数
12/4

ikeda-masashi

制御構文

https://zenn.dev/mashiike/articles/5bb5c3eee044f9

dbt macro tips advent calendar 2022 day 4 - 制御構文
12/5

ikeda-masashi

変数

https://zenn.dev/mashiike/articles/28130c67402a84

dbt macro tips advent calendar 2022 day 5 - 変数
12/6

ikeda-masashi

doとlog

https://zenn.dev/mashiike/articles/9fd2bad658ceee

dbt macro tips advent calendar 2022 day 6 -doとlog
12/7

ikeda-masashi

dbtの動作モード

https://zenn.dev/mashiike/articles/3af43fd34dccb2

dbt macro tips advent calendar 2022 day 7 - dbtの動作モード
12/8

ikeda-masashi

マニュフェストファイルとgraph

https://zenn.dev/mashiike/articles/0132c0b2f0d739

dbt macro tips advent calendar 2022 day 8 - マニュフェストファイルとgraph
12/9

ikeda-masashi

statementとrun_query

https://zenn.dev/mashiike/articles/7761fc12782acb

dbt macro tips advent calendar 2022 day 9 - statmentとrun_query
12/10

ikeda-masashi

on-run-end Context

https://zenn.dev/mashiike/articles/dacb02e9344276

dbt macro tips advent calendar 2022 day 10 - on-run-end Context
12/11

ikeda-masashi

dump_fail_test

https://zenn.dev/mashiike/articles/fc84fdf1675a3a

dbt macro tips advent calendar 2022 day 11 - dump_fail_test
12/12

ikeda-masashi

meta

https://zenn.dev/mashiike/articles/19d05ce47c305b

dbt macro tips advent calendar 2022 day 12 - meta
12/13

ikeda-masashi

pre-hookとpost-hook

https://zenn.dev/mashiike/articles/627ef69baeaf63

dbt macro tips advent calendar 2022 day 13 - pre-hookとpost-hook
12/14

ikeda-masashi

grantに関する便利なマクロ例

https://zenn.dev/mashiike/articles/a0b5661b43ada4

dbt macro tips advent calendar 2022 day 14 - grantに関する便利なマクロ例
12/15

ikeda-masashi

macro override

https://zenn.dev/mashiike/articles/d6132b24b74ebe

dbt macro tips advent calendar 2022 day 15 - macro override
12/16

ikeda-masashi

dispach

https://zenn.dev/mashiike/articles/829ab9b4cafe8f

dbt macro tips advent calendar 2022 day 16 - dispach
12/17

ikeda-masashi

persist_docs改造

https://zenn.dev/mashiike/articles/faea7f2d4ada73

dbt macro tips advent calendar 2022 day 17 - persist_docs改造
12/18

ikeda-masashi

hookの実装のdeep-dive

https://zenn.dev/mashiike/articles/a5a0df7b5eab50

dbt macro tips advent calendar 2022 day 18 - hookの実装のdeep-dive
12/19

ikeda-masashi

コンテキストの中の便利なもの

https://zenn.dev/mashiike/articles/6c55560f37da5f

dbt macro tips advent calendar 2022 day 19 - コンテキストの中の便利なもの
12/20

ikeda-masashi

カスタムテスト

https://zenn.dev/mashiike/articles/b5ea6e435a64fd

dbt macro tips advent calendar 2022 day 20 - カスタムテスト
12/21

ikeda-masashi

ref,source改造その１

https://zenn.dev/mashiike/articles/765d2913de1300

dbt macro tips advent calendar 2022 day 21 - ref,source改造その１
12/22

ikeda-masashi

ref,source改造その2

https://zenn.dev/mashiike/articles/afe34425e23e64

dbt macro tips advent calendar 2022 day 22 - ref,source改造その2
12/23

ikeda-masashi

ref,source改造その3

https://zenn.dev/mashiike/articles/ceb4f227975a2e

dbt macro tips advent calendar 2022 day 23 - ref,source改造その3
12/24

ikeda-masashi

時間関係

https://zenn.dev/mashiike/articles/38ff6afde4ec82

dbt macro tips advent calendar 2022 day 24 - 時間関係
12/25

ikeda-masashi

その他のtips

https://zenn.dev/mashiike/articles/2bd21a9524a8ef

dbt macro tips advent calendar 2022 day 25 - その他のTips