15 questions
0
votes
1
answer
40
views
Replacement newer image for fishtownanalytics/dbt:1.0.0
I could see fishtownanalytics/dbt:1.0.0 is being deprecated? What is the replacement newer image for the same?
- 603
1
vote
1
answer
3k
views
DBT error unrecognized arguments when passing --vars on Windows
My DBT project is highly dependent on receiving variables at runtime. When I pass these variables using the below command I get an error from DBT. The command complies 100% with the documentation . I ...
- 1,174
0
votes
2
answers
2k
views
docker image for dbt-snowflake
How can I run dbt commands within a bitbucket pipeline? What is the correct docker image that I should be using if I wanted to use dbt-snowflake? I tried fishtownanalytics/dbtand joevandyk/dbtboth:
...
user13067694
3
votes
1
answer
5k
views
DBT - use DBT modeling to insert rows in a table like date dimension table in Azure Synapse
I need reference to inserting rows in a table using DBT models. Sample example that can be considered is a date dimension table, where we want to insert rows for next years.
- 693
1
vote
2
answers
3k
views
dbt Error : Encountered an error: 'utf-8' codec can't decode byte 0xa0 in position 441: invalid start byte
I have upgraded my dbt version to 1.0.0 yesterday night and ran few connection test. It went well . Now when i am running the my first dbt example model , i am getting below error , even though i ...
- 316
1
vote
1
answer
1k
views
DBT - best practices on schema to which the dbt deployed models should belong to?
I am working on a database intensive project where there are lots of schemas and tables/views etc that are created in these schemas.
My question is around the best practice or recommended practice on ...
- 693
-2
votes
1
answer
2k
views
Why does "dbt deps" command gives error - Got a non-zero returncode running
I was configuring DBT and when I ran "dbt deps" command end up with an below error
Running with dbt=0.20.0
Encountered an error:
Got a non-zero returncode running: ['C:\\Program Files\\Git\\...
2
votes
1
answer
13k
views
How can I debug the dbt error that says "Database error while listing schemas in database XYZ"?
Thank you for any help/ideas on this.
I am using Snowflake and dbt CLI, with Fivetran as the orchestrator
I added a profile called dev to my profiles.yml and put in all the connection details
profiles....
- 111
2
votes
2
answers
4k
views
DBT(Data Build Tools) - drop the default database prefix that gets added to each model on deployment
In DBT, whenever we deploy the models, the database name gets prefixed to each deployed model in the sql definition in database.
I need to configure the dbt project in a way that it doesn't prefix ...
- 693
2
votes
1
answer
2k
views
DBT - best practices to create staging views for the final business model
I am working on a business model/view, whose raw SQL definition contains a very complex query on the source table.
My question here is - that I need to create multiple staging models on the source ...
- 693
1
vote
3
answers
4k
views
DBT docs generate - How to give the specific branding to the documentation website
How to replace the DBT logo with some other image in the website header, generated by dbt docs generate command.
- 693
4
votes
1
answer
2k
views
DBT docs - How to change the default title and the dbt logo generated by default documentation
DBT docs - I need to configure the following things on the dbt default documentation generated by using dbt docs generate command.
How to change the default title and the dbt logo that appears in the ...
- 693
4
votes
1
answer
2k
views
DBT docs generate - Override the default overview page with custom content in the documentation website
I am using the dbt docs generate for generating my project's documentation website. I want to override the default overview page with my own custom content in the website. Is it possible to do that?
- 693
1
vote
1
answer
4k
views
DBT (Data Build Tools) - Create CI/CD pipeline in Azure DevOps
I am working on a project that uses DBT by Fishtown Analytics for ELT processing. I am trying to create a CI/CD pipeline in Azure DevOps to automate the build release process, but I am unable to find ...
- 693
0
votes
1
answer
6k
views
Error in DBT cloud Server error: Database Error in rpc request (from remote system) syntax error at or near ")"
WITH unioned_product_reports AS(
{% set prod_relations = dbt_utils.get_relations_by_pattern('xyz_shema', 'test_products%') %}
{{ dbt_utils.union_relations(relations = prod_relations) }}
...
- 6,385