Configuring sources in YAML in dbt - Quick Revision & Summary

Recall & Review

beginner

What is the purpose of configuring sources in YAML in dbt?

Configuring sources in YAML in dbt helps define where your raw data lives. It tells dbt which tables or files to use as inputs for your transformations.

beginner

In a dbt source configuration YAML, what key is used to list the tables or files?

The key tables is used to list the tables or files under a source in the YAML configuration.

intermediate

How do you specify the database and schema for a source in dbt YAML?

You specify the database and schema keys under the source name to tell dbt where to find the source data.

beginner

What is the benefit of adding descriptions to sources and tables in YAML?

Adding descriptions helps document your data sources clearly. It makes it easier for anyone reading the project to understand what each source and table represents.

beginner

Show a simple example of a source configuration in YAML for a source named 'raw_data' with one table 'users'.

Example:

sources:
  - name: raw_data
    database: analytics_db
    schema: public
    tables:
      - name: users
        description: 'User information table'

Which key in a dbt YAML source config lists the tables?

A tables

B columns

C sources

D models

The tables key lists the tables under a source.

Where do you specify the schema for a source in dbt YAML?

A Under the source name using the <code>schema</code> key

B Inside each table definition

C In the dbt_project.yml file

D In the model SQL files

The schema key is set under the source name to tell dbt where to find the source.

Why add descriptions to sources and tables in YAML?

A To change table names

B To speed up data loading

C To define SQL queries

D To improve documentation and clarity

Descriptions help document the data sources for better understanding.

What is the top-level key used to define sources in a dbt YAML file?

A models

B sources

C tables

D schemas

The top-level key sources holds all source definitions.

In dbt, what does a source configuration NOT include?

A Database and schema location

B List of tables

C SQL transformation logic

D Descriptions

SQL transformation logic is written in model files, not in source YAML configurations.

Explain how to configure a source in dbt using YAML. Include keys you would use and why.

Think about how you tell dbt where your raw data lives and what tables it includes.

Describe the benefits of documenting sources and tables with descriptions in your YAML configuration.

Why is it good to add notes about your data?