Forum Discussion

pete441610's avatar
pete441610
Copper Contributor
May 02, 2023

Synapse SQL Serverless views metadata update

Hi everybody,

I have a question regarding Synapse SQL Serverless views behavior.
I have a synapse process which create parquet files in replace mode. (it's a monthly process).


Sometimes, the file structure might change (new column for instance).
I have a SQL serverless view with a SELECT * FROM OPENROWSET over the parquet file without WITH command to describe the file structure.

When I make a SELECT on the view after the process I got an error message "view has more column names specified than columns defined".

It seams that the view metadata are not updated in my this case.


Is there a way to do it?

Thanks for your help.

Pete
 


No RepliesBe the first to reply

Resources