Hi Team, Looking for some help.The current stack we have is snowflake, dbt core, fivetran. We are in process of moving to redshift and dbt. We have few snapshot which we are trying to load however running into errors. Getting below mentioned errors–
syntax error at or near ")"
It looks like redshift it’s not recognizing columns.The issue arises when dbt writes the DML to insert new rows in the existing Redshift table. Have tried giving columns in quotes too, didn’t help. Version of dbt core 1.3.1, version of redshift adapter 1.4.1, version of postgres in actual db is 8. Kindly suggest
I went through various git issues and have tried putting " quotes around field name. Thta didn’t really help.
My snapshot looks like this-
{% snapshot autorenewals_snapshot_06 %}
{{
config(
target_database= var('snapshot_db_config'),
target_schema=var('snapshot_schema_config'),
unique_key='ID',
strategy='timestamp',
updated_at='LAST_MODIFIED',
invalidate_hard_deletes=True,
tags=['Daily-Scheduled','Weekly']
)
}}
select
*
from {{ source( ‘sourcename’, ‘tablename’ ) }}
{% endsnapshot %}
–Also we noticed one wierd thing, snapshot model ran for teh first time, however since second run it’s failing.