We are connecting to our Azure Synapse workspace using the Microsoft SQL Server source. We are able to list and query the views and external tables in Dremio.
As Azure SQL Data Warehouse is the SQL Server Data Warehouse (a feature from SQL Server) in the cloud, and Azure synapse is an evolution of Azure SQL Data Warehouse, I have a few questions:
- Is it okay if we are connecting to Azure Synapse using the Microsoft SQL Server source?
- Do you foresee any issues that might arise while connecting and querying data in Synapse through this source?
- We are able to list the tables and views only when the legacy dialect is enabled from the advanced options tab. Otherwise, we would get an error saying
Error retrieving all tables for source - @@FETCH_STATUS is not supported.Will there be any problems in the future regarding ‘Enable Legacy Dialect’ ? since this is the only way we are currently able to connect Synapse through Microsoft SQL Server?
- Will there be any other limitations when connecting to Synapse using the Microsoft SQL Server source?
If there’s anything else we should be knowing beforehand, please do mention it.