Issues with Airbyte to Snowflake connection

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Multiple clients experiencing job failures when connecting Airbyte to Snowflake due to an invalid identifier error related to ‘_airbyte_meta’.


Question

Anyone having issues with Airbyte -> Snowflake this am? I have multiple clients / airbyte cloud instances failing jobs to Snowflake

All getting this error

Warning from destination: java.lang.RuntimeException: SQL compilation error: error line 72 at position 12 invalid identifier ‘“_airbyte_meta”’ in SYSTEM$MULTISTMT at ’ throw Execution of multiple statements failed on statement {0} (at line {1}, position {2})..replace(‘{1}’, LINES[i])’ position 4 stackstrace: SYSTEM$MULTISTMT line: 10


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["airbyte", "snowflake", "connector", "invalid-identifier", "job-failure"]
2

<@U02TQLBLDU4> Any update on this? This is obviously a critical issue so would appreciate any updates you have so we can communicate

3

PR with the fix is up https://github.com/airbytehq/airbyte/pull/39399

4

<@U02TQLBLDU4> I see the PR was merged. When can we expect it to be live in airbyte cloud and the connector to be working again?

5

going to do the rest now

6

hm okay mine just failed again. will try again

7

Yes all good thank you <@U02TQLBLDU4>

8

<@U01MMSDJGC9> should upgrading to latest version fix the issue?
Im using OSS

9

Also having this issue, think it might be caused by this pr yesterday: https://github.com/airbytehq/airbyte/pull/39107

10

I haven’t found a solution yet, so waiting for morning time in SF when they unbreak the connector

11

Ok glad I’m not alone – I haven’t ever had an issue like this w/Airbyte, so typically they will roll this back pretty quickly ? Checking the PR you linked now

12

oh yes i see they even got a similar error in testing:

13

Hello :wave: the team is investigating the issue. Any update we’re going to return here and in the issue.

14

Thank you <@U02TQLBLDU4>!

15

FYI having the same issue on multiple connectors with Snowflake as the destination

16

All these tried 15+ times, not looking forward to my Snowflake bill

17

I retried one and working now (i’m using cloud)

18

I got a clean run FYI

19

All mine are working now

20

Good to hear, <@U01ULRF8F89> are you good now?