RVR-DTF-300
1. Issue Summary
The error message RVR-DTF-300 indicates that there is a requirement for a file zone configuration when using a DataFrame as a data source targeted to Amazon Redshift on Data Integration platform. This error suggests that a Custom File Zone needs to be properly configured for your Redshift integration, which appears to be missing or incorrectly set up.
2. Possible Cause
- The setup for using a DataFrame as a data source requires the destination, Redshift, to be associated with a File Zone. This is not automatically created or managed, which is often the case with default Managed File Zones.
3. Action Steps
Here are some clear steps you can take to resolve this issue:
-
Ensure File Zone Configuration:
- Set up a Custom File Zone in Data Integration to connect to your Amazon Redshift instance. This setup involves configuring an S3 Bucket that will act as a staging ground for your data.
- Go to Data Integration Admin Settings and create a Custom File Zone by linking your S3 bucket.
-
Verify Configuration:
- Ensure that the parameters such as AWS Access Key ID, Secret Access Key, and the S3 Bucket name are correctly entered into the Data Integration console under your Redshift connection settings.
-
Test Connection:
- After the file zone and connection settings are configured, use the "Test Connection" feature provided within Data Integration to ensure that the connection between Data Integration and your Redshift instance is functional.
-
Check IAM Permissions:
- Ensure that your IAM roles and permissions are correctly set for accessing S3 buckets and that your Data Integration account has sufficient rights to interact with the Custom File Zone.
4. External References
- Data Integration Documentation on Custom File Zone
- AWS Documentation on Connecting to Amazon Redshift
If the issue persists or you need further assistance, please open a ticket with Data Integration support.