Relative Content

Tag Archive for dbt

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?

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?

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 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.