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 →