Community

๐ŸŒˆ ๋ฐ์ดํ„ฐ์— ์‹ ๋ขฐ์„ฑ๊ณผ ์žฌ์‚ฌ์šฉ์„ฑ๊นŒ์ง€, Analytics Engineering with dbt ๋ฐ์ดํ„ฐ ์—”์ง€๋‹ˆ์–ด๋ง ๋ถ„์•ผ์—์„œ ์ตœ๊ทผ์— ๋งŽ์ด ์–ธ๊ธ‰๋˜๊ณ  ์žˆ๋Š” dbt! ๊ตญ๋‚ด์—์„œ dbt Use Case๋Š” ์•„์ง

๐ŸŒˆ ๋ฐ์ดํ„ฐ์— ์‹ ๋ขฐ์„ฑ๊ณผ ์žฌ์‚ฌ์šฉ์„ฑ๊นŒ์ง€, Analytics Engineering with dbt ๋ฐ์ดํ„ฐ ์—”์ง€๋‹ˆ์–ด๋ง ๋ถ„์•ผ์—์„œ ์ตœ๊ทผ์— ๋งŽ์ด ์–ธ๊ธ‰๋˜๊ณ  ์žˆ๋Š” dbt! ๊ตญ๋‚ด์—์„œ dbt Use Case๋Š” ์•„์ง ๋งŽ์ด ์—†๋Š” ํŽธ์ž…๋‹ˆ๋‹ค. ์˜์นด ๊ธฐ์ˆ  ๋ธ”๋กœ๊ทธ์— dbt ์‚ฌ์šฉ ํ›„๊ธฐ๊ฐ€ ์˜ฌ๋ผ์™€ ๊ณต์œ ํ•ด๋ด…๋‹ˆ๋‹ค! ์˜์นด์˜ ๋ฐ์ดํ„ฐ ์ธํ”„๋ผ๋Š” BigQuery + Airflow + dbt๋กœ ๊ตฌ์„ฑํ•œ๋‹ค๊ณ  ์ดํ•ดํ•ด์ฃผ์…”๋„ ์ข‹์„ ๊ฒƒ ๊ฐ™์•„์š”! โœจ๏ธ ์ถ”์ฒœ๋“œ๋ฆฌ๊ณ  ์‹ถ์€ ๋ถ„ - Analytics Engineer์— ๊ถ๊ธˆํ•˜์‹  ๋ถ„ - dbt๊ฐ€ ๊ถ๊ธˆํ•˜์‹  ๋ถ„ - ๋ฐ์ดํ„ฐ ์—”์ง€๋‹ˆ์–ด์˜ ์ตœ์‹  ํŠธ๋ Œ๋“œ๊ฐ€ ๊ถ๊ธˆํ•˜์‹  ๋ถ„ ๋ชฉ์ฐจ 1. ๋“ค์–ด๊ฐ€๋ฉฐ 1.1. ์˜์นด์˜ ๋ฐ์ดํ„ฐ ์ธํ”„๋ผ 1.2. ์–‘ ๋‚ ์˜ ๊ฒ€ 1.3. Analytics Engineer์˜ ๋“ฑ์žฅ 2. data build tool(dbt) 3. ์œ ์ฆˆ ์ผ€์ด์Šค - SODA Store v2 3.1. ํ”„๋กœ์ ํŠธ ์‹œ์ž‘ ์ „ 3.2. ํ”„๋กœ์ ํŠธ ๊ตฌ์„ฑ 3.3. ๊ฒ€์ฆ 3.4. ๋ฐฐํฌ 3.5. ๊ฒฐ๊ณผ 4. ๊ทธ ๋ฐ–์— ์‹œ๋„ํ–ˆ๋˜ ๊ฒƒ๋“ค 5. ์•Œ๋ฉด ์ข‹์•˜๋˜ ๊ฒƒ๋“ค 6. ๊ฐœ์„ ํ•ด์•ผ ํ•˜๋Š” ์ ๋“ค 7. ๋‚˜์•„๊ฐ€์„œ 8. ๋งˆ์น˜๋ฉฐ

์•Œ๋ฆผ

์•Œ๋ฆผ์ด ์—†์Šต๋‹ˆ๋‹ค