Configuring sources in YAML in dbt - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to define a source name in YAML.

dbt

sources:
  - name: [1]

Drag options to blanks, or click blank then click option'

Amy_source

Bsource_name

Cdata_source

Dtable_source

Attempts:

3 left

💡 Hint

Common Mistakes

Using spaces in the source name

Omitting the source name

Using invalid characters in the name

The name field defines the source name. Here, my_source is a valid source name.

2fill in blank

medium

Complete the code to specify the database for the source.

dbt

sources:
  - name: my_source
    [1]: analytics_db

Drag options to blanks, or click blank then click option'

Aschema

Bdatabase

Ctable

Dalias

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing schema with database

Omitting the database key

Using an incorrect key name

The database key specifies the database where the source tables reside.

3fill in blank

hard

Fix the error in the source table definition by completing the missing key.

dbt

sources:
  - name: my_source
    database: analytics_db
    tables:
      - [1]: users

Drag options to blanks, or click blank then click option'

Aname

Btable

Csource_table

Dtable_name

Attempts:

3 left

💡 Hint

Common Mistakes

Using table_name instead of name

Using table as the key

Omitting the table name key

The correct key to define a table inside tables is name.

4fill in blank

hard

Fill both blanks to define a source with a schema and a table name.

dbt

sources:
  - name: my_source
    database: analytics_db
    [1]: public
    tables:
      - name: [2]

Drag options to blanks, or click blank then click option'

Aschema

Busers

Ctable

Ddatabase

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up database and schema

Using table instead of name for the table

Omitting the schema key

The schema key defines the schema name, and users is the table name.

5fill in blank

hard

Fill all three blanks to define a source with database, schema, and a table with an alias.

dbt

sources:
  - name: my_source
    [1]: analytics_db
    [2]: sales
    tables:
      - name: orders
        [3]: sales_orders

Drag options to blanks, or click blank then click option'

Adatabase

Bschema

Calias

Dtable

Attempts:

3 left

💡 Hint

Common Mistakes

Using table instead of alias for renaming

Mixing up schema and database keys

Omitting the alias key when renaming

The database and schema keys specify where the source lives. The alias key gives the table a different name in dbt.