Error with S3 Connector in Airbyte OSS on EC2 Instance

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

Summary

Encountering error during initial import process with S3 connector in Airbyte OSS on EC2 instance. Error related to ‘describe’ command in Snowflake logs.


Question

Hi there.!!!
We’ve set up AirByte OSS on an EC2 instance and are currently testing the S3 connector. However, we’re encountering an error during the initial import process. The error message has been attached as a snippet.
We are using an account with ACCOUNTADMIN permissions, so we believe there should not be any issues with access rights.
Upon checking the Snowflake logs, it appears the system is attempting to execute a describe command, which is failing.
Could anyone provide insights on how to resolve this issue?


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

["error", "s3-connector", "airbyte-oss", "ec2-instance", "snowflake", "describe-command"]
2

Based on the error message, it seems snowflake is trying to look for this table XXX.YYY.ZZZ , but it either does not exist or the account being used by Airbyte does not have permission to access it. So I would check out if the account can run describe on this table first, or if the table exists.

3

Thank you for your advice.
The issue occurred when I set SYSADMIN or ACCOUNTADMIN as the role for the Snowflake Destination. However, when I set a custom role, the synchronization worked without any issues