Breaking News: Grepper is joining You.com. Read the official announcement!

dbt seed and source

Innocent Iguana answered on May 14, 2024 Popularity 3/10 Helpfulness 7/10

answer dbt seed and source

dbt seed and source

Comment

# This is your "source.yml"
version: 2

sources:
      - name: db_name
        schema: schema_name
        tables:
            - name: t1
              identifier: raw_table1

            - name: t2
              identifier: raw_table2

            - name: t3
              identifier: raw_table3
              loaded_at_field: date_col # This is the column dbt will keep track of to see if new data is coming in
              freshness:
                warn_after: {count: 1, period: hour}      # will produce a warning message after 1 hour of no fresh data
                error_after: {count: 24, period: hour}    # will produce a error message after 24 hours of no fresh data


# this is your src_model where you import data from raw table
{{ config(materialized = 'table',) }}
WITH cte AS (
    SELECT * FROM {{ source('db_name','t1') }}
    )
SELECT * FROM cte

### cli commands 

Run command : "dbt compile"
Run command : "dbt source freshness"

########### Seeding ###############
# When you want to upload a local small data file
# Just copy the file in the `seed` folder
# run command `dbt seed`
# The file (eg: `data.csv`) will be uploaded to snowflake as table
# Naming best practice: use the seed data file name as `seed_data.csv`

Popularity 3/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: dbt seed sql

Link to this answer
Share Copy Link

Contributed on May 14 2024

Innocent Iguana

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

dbt seed and source

Contents

More Related Answers

dbt seed and source

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.