You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello,
I'm trying to materialize in DBT cloud a query that is currently running on Google Bigquery, containing a javascript function definition at the beginning.
to clarify, between the {{ config(materialize='table') }}
and the SELECT ...
I have a piece of code in the form of CREATE TEMPORARY FUNCTION match(str1 STRING, str2 STRING) ...
This query works in the preview and works perfectly when launched directly in google bigquery, but it causes an error when launching dbt run.
The issue is: Syntax error: Expected "(" or keyword SELECT or keyword WITH but got keyword CREATE at [...]
Is there a way to tell dbt to ignore a portion of the script and leave it as is in the compiled query without trying to parse it? I already tried with jinja {{ raw }} statement but that didn't work out
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hello,
I'm trying to materialize in DBT cloud a query that is currently running on Google Bigquery, containing a javascript function definition at the beginning.
to clarify, between the
{{ config(materialize='table') }}
and the
SELECT ...
I have a piece of code in the form of
CREATE TEMPORARY FUNCTION match(str1 STRING, str2 STRING) ...
This query works in the preview and works perfectly when launched directly in google bigquery, but it causes an error when launching dbt run.
The issue is:
Syntax error: Expected "(" or keyword SELECT or keyword WITH but got keyword CREATE at [...]
Is there a way to tell dbt to ignore a portion of the script and leave it as is in the compiled query without trying to parse it? I already tried with jinja
{{ raw }}
statement but that didn't work outThank you,
Matteo
Beta Was this translation helpful? Give feedback.
All reactions