dbt_rpc v0.3.3 cannot process the “list” command
Is there support for the list command in rpc?
Changing a dbt model materialization in production
In dbt, if a model was initially deployed as a view in production, and in the next version of your dbt project, your team decides to change it to a table, what is the proper way to deploy the project to avoid getting an error during dbt run?
DBT:How to get macros executed in overview.md which is used to overide the dbt docs main page
Requirement: To get datetimestamp in the main page of the dbt docs site , so that we know when it was last refreshed
Run a model and store its value to a variable
We execute one SQL with cursor and extract variable to set some variables in Snowflake. How to do it efficiently in dbt? Can I set values of variables from the results of a model?
DBT – Run a model and store it’s value to a variable
We execute one sql with cursor and extract variable to set some variables in snowflake. How to do it efficiently in dbt? Can I set values of variables from the results of a model?
Understanding dbt Model Execution
I’ve been building some models using staging/intermediate/marts practices. Let’s assume I have some queries in the marts layer that are connected to the intermediate layer, and those queries in the intermediate layer are referenced to the staging layer. Also, let’s assume I run these two commands:
dbt run appending schema name from both profiles.yml and dbt_project.yml
I have a folder within model and my files within the subfolder. When I run the model, it creates a schema and table in my destination but the schema name is not getting picked from dbt_projects.yml rather it appends both schema name from profiles and dbt_project
DBT schema problems using external
The problem I’m having Hello! I don’t have much experience with dbt. I am trying to create a table via an external table in Databricks. I have it defined in raw/source.yaml as follows: – name: table_1 freshness: warn_after: {count: 12, period: hour} error_after: {count: 24, period: hour} external: location: “{{‘s3://datahub-‘ + env_var(‘environment’) + ‘-raw/table_1/’}}” using: […]
DBT Core Execution Log
I’m using DBT core and storing my models into a SQL Server DBT, and trying to find a way to write the execution log of each model into a table DB. The really basics, like DBT Project; DBt Model; Execution Start; Execution End; Status
Goal ultimately is to get an history and monitor the models execution from there.
DBT ‘dbt’ is not recognized as an internal or external command when running from Task Scheduler
I’m trying to move my DBT orchestration from an old remote Windows server v2016 to a v2022. I have big limitations, starting from the fact that I’m working with DBT core and that I can’t use any orchestration tool like dagster. So we made it run via the good old Task Scheduler on the v2016. On top of this the v2022 doesn’t have internet access.