Hi all, trying to use dbt-snowflake utilities to ...
# getting-started
k
Hi all, trying to use dbt-snowflake utilities to transform source data. upon hitting the command 'meltano invoke dbt-snowflake:run' , I am getting following error, the flow is very simple source->dbt transform to create model. but getting syntax error! not sure where i am making mistake, here the code snippet of SQL.
Copy code
001003 (42000): SQL compilation error:
  syntax error line 5 at position 0 unexpected '{'.
  syntax error line 8 at position 0 unexpected '}'.
here the SQL meltano trying to run
Copy code
{% raw %}
{{
  config(
    materialized='table' 
    )

with base as (
    select *
    from {{ source('my_schema', 'Sample_sales_data') }} 
)
select distinct  "UNIFIED LINEITEM NAME" as unique_menu_name
from base
where unique_menu_name is not null

{% endraw %}
z
looks like you may be missing the closing
}}
for the config block
k
in above code it was not there but code i am running have those }} and same error is appearing.!
let me see how it's forming underling SQL ..
got fixed, my source.yml had wrong name, however the dbt utility provided by meltano is dbt-core or dbt-cloud one?