RVR-SYNP-301

1. Issue Summary

   • You encountered an error with code RVR-SYNP-301 while trying to create an external file format using the Azure Synapse data connector in Rivery. This typically indicates a problem with the configuration or execution of the external file format definition in Azure Synapse Analytics.
   • From the error code and context, it suggests there might be an issue with the setup parameters, permissions, or syntax used in defining the file format.

2. Action Steps:

   • Check Synapse SQL Access and Permissions: Ensure that the user account has the necessary permissions to create external resources in Azure Synapse. You might need ALTER or CONTROL permissions on the database where you're trying to create the format.
   • Validate External File Format Syntax: Review the syntax used in your external file format creation statement for any errors or omissions. You may refer to Azure Synapse documentation for the correct syntax and examples.
   • Ensure Correct Data Source Integration: Double-check the integration settings for Azure Synapse in Rivery. Ensure that all connection parameters, including storage configurations and authentication methods, are correctly set up.
   • Consult Rivery Documentation: Look at Rivery's documentation on setting up connections with Azure Synapse to ensure no steps were missed or incorrectly implemented.

3. External References:

   • Azure Synapse Analytics - Creating External File Formats: Microsoft Documentation
   • Rivery Documentation on Azure Synapse: Rivery Docs

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