RVR-SYNP-200

1. Issue Summary

   • The error code RVR-SYNP-200 with the message "Failed to get schema" for the azure_synapse data connector indicates a failure in retrieving the schema for a table or database. This could often happen due to misconfigurations in the connection setup, permissions issues, or network-related problems that obstruct schema retrieval from Azure Synapse.

2. Action Steps:

   • Verify Connection: Ensure that the connection to Azure Synapse is properly configured with the correct server name, database name, authentication method, and credentials.
   • Check Permissions: Confirm that the user account used in the connection has sufficient permissions to access schema information. The account should have at least read and metadata discovery permissions on the database.
   • Network Security: Check if there are any network restrictions that might be preventing access. This includes firewalls or Azure network security groups blocking traffic to and from Azure Synapse.
   • Test Connection Independently: Use an external tool like SQL Server Management Studio (SSMS) to connect to Azure Synapse and test if schema information can be retrieved outside Rivery. This isolates whether the issue is specific to Rivery or a general connection problem.
   • Review Logs and Details from Rivery: Look into any detailed error messages or logs provided by Rivery for additional clues about the issue.

3. External References:

   • For further details, please refer to the Rivery documentation on Azure Synapse Data Connector.
   • Microsoft's documentation on managing Azure Synapse Analytics can also be useful for additional troubleshooting steps regarding connectivity and permissions.

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