Error uploading records to Snowflake stage for Jira stream

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

Summary

The user is facing an error while trying to upload records to a Snowflake stage for the Jira stream. The error indicates that the specified stage does not exist or the user is not authorized to access it.


Question

Hello :wave:
I connected Jira with Snowflake. I hit a rate limit and paused the connector.
However, I see some logs related to Jira stream, any idea on what might be happening here?

airbyte-worker                    | 2024-03-20 22:36:14 destination > net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error:
airbyte-worker                    | 2024-03-20 22:36:14 destination > Stage 'AIRBYTE_DATABASE."airbyte_internal"."AIRBYTE_SCHEMA_raw__stream_issues"' does not exist or not authorized.
airbyte-worker                    | 2024-03-20 22:36:14 destination > 	at net.snowflake.client.jdbc.SnowflakeUtil.checkErrorAndThrowExceptionSub(SnowflakeUtil.java:144) ~[snowflake-jdbc-3.14.1.jar:3.14.1]
airbyte-worker                    | 2024-03-20 22:36:14 destination > 	at net.snowflake.client.jdbc.SnowflakeUtil.checkErrorAndThrowException(SnowflakeUtil.java:77) ~[snowflake-jdbc-3.14.1.jar:3.14.1]```
Thanks in advance.

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1710974424275019) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["error", "uploading-records", "snowflake-stage", "jira-stream", "authorization"]
</sub>