RVR-SNF-003
-
Issue Summary
- The error code
RVR-SNF-003indicates 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.
- The error code
-
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 Data Integration for accessing the S3 bucket is correctly configured. Make sure the external ID specified in the Data Integration 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 Data Integration to verify that the integration with S3 is properly set up. A successful connection test indicates that permissions are correctly configured.
- 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
-
External References:
If the issue persists or you need further assistance, please open a ticket with Data Integration support.