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

Edwin 61

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?

Saurabh Sharma 23,751 Reputation points Microsoft Employee

2021-11-13T00:07:55.563+00:00

Hi @Edwin ,
Thanks for using Microsoft Q&A !!
Could you please share the code which you are using to create these views ? Also, what all data types you are using in the view which is getting changed.

Thanks
Saurabh
Saurabh Sharma 23,751 Reputation points Microsoft Employee

2021-11-29T20:51:39.22+00:00

Hi @Edwin ,
We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Saurabh