Terug naar Utils

Snippet · dbt

Generate Sources

Kant-en-klare dbt run-operation commando's voor het genereren van sources, stagingmodellen en projectconfiguratie. Kopieer en pas de database- en schemanamen aan.

generate_sources.sql
-- Generate sources.yml for all schemas in a database:
dbt run-operation generate_source_yaml \
  --args '{"database": "MY_DB"}'

-- Or for specific schemas:
dbt run-operation generate_source_yaml \
  --args '{"database": "MY_DB", "schemas": ["RAW", "LANDING"]}'

-- Per-schema split output:
dbt run-operation generate_source_yaml \
  --args '{"database": "MY_DB", "split": true}'


-- Generate staging models (SQL per table):
dbt run-operation generate_staging_models \
  --args '{"database": "MY_DB"}'

-- For specific schemas:
dbt run-operation generate_staging_models \
  --args '{"database": "MY_DB", "schemas": ["RAW"]}'


-- Generate dbt_project.yml snippet:
dbt run-operation generate_dbt_project_snippet \
  --args '{"database": "MY_DB"}'

Meer uitleg over Generate Sources? Bekijk de volledige documentatie →