The problem I am having is the model keeps failing when trying to run the Redshift Package Macro Unload. I have tried reaching out to support and they say "lies in the structure or syntax of your dbt project’s code " but will not help unless I upgrade to an Enterprise plan.
Some example code or error messages
My Code
{{
config({
"post-hook": [
"{{ redshift.unload_table('dbt_etl_dev',
'rpt_assurant_for_collection',
s3_path='s3://xxxxx/xxxxx',
iam_role='arn:aws:iam::xxxxxxxxxx:role/xxxxxxx',
header=True,
delimiter=',',
overwrite=true) }}"
]
})
}}
Error Message:
15:02:47 Began running node model.dw_domuso.unload_assurant_for_collection
15:02:47 1 of 1 START view model dbt_etl_dev.unload_assurant_for_collection ............. [RUN]
15:02:47 Acquiring new redshift connection "model.dw_domuso.unload_assurant_for_collection"
15:02:47 Began compiling node model.dw_domuso.unload_assurant_for_collection
15:02:47 Compiling model.dw_domuso.unload_assurant_for_collection
15:02:47 Writing injected SQL for node "model.dw_domuso.unload_assurant_for_collection"
15:02:47 finished collecting timing info
15:02:47 Began executing node model.dw_domuso.unload_assurant_for_collection
15:02:47 Writing runtime SQL for node "model.dw_domuso.unload_assurant_for_collection"
15:02:47 Using redshift connection "model.dw_domuso.unload_assurant_for_collection"
15:02:47 On model.dw_domuso.unload_assurant_for_collection: BEGIN
15:02:47 Opening a new connection, currently in state closed
15:02:47 Redshift adapter: Connecting to Redshift using 'database' credentials
15:02:47 SQL status: BEGIN in 0.03 seconds
15:02:47 Using redshift connection "model.dw_domuso.unload_assurant_for_collection"
15:02:47 On model.dw_domuso.unload_assurant_for_collection: /* {"app": "dbt", "dbt_version": "1.2.4", "profile_name": "user", "target_name": "default", "node_id": "model.dw_domuso.unload_assurant_for_collection"} */
create view "domusodatawarehouse"."dbt_etl_dev"."unload_assurant_for_collection__dbt_tmp" as (
) ;
15:02:47 Postgres adapter: Postgres error: syntax error at or near ")"
LINE 6: ) ;
^
15:02:47 On model.dw_domuso.unload_assurant_for_collection: ROLLBACK
15:02:47 finished collecting timing info
15:02:47 On model.dw_domuso.unload_assurant_for_collection: Close
15:02:47 Database Error in model unload_assurant_for_collection (models/unload/assurant/unload_assurant_for_collection.sql)
syntax error at or near ")"
LINE 6: ) ;
^
compiled SQL at target/run/dw_domuso/models/unload/assurant/unload_assurant_for_collection.sql
15:02:47 Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '23e1f2e3-7565-41d0-9b6c-2398cd19749c', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x7fe3cd939a00>]}
15:02:47 1 of 1 ERROR creating view model dbt_etl_dev.unload_assurant_for_collection .... [ERROR in 0.14s]
15:02:47 Finished running node model.dw_domuso.unload_assurant_for_collection