- Is this your first time deploying Airbyte?: Yes
- OS Version / Instance: Ubuntu 22.04
- Memory / Disk: 1 Tb
- Deployment: Docker?
- Airbyte Version: 0.44.3
- Destination name/version: Redshift 0.4.5
- Step: Creation
Hi, I am trying to create a destination for Redshift Serverless and I am encountering the issue of connecting to the endpoint (log attached below). I have tried several things:
-
I have already allowed my port of 5439 as recommended by (Destination-Redshift: Destination not connecting for the Redshift Serverless data warehouse).
-
I have verified my username/password using dbeaver to connect directly to my endpoint with JDBC (it works)
Many thanks,
Here’s the error log:
2023-05-09 19:17:24 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):317 - INFO i.a.i.b.IntegrationRunner(runInternal):110 Integration config: IntegrationConfig{command=CHECK, configPath=‘source_config.json’, catalogPath=‘null’, statePath=‘null’}
2023-05-09 19:17:24 WARN i.a.w.i.VersionedAirbyteStreamFactory(internalLog):314 - WARN c.n.s.JsonMetaSchema(newValidator):278 Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword
2023-05-09 19:17:24 WARN i.a.w.i.VersionedAirbyteStreamFactory(internalLog):314 - WARN c.n.s.JsonMetaSchema(newValidator):278 Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword
2023-05-09 19:17:24 WARN i.a.w.i.VersionedAirbyteStreamFactory(internalLog):314 - WARN i.a.i.d.r.RedshiftDestination(determineUploadMode):56 The “standard” upload mode is not performant, and is not recommended for production. Please use the Amazon S3 upload mode if you are syncing a large amount of data.
2023-05-09 19:17:24 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):317 - INFO i.a.i.d.j.c.SwitchingDestination(check):55 Using destination type: STANDARD
2023-05-09 19:17:24 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):317 - INFO i.a.i.b.s.SshTunnel(getInstance):204 Starting connection with method: NO_TUNNEL
2023-05-09 19:17:24 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):317 - INFO c.z.h.HikariDataSource():80 HikariPool-1 - Starting…
2023-05-09 19:17:24 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):317 - INFO c.z.h.HikariDataSource():82 HikariPool-1 - Start completed.
2023-05-09 19:18:24 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):317 - INFO c.z.h.HikariDataSource(close):350 HikariPool-1 - Shutdown initiated…
2023-05-09 19:18:26 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):317 - INFO c.z.h.HikariDataSource(close):352 HikariPool-1 - Shutdown completed.
2023-05-09 19:18:26 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):317 - INFO i.a.i.b.IntegrationRunner(runInternal):186 Completed integration: io.airbyte.integrations.destination.redshift.RedshiftDestination
2023-05-09 19:18:26 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):317 - INFO i.a.i.d.r.RedshiftDestination(main):76 completed destination: class io.airbyte.integrations.destination.redshift.RedshiftDestination
2023-05-09 19:18:27 INFO i.a.w.g.DefaultCheckConnectionWorker(run):115 - Check connection job received output: io.airbyte.config.StandardCheckConnectionOutput@4f72b391[status=failed,message=State code: HY000; Error code: 500101; Message: Amazon Error authenticating with database:
Authentication: isAuthenticationOK - false
isKerberos5Required - false
isClearTextPasswordRequired - false
isMD5PasswordRequired - false
isSCMCredentialsMessageRequired - false
isGSSAPIAuthenticationRequired - false
isSSPIAuthenticationRequired - false
isGSSContinue - false,additionalProperties={}]
2023-05-09 19:18:27 INFO i.a.w.t.TemporalAttemptExecution(get):163 - Stopping cancellation check scheduling…