Hello, I am working to set up target-redshift, passing an AWS IAM Role ARN to use as authentication for the COPY statement. Data is loaded from my source to S3, but I am getting a Psycopg2 syntax error when the COPY statement is executed by Psycopg2 (doesn't actually hit the cluster):

psycopg2.errors.SyntaxError: syntax error at or near "iam_role"

Has anyone seen this? Using the transferwise variant: https://github.com/transferwise/pipelinewise-target-redshift Here is where the statement is formed: https://github.com/transferwise/pipelinewise-target-redshift/blob/master/target_redshift/db_sync.py#L427 Is there a good way to set debug log level for this loader? Setting Meltano log level does not affect loader log level in my testing

Hey @patrick_leahey - did you confirm that your config looks as expected?

meltano config target-redshift

Everything seems in order when I run what you suggested. I am running Meltano in a container deployed on ECS via Airflow, so that is part of the reason I am having trouble debugging. I likely need to get this going locally again. I had success running locally, and only thing I have added since is the IAM Role ARN

I wonder if the iam_role is a red herring, sometimes the sql errors arent very precise

I have been running this target-redshift plugin using AWS access key and secret environment variables to configure it, and have had no issues.

I am - let me check my config against yours. I appreciate your comment

also just in case it makes a difference, I am explicitly unsetting these environment variables to ensure that the target-redshift uses the default AWS vars:

TARGET_REDSHIFT_AWS_ACCESS_KEY_ID=
TARGET_REDSHIFT_AWS_SECRET_ACCESS_KEY=

Let me try that

I've had that happen before too, error message from data warehouses are always tricky to interpret. Never sure if I can trust them 😆 . Glad you figured it out!