- Is this your first time deploying Airbyte?: No
- OS Version / Instance: EC2 t2.large
- Memory / Disk:
- Deployment: Docker
- Airbyte Version: 0.36.2-alpha
- Source name/version: google-analytics 0.1.19
- Destination name/version: redshift 0.3.32
- Step: Sync
When loading to S3 prior to copying to redshift, airbyte is erroring out (specific operation below, logs attached). Downgrading to 0.3.28 resolves the issue. And, interestingly enough, performing the same sync without first copying to S3 (e.g., just INSERTing to redshift) works on 0.3.32.
2022-04-28 16:03:43 destination > 2022-04-28 16:03:43 INFO i.a.i.d.r.RedshiftSqlOperations(onDestinationCloseOperations):110 - Executing operations for Redshift Destination DB engine... 2022-04-28 16:03:43 destination > 2022-04-28 16:03:43 INFO i.a.i.d.r.RedshiftSqlOperations(discoverNotSuperTables):129 - Discovering NOT SUPER table types... 2022-04-28 16:03:43 destination > 2022-04-28 16:03:43 ERROR i.a.i.d.r.RedshiftSqlOperations(discoverNotSuperTables):146 - Error during discoverNotSuperTables() appears: 2022-04-28 16:03:43 destination > java.sql.SQLException: [Amazon](500310) Invalid operation: syntax error at or near "null"
logs-2275.txt (95.7 KB)