了解 dbt 為何而生，以及如何用它來建立資料轉換專案。

dbt 基礎

This is the code editor window. The terminal window is the panel below.

Run the following command in the terminal area:
  
dbt

執行 dbt 指令

認識 dbt

dbt 的版本

取得說明

選項

可能會使用 dbt

不太可能使用 dbt

dbt 的使用者

建立 dbt 專案

Project Name: nyc_yellow_taxi
Database type: duckdb


Run the following commands in the terminal window:


dbt init


Note: You will need to specify the project name (nyc_yellow_taxi) and
select the database type ([1] duckdb)
  
Once complete run:
  
cd nyc_yellow_taxi

ls


初始化一個 dbt 專案

# Modify the project name
____:
  outputs:
    dev:
      # Change the database type
      type: ____
      path: dbt.duckdb
  target: dev


nyc_yellow_taxi:
  outputs:
    dev:
      type: duckdb
      path: dbt.duckdb
  target: dev
  



# Name your project! Project names should contain only lowercase characters
# and underscores. A good package name should reflect your organization's
# name or the intended use of these models
name: 'taxi_project'
version: '1.0.0'
config-version: 2

# This setting configures which "profile" dbt uses for this project.
profile: 'nyc_yellow_taxi'

# These configurations specify where dbt should look for different types of files.
# The `model-paths` config, for example, states that models in this project can be
# found in the "models/" directory. You probably won't need to change these!
model-paths: ["models"]
analysis-paths: ["analyses"]
test-paths: ["tests"]
seed-paths: ["seeds"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]

target-path: "target"  # directory which will store compiled SQL files
clean-targets:         # directories to be removed by `dbt clean`
  - "target"
  - "dbt_packages"


# Configuring models
# Full documentation: https://docs.getdbt.com/docs/configuring-models

# In this example config, we tell dbt to build all models in the example/
# directory as views. These settings can be overridden in the individual model
# files using the `{{ config(...) }}` macro.
models:
  nyc_yellow_taxi:
  # Config indicated by + and applies to all files under models/example/
    taxi_rides:
    +materialized: view


{{ config(materialized='view')}}


with src_data as (
    select * from read_parquet('yellow_tripdata_2023-01-partial.parquet')
)

select * from source_data


nyc_yellow_taxi:
  outputs:
    dev:
      type: duckdb
      path: dbt.duckdb
  target: dev


Run the following command in the terminal after editing the profiles.yml file:
  
dbt debug


建立專案設定檔（profile）

歡迎使用 dbt

透過操作資料模型並在 dbt 中建立以 SQL 為基礎的模型，深入掌握 dbt 的核心。你會學到基本的 SQL 模型、定義相依性、進行更新，並排除各種模型問題。

第一個專案實作

dbt 專案工作流程

執行專案

什麼是 dbt 模型？

資料模型的特性

建立一個 dbt 模型

更新 dbt 模型

設定檔

更新一個 dbt 模型

dbt 專案與模型

學習如何使用 Jinja 樣板簡化 dbt 模型，並以 `ref` 函式定義階層式相依性，確保模型正確執行。

取得說明

dbt 入門

練習說明

動手互動練習