Hi. Has anyone had success with <key-pair authenti...
# advice-data-warehouses
l
Hi. Has anyone had success with key-pair authentication for Snowflake destination on OSS? I'm unsure of the issue just yet and I've tried a handful of variations on the keys and jdbc params. In any case it's throwing the following trace:
Copy code
Could not connect with provided configuration. net.snowflake.client.jdbc.SnowflakeSQLLoggedException: Private key provided is invalid or not supported: rsa_key.p8: Cannot invoke "net.snowflake.client.jdbc.internal.org.bouncycastle.util.io.pem.PemObject.getContent()" because the return value of "net.snowflake.client.jdbc.internal.org.bouncycastle.util.io.pem.PemReader.readPemObject()" is null
Full trace if helpful (separate error message in the UI)
Copy code
2022-09-15 22:42:40 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/10782497-c5b0-405f-bbe8-85bf4eb5a616/0/logs.log
2022-09-15 22:42:40 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.40.0-alpha
2022-09-15 22:42:40 INFO i.a.c.i.LineGobbler(voidCall):83 - Checking if airbyte/destination-snowflake:0.4.36 exists...
2022-09-15 22:42:40 INFO i.a.c.i.LineGobbler(voidCall):83 - airbyte/destination-snowflake:0.4.36 was found locally.
2022-09-15 22:42:40 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 10782497-c5b0-405f-bbe8-85bf4eb5a616
2022-09-15 22:42:40 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/10782497-c5b0-405f-bbe8-85bf4eb5a616/0 --log-driver none --name destination-snowflake-check-10782497-c5b0-405f-bbe8-85bf4eb5a616-0-ifpmb --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/destination-snowflake:0.4.36 -e AIRBYTE_VERSION=0.40.0-alpha -e WORKER_JOB_ID=10782497-c5b0-405f-bbe8-85bf4eb5a616 airbyte/destination-snowflake:0.4.36 check --config source_config.json
2022-09-15 22:42:42 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):99 - integration args: {check=null, config=source_config.json}
2022-09-15 22:42:42 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):99 - Running integration: io.airbyte.integrations.destination.snowflake.SnowflakeDestination
2022-09-15 22:42:42 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):99 - Command: CHECK
2022-09-15 22:42:42 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):99 - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'}
2022-09-15 22:42:43 WARN i.a.w.i.DefaultAirbyteStreamFactory(internalLog):96 - Unknown keyword examples - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword
2022-09-15 22:42:43 WARN i.a.w.i.DefaultAirbyteStreamFactory(internalLog):96 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword
2022-09-15 22:42:43 WARN i.a.w.i.DefaultAirbyteStreamFactory(internalLog):96 - Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword
2022-09-15 22:42:43 WARN i.a.w.i.DefaultAirbyteStreamFactory(internalLog):96 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword
2022-09-15 22:42:43 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):99 - Using destination type: INTERNAL_STAGING
2022-09-15 22:42:43 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):99 - HikariPool-1 - Starting...
2022-09-15 22:42:45 ERROR i.a.w.i.DefaultAirbyteStreamFactory(internalLog):95 - HikariPool-1 - Exception during pool initialization.
2022-09-15 22:42:45 ERROR i.a.w.i.DefaultAirbyteStreamFactory(internalLog):95 - Exception while checking connection: 
2022-09-15 22:42:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):99 - Completed integration: io.airbyte.integrations.destination.snowflake.SnowflakeDestination
2022-09-15 22:42:45 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling...
Linking this related thread here. I'll file an issue for this https://airbytehq.slack.com/archives/C021JANJ6TY/p1660828241962879