1,519
questions
0
votes
1
answer
38
views
To make DBT source.yml file dynamic
I want to set database name in source.yml file dynamically in DBT
Currently, I am executing it via AzureADO
current source file is
version: 2
sources:
- name: source
database: db1
I want to ...
0
votes
0
answers
34
views
Trino SQL Server Connector Procedure Error
I am trying to utilize the system.execute procedure from the Trino SQL Server Connector here and am running into issues: https://trino.io/docs/current/connector/sqlserver.html
Trino CALL documentation ...
0
votes
0
answers
24
views
DBT on top of DuckDB is working on first run but not on subsequent runs
When running my DBT code I get a first great output as such:
(.venv) jarich@Jarichs-Air peak_dbt % dbt run
10:32:56 Running with dbt=1.8.6
10:32:56 Registered adapter: duckdb=1.8.3
10:32:56 Found 2 ...
0
votes
0
answers
30
views
dbt 1.8 unit_tests throwing node not found error
I've been trying my first unit_tests in dbt1.8 but, its throwing me compilation error saying "test depends on a node named xyz which was not found
in macro ref (macros/path/ref.sql)". Please ...
0
votes
1
answer
24
views
DBT post_hook macro with arguments in properties.yml
This is a question about dbt + jinja syntax in macro calls and defining this in a schema.yml/properties.yml model file.
I have a working macro definition and inline post-hook config in a model. It ...
0
votes
0
answers
40
views
dbt is unable to change the database when using dbt-sqlserver
I have been trying to integrate dbt with our SQL Server. We are using a dedicated SQL Pool. I followed the instruction to install the relevant packages. The connection was all working fine. This was ...
0
votes
0
answers
15
views
on-run-end failed. error: 'data_quality_log' is undefined
I am working to set hook to load into DB. Set-up for dbt_project.yml file
on-run-end:
- "{{ data_quality_log(results) }}"
Following is the header of my data_quality_log.sql file
{% macro ...
-1
votes
1
answer
16
views
How to install databricks plugin for dbt project
I have a project where I am using dbt.
I have installed dbt core using the command 'pip install dbt-core'
I ran the command 'pip install dbt-databricks'
But when I run the dbt --version, I do not see ...
0
votes
0
answers
33
views
DBT how to configure a models subdirectory?
We have a dbt project that has a lot of teams working on it. We agreed not to touch dbt_project.yml. In order to divide the areas of responsibility, It was decided to allocate their own directories ...
0
votes
0
answers
53
views
dbt error that selection does not match any enabled nodes
I new to DBT and just starting learning it. I was following a Ytube example and getting error while running a .sql file.
I am running below command but getting error, can someone help how to run this ...
1
vote
0
answers
51
views
limit the number of instances of a cloud run job
I'm attempting to restrict the number of identical Cloud Run job instances running concurrently to prevent simultaneous writes to BigQuery tables. However, the --parallelism=1 parameter isn't ...
1
vote
1
answer
53
views
ModuleNotFoundError: No module named 'google' error when trying to run dbt
When trying to run the following command:
dbt run
I get the following error:
Traceback (most recent call last): File "/opt/homebrew/bin/dbt", line 5, in <module> from dbt.cli....
0
votes
2
answers
42
views
dbt Model in VS Code: Error 'Illegal input character \303' with BigQuery
I'm using dbt with VS Code to build a model on BigQuery. I'm encountering the following error:
Syntax error: Illegal input character "\\303" at \[24:15\]
This is my script. I've already ...
0
votes
0
answers
41
views
Getting the warning "Tried to allowlist unknown rule references: ['L100']" when creating custom rule
I am trying to create Sqlfluff custom rules for my team, currently the standard rules are working correctly, but when i try to run the customized rule it results in an error indicating that the custom ...
0
votes
0
answers
31
views
Iterating in SQL (Redshift) through jinja in a dbt model
I have an sql model which only needs to recalculate some of it's data.
Ex: for cols with date and cost, I need to update cost for August with all records till July End
and to update costs for July ...