Slim CI with state comparison in dbt - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to enable slim CI by specifying the correct flag.

dbt

dbt run --[1] slim

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

Aenable

Bstate

Cuse

Dwith

Attempts:

3 left

💡 Hint

Common Mistakes

Using '--enable' instead of '--state' will cause an error.

Using '--use' or '--with' are not valid flags for slim CI.

The --state flag is used to enable slim CI by comparing the current state with the previous run.

2fill in blank

medium

Complete the code to specify the path to the previous run's manifest for state comparison.

dbt

dbt run --state [1]

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

Atarget

Btarget/previous

Ctarget/previous/manifest.json

Dtarget/manifest.json

Attempts:

3 left

💡 Hint

Common Mistakes

Using just 'target' or 'target/manifest.json' will not point to the previous run.

Missing the 'previous' folder in the path.

The path target/previous/manifest.json points to the previous run's manifest file used for state comparison in slim CI.

3fill in blank

hard

Fix the error in the command to run dbt with slim CI and state comparison.

dbt

dbt run --state=[1]

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

Atarget/manifest.json

Btarget/previous/manifest.json

Cprevious/manifest.json

Dtarget/previous

Attempts:

3 left

💡 Hint

Common Mistakes

Providing the full manifest file path causes an error.

Using an incomplete or wrong directory path.

The --state flag expects the directory path containing the previous run's manifest, not the manifest file itself.

4fill in blank

hard

Fill both blanks to create a command that runs dbt with slim CI using the correct state directory and selector.

dbt

dbt run --state [1] --select [2]

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

Atarget/previous

Bmodels+

Ctarget

Dsources

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'target' instead of 'target/previous' for state.

Using 'sources' instead of 'models+' for selection.

The --state target/previous flag points to the previous run's state, and --select models+ selects models and their dependencies for the run.

5fill in blank

hard

Fill all three blanks to write a dbt command that runs slim CI with state comparison, specifying the state directory, selector, and output format.

dbt

dbt run --state [1] --select [2] --output [3]

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

Atarget/previous

Bmodels+

Cjson

Dtarget

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'target' instead of 'target/previous' for state.

Using 'sources' instead of 'models+' for selection.

Using 'table' or other formats instead of 'json' for output.

This command runs dbt with slim CI using the previous state directory, selects models and their dependencies, and outputs results in JSON format.