RVR-SNF-003

1. Issue Summary

   • The error code RVR-SNF-003 indicates a failure when exporting data from Snowflake to Amazon S3. This type of error usually relates to configuration or permission issues that prevent the export process. Based on the documentation, this often involves a lack of permissions on the S3 bucket in the connection or misconfigurations regarding AWS credentials.

2. Action Steps:

   • Check S3 Bucket Permissions: Ensure that your AWS IAM roles and permissions attached to the S3 bucket are set correctly. The necessary permissions typically include actions such as s3:GetObject, s3:PutObject, s3:GetBucketLocation, and others related to managing objects within the bucket.
   • Verify AWS IAM Role Configuration: Ensure that the IAM role used in Rivery for accessing the S3 bucket is correctly configured. Make sure the external ID specified in the Rivery console matches what is set in the IAM role, and that all permissions are properly assigned.
   • Validate Snowflake Configuration: Ensure Snowflake has the correct permissions to access the S3 bucket. This might involve troubleshooting Snowflake's external stage configuration or Snowflake's provided IAM role.
   • Test Connection: Use the test connection feature in Rivery to verify that the integration with S3 is properly set up. A successful connection test indicates that permissions are correctly configured.

3. External References:

   • Rivery Documentation for Amazon S3 Connection
   • Amazon S3 Permissions and Policies
   • Snowflake Documentation for External Stages

If the issue persists or you need further assistance, please open a ticket with Rivery support.