Data type inference when building a view of views in Serverless SQL

Edwin 56 Reputation points
2021-11-11T12:44:45.523+00:00

We noticed that apparently Synapse performs data type inference when creating a view of views. When joining two openrowset based tables together (some using the WITH clause to hard code data types) to create a new view, some of the data types change between the new view and the views it is based on.

I would expect the data types to remain the same and am a little worried that there could be data loss. Even if that is not a risk, I would hope for the data types to remain consistent.

Is there anyway for the view of views to not perform data type inference or is there any another work around?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,625 questions
{count} votes