Stack Overflow
Stack Overflow

Questions tagged [fishtown-analytics]

14 questions
3
votes
1 answer

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.
user961
  • 453
  • 6
  • 20
3
votes
1 answer

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?
user961
  • 453
  • 6
  • 20
1
vote
1 answer

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 have no idea why DBT will reject this command dbt…
Lambo
  • 1,094
  • 11
  • 18
1
vote
2 answers

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 have not changed any code in this default example…
HimanshuSPaul
  • 278
  • 1
  • 4
  • 19
1
vote
1 answer

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 to what schema should all the DBT deployed models…
user961
  • 453
  • 6
  • 20
1
vote
2 answers

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 database name to the deployed models.
user961
  • 453
  • 6
  • 20
1
vote
1 answer

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 table as there are different specific select queries…
user961
  • 453
  • 6
  • 20
1
vote
1 answer

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 browser tab. Also, there is a dbt logo that…
user961
  • 453
  • 6
  • 20
1
vote
1 answer

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 a suitable documentation around it. The code has…
user961
  • 453
  • 6
  • 20
0
votes
2 answers

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: pipelines: custom: test-dbt: - step: …
user13067694
0
votes
1 answer

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.yml now looks like this default: target: prod …
thedre
  • 101
  • 1
  • 4
0
votes
1 answer

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) }} ranking_product_report_rows AS( SELECT *, …
MegaBytes
  • 6,355
  • 2
  • 19
  • 36
-1
votes
3 answers

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.
user961
  • 453
  • 6
  • 20
-2
votes
1 answer

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\\cmd\\git.EXE', 'clone', '--depth', '1',…
Bhupesh Pradhan
  • 39
  • 1
  • 7