Forum Discussion
pete441610
May 02, 2023Copper Contributor
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