I m still having an issue with Snowflake s destination It gi

Question

I m still having an issue with Snowflake s destination It gives me a Non Json response error I can set up Snowflake source without any issues

Saj Dider (Airbyte) · Answer

Hey < Leo G> are there any logs you can provide What version of airbyte are you using what version connector are you using for snowflake Anything specific about your setup

Leo G · Answer

I m using the latest version I pulled it from git a couple of days ago There is nothing special I think As I said I can create the Snowflake source and test it fine but when I try to make the same instance I get this non json error while the testing process I can try to pull logs from Setting gt Configuration for server logs Is that the logs you want me to post

Leo G · Answer

Here are some java errors in the log

Leo G · Answer

2022 11 03 14 35 41 33mWARN m i a s s AirbyteGithubStore getLatestSources 69 Unable to retrieve latest Source list from Github Using the list bundled with Airbyte This warning is expected if this Airbyte cluster does not have internet access ssl SSLHandshakeException PKIX path building failed sun security provider certpath SunCertPathBuilderException unable to find valid certification path to requested target at http HttpClientImpl send HttpClientImpl java 851 ~ java net http at http HttpClientFacade send HttpClientFacade java 123 ~ java net http at io airbyte server services AirbyteGithubStore getFile AirbyteGithubStore java 83 ~ io airbyte airbyte server 0 40 17 jar at io airbyte server services AirbyteGithubStore getLatestSources AirbyteGithubStore java 67 ~ io airbyte airbyte server 0 40 17 jar

Leo G · Answer

I think I found something

Leo G · Answer

```2022 11 02 15 43 54 INFO i a c i LineGobbler voidCall 114 airbyte destination snowflake 0 4 38 not found locally Attempting to pull the image 2022 11 02 15 48 53 ERROR i t i s WorkflowExecuteRunnable logWorkflowExecutionException 125 Workflow execution failure WorkflowId=9ff7dd03 33d9 45a9 9acd 1e221261410b RunId=1b705d4d b3c7 4a9b b553 860ba5f2073c WorkflowType=CheckConnectionWorkflow io temporal failure ActivityFailure scheduledEventId=6 startedEventId=7 activityType= RunWithJobOutput activityId= bb22476c 3d0b 3286 8106 215581463313 identity= retryState=RETRY STATE NON RETRYABLE FAILURE```

Leo G · Answer

< Sajarin Dider> Any suggestions

Saj Dider (Airbyte) · Answer

Hey < Leo G> update to the latest version of AIrbyte and retry the setup Secondly could you tell me more about how you deployed your airbyte instance Not sure why you re getting SSLHandshake exceptions

Leo G · Answer

< Sajarin Dider> I downloaded the docker desktop and followed

Leo G · Answer

git clone <https github com airbytehq airbyte git> cd airbyte docker compose up

Leo G · Answer

I had to use ```git c http sslverify=false clone <https github com airbytehq airbyte git>```

Saj Dider (Airbyte) · Answer

Are you using wsl2

Saj Dider (Airbyte) · Answer

Leo G · Answer

About WSL2 I think I m as it was part of the Docker desktop install My work laptop is very limited admin rights wise

Leo G · Answer

The SSL errror does not make sense because source connector uses SSL as well Am I right

Leo G · Answer

Is there a stable branch

Saj Dider (Airbyte) · Answer

You can try downgrading to v0 40 14 but I m not sure how effective that would be The setup seems to fail when it tries to fetch the latest image for the snowflake destination which implies a network issue I m wondering if when you ran the snowflake source connector if it also repeated the same airbyte source snowflake not found locally attempting to pull image message

Leo G · Answer

If I want to start over then how do I do it

Saj Dider (Airbyte) · Answer

Remove the repo directory restart docker and then try the steps for local deployment again

Leo G · Answer

So I see snowflake source but not destination

Leo G · Answer

If I look inside wsl$ docker desktop where should see if snowflake destination has been downloaded

Leo G · Answer

I re did the whole thing and I see some error ERROR i m s DefaultTaskExceptionHandler handle 47 Error invoking scheduled task for bean io airbyte cron selfhealing Temporal 7d1c8878 NOT FOUND Namespace name default not found

Leo G · Answer

< Sajarin Dider>

Leo G · Answer

Now logs show this airbyte worker | 2022 11 03 20 10 36 INFO i a c i LineGobbler voidCall 114 airbyte destination snowflake 0 4 38 not found locally Attempting to pull the image airbyte cron | 2022 11 03 20 10 51 INFO i a c s DefinitionsUpdater updateDefinitions 54 Connector definitions update disabled

Leo G · Answer

Now I can t create snowflake source connection either

Saj Dider (Airbyte) · Answer

Can you post the full logs

Saj Dider (Airbyte) · Answer

What version of Airbyte are you running

Leo G · Answer

How do I post logs

Leo G · Answer

the latest 0 40 18

Leo G · Answer

Now it downloaded snowflake source but still no snowflake destination Can I pull it manually

Leo G · Answer

Here is the latest log for snowflake destination ```airbyte worker | 2022 11 03 22 12 12 INFO i a c i LineGobbler voidCall 114 START CHECK airbyte worker | 2022 11 03 22 12 12 INFO i a c i LineGobbler voidCall 114 airbyte worker | 2022 11 03 22 12 12 INFO i a c i LineGobbler voidCall 114 Checking if airbyte destination snowflake 0 4 38 exists airbyte worker | 2022 11 03 22 12 12 INFO i a c i LineGobbler voidCall 114 airbyte destination snowflake 0 4 38 not found locally Attempting to pull the image airbyte temporal | level info ts 2022 11 03T22 12 16 038Z msg none service matching component matching engine wf task queue name sys CONNECTION UPDATER 1 wf task queue type Workflow lifecycle Starting logging call at taskQueueManager go 238 airbyte temporal | level info ts 2022 11 03T22 12 16 038Z msg none service matching component matching engine wf task queue name sys CONNECTION UPDATER 1 wf task queue type Workflow lifecycle Started logging call at taskQueueManager go 242 airbyte server | 2022 11 03 22 12 21 INFO i a s RequestLogger filter 112 REQ 172 18 0 4 GET 200 api v1 health airbyte webapp | 172 18 0 9 airbyte 03 Nov 2022 22 12 21 +0000 GET api v1 health HTTP 1 0 200 18 Mozilla 5 0 Windows NT 10 0 Win64 x64 AppleWebKit 537 36 KHTML like Gecko Chrome 107 0 0 0 Safari 537 36 Edg 107 0 1418 26 172 18 0 1 airbyte proxy | 172 18 0 1 airbyte 03 Nov 2022 22 12 21 +0000 GET api v1 health HTTP 1 1 200 18 Mozilla 5 0 Windows NT 10 0 Win64 x64 AppleWebKit 537 36 KHTML like Gecko Chrome 107 0 0 0 Safari 537 36 Edg 107 0 1418 26 airbyte server | 2022 11 03 22 12 29 INFO i a s RequestLogger filter 112 REQ 172 18 0 4 GET 200 api v1 health airbyte webapp | 172 18 0 9 airbyte 03 Nov 2022 22 12 29 +0000 GET api v1 health HTTP 1 0 200 18 Mozilla 5 0 Windows NT 10 0 Win64 x64 AppleWebKit 537 36 KHTML like Gecko Chrome 107 0 0 0 Safari 537 36 Edg 107 0 1418 26 172 18 0 1 airbyte proxy | 172 18 0 1 airbyte 03 Nov 2022 22 12 29 +0000 GET api v1 health HTTP 1 1 200 18 Mozilla 5 0 Windows NT 10 0 Win64 x64 AppleWebKit 537 36 KHTML like Gecko Chrome 107 0 0 0 Safari 537 36 Edg 107 0 1418 26 airbyte temporal | level info ts 2022 11 03T22 12 32 274Z msg Get dynamic config name frontend sendRawWorkflowHistory value false default value false logging call at config go 79 airbyte cron | 2022 11 03 22 12 33 INFO i a c s DefinitionsUpdater updateDefinitions 54 Connector definitions update disabled ```

Leo G · Answer

< Sajarin Dider> Any other ideas

Leo G · Answer

< Sajarin Dider> What does Connector definitions update disabled ```airbyte worker | 2022 11 07 17 57 35 INFO i a w t TemporalAttemptExecution get 141 Executing worker wrapper Airbyte version 0 40 18 airbyte worker | 2022 11 07 17 57 35 INFO i a c i LineGobbler voidCall 114 airbyte worker | 2022 11 07 17 57 35 INFO i a c i LineGobbler voidCall 114 START CHECK airbyte worker | 2022 11 07 17 57 35 INFO i a c i LineGobbler voidCall 114 airbyte worker | 2022 11 07 17 57 35 INFO i a c i LineGobbler voidCall 114 Checking if airbyte destination snowflake 0 4 38 exists airbyte worker | 2022 11 07 17 57 35 INFO i a c i LineGobbler voidCall 114 airbyte destination snowflake 0 4 38 not found locally Attempting to pull the image airbyte server | 2022 11 07 17 57 44 INFO i a s RequestLogger filter 112 REQ 172 18 0 4 GET 200 api v1 health airbyte webapp | 172 18 0 9 airbyte 07 Nov 2022 17 57 44 +0000 GET api v1 health HTTP 1 0 200 18 Mozilla 5 0 Windows NT 10 0 Win64 x64 AppleWebKit 537 36 KHTML like Gecko Chrome 107 0 0 0 Safari 537 36 Edg 107 0 1418 35 172 18 0 1 airbyte proxy | 172 18 0 1 airbyte 07 Nov 2022 17 57 44 +0000 GET api v1 health HTTP 1 1 200 18 Mozilla 5 0 Windows NT 10 0 Win64 x64 AppleWebKit 537 36 KHTML like Gecko Chrome 107 0 0 0 Safari 537 36 Edg 107 0 1418 35 airbyte cron | 2022 11 07 17 57 54 INFO i a c s DefinitionsUpdater updateDefinitions 54 Connector definitions update disabled airbyte server | 2022 11 07 17 58 04 INFO i a s RequestLogger filter 112 REQ 172 18 0 4 GET 200 api v1 health airbyte webapp | 172 18 0 9 airbyte 07 Nov 2022 17 58 04 +0000 GET api v1 health HTTP 1 0 200 18 Mozilla 5 0 Windows NT 10 0 Win64 x64 AppleWebKit 537 36 KHTML like Gecko Chrome 107 0 0 0 Safari 537 36 Edg 107 0 1418 35 172 18 0 1 airbyte proxy | 172 18 0 1 airbyte 07 Nov 2022 17 58 04 +0000 GET api v1 health HTTP 1 1 200 18 Mozilla 5 0 Windows NT 10 0 Win64 x64 AppleWebKit 537 36 KHTML like Gecko Chrome 107 0 0 0 Safari 537 36 Edg 107 0 1418 35 airbyte cron | 2022 11 07 17 58 24 INFO i a c s DefinitionsUpdater updateDefinitions 54 Connector definitions update disabled ```

Saj Dider (Airbyte) · Answer

Hey < Leo G> sorry for the delay in response we re dealing with an influx of user questions and are trying our best to reply to everyone Not sure why Connector definitions have been disabled Could you try downgrading to an earlier version of Airbyte I ve been seeing a lot of people get the non json error Some people have said it was due to a network issue and some people have said they started seeing the error from the latest version

Leo G · Answer

< Saj Dider Airbyte > Which version would you recommend

Saj Dider (Airbyte) · Answer

Perhaps 0 40 16

Leo G · Answer

< Saj Dider Airbyte > How do I get it from GitHub Can you put the actual command Thanks

AJ · Answer

I am having a similar issue were you able to get past this issue < Leo G>

Fabiano Pena · Answer

Hi < Leo G> I am having the same issue Did you find a solution

Fabiano Pena · Answer

< Marcos Marx Airbyte > I have downgraded from 0 40 12 to 0 39 41 and it worked

Saj Dider (Airbyte) · Answer

< Leo G> sorry for the long delay in response Were you able to get this working If not could you try downgrading to 0 39 41 Hopefully we can get this working on our latest version soon

Scott DeMarzio · Answer

Seeing the same issue in version 0 40 32 setting up the snowflake destination Appears to have the problem of getting the image 2023 02 18 23 04 00 INFO i a c i LineGobbler voidCall 114 START CHECK 2023 02 18 23 04 00 INFO i a c i LineGobbler voidCall 114 2023 02 18 23 04 00 INFO i a c i LineGobbler voidCall 114 Checking if airbyte destination snowflake 0 4 47 exists 2023 02 18 23 04 00 INFO i a c i LineGobbler voidCall 114 airbyte destination snowflake 0 4 47 not found locally Attempting to pull the image 2023 02 18 23 04 12 ERROR i a w g DefaultCheckConnectionWorker run 124 Unexpected error while checking connection io airbyte workers exception WorkerException Could not find image airbyte destination snowflake 0 4 47

Scott DeMarzio · Answer

The source connection to snowflake is working Following other suggestions i downgrade to 0 39 41 and the snowflake destination is now working Running on AWS Linux 2 git clone <https github com airbytehq airbyte git> docker compose up Interesting the destination snowflake source is working on local development on windows 10 Ubuntu 20 04 but need to have this working on EC2 Is there a planned fix on this

Saj Dider (Airbyte) · Answer

< Scott DeMarzio> are there any logs you can provide from the EC2 instance

Scott DeMarzio · Answer

I refer edto this ticket issue about pulling the destination docker image directly I also rebuilt the environment mkdir airbyte amp amp cd airbyte wget docker compose up d going thru this and it appears to be working now

Scott DeMarzio · Answer

Thanks for the followup