I am using serverless sql pool in synapse workspace.
I am storing the data into .parquet files.
To read the parquet files I use the openrowset sql query in a view, i.e. view1.
Is it possible to create a view, i.e. view2 which does upsert in view1?
If not, do I need to create dataflow for this operation? i.e. source being the parquet file and destination to be upsert on the parquet?