RVR-SNF-003
Issue summary
- The error code
RVR-SNF-003indicates a failure when exporting data from Snowflake to Amazon S3. This error 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 configuration issues regarding AWS credentials.
Action steps
To resolve the error, follow these steps:
- Check S3 Bucket Permissions: Check your AWS IAM roles and permissions attached to the S3 bucket. 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 the set up 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.
External references
- Data Integration Documentation for Amazon S3 Connection
- Amazon S3 Permissions and Policies
- Snowflake Documentation for External Stages
note
If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.
