Questions tagged [dbt-bigquery]
4 questions
1
vote
1 answer
How can I resolve this error regarding dbt templater? Templater cannot be set in a .sqlfluff file in a subdirectory of the current working directory
I am trying to use dbt templater with pre-commit hooks, but I am constantly receiving this error message:
Attempt to set templater to dbt failed. Using jinja templater. Templater cannot be set in a .sqlfluff file in a subdirectory of the current…
shrimpini
- 41
- 3
1
vote
1 answer
Resolving conflicts in python library dependency versions in apache/airflow docker image (due to dbt-bigquery library)
#15 ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
#15 google-cloud-aiplatform 1.16.1 requires…
Canovice
- 9,012
- 22
- 93
- 211
0
votes
0 answers
dbt run_query() with a where clause based on argument
I am trying to set query and call run_query() in a dbt macro called get_records but unable to set the query correctly using the argument in the where clause. Here is the macro:
{% macro get_records(lead_id) %}
{% set sql_statement %}
…
Faisal Maqbool
- 121
- 1
- 8
0
votes
1 answer
Looping through struct column to get conditional outcome as new columns
Say I have a table in BQ called rating with a struct column called rating_record. Schema as:
[
{
"name": "id",
"mode": "NULLABLE",
"type": "STRING",
"description": null,
"fields": []
},
{
"name": "rating_record",
…
Faisal Maqbool
- 121
- 1
- 8