DBT Sources & Seeds Flashcards

What does the `quoting` config on a source control?

Answer: Whether column names are enclosed in quotes in generated SQL

The `quoting:` config specifies whether the database, schema, or identifier portions of a source reference are wrapped in quotes.

How can you add a description to a source table in dbt?

Answer: Use the description: key in the source YAML block

The `description:` field in the source YAML becomes part of the dbt documentation site and catalog.

Which dbt feature allows you to apply a test to all columns of a source table at once using a meta tag?

Answer: Column-level tests defined in schema.yml

Defining tests under each column in the sources YAML lets you attach generic tests like `not_null` or `unique` to individual source columns.

What node selector prefix lets you run `dbt test` on only source tests?

Answer: sources:*

The `sources:` selector prefix targets source nodes, so `dbt test --select sources:` runs only source-defined tests.

Which dbt command generates a freshness report for all sources that have a freshness block defined?

Answer: dbt source freshness

`dbt source freshness` scans each source table's `loaded_at_field` and writes results to `sources.json` in the target/ directory.

What is the default column delimiter used when dbt reads CSV seed files?

Answer: Comma (,)

dbt expects standard CSV format with comma-separated values by default; you can override this with the `delimiter` seed config.