Forum Discussion
Accessing serverless sql pool tables from dedicated sql pool
I'm trying to access the tables available in the synapse serverless sql pool from the dedicated sql pool. I'd like to create some simple stored procedures to import data from delta/parquet tables ...
As you mentioned, OPENROWSET does not support the Delta format in a Dedicated SQL Pool, a possible approach is to use Synapse Pipeline's Copy Activity to transfer the data into the Dedicated SQL Pool.
Source: Utilize Serverless SQL Pool to query the delta external table using OPENROWSET
Sink: Load the data into a table in the Dedicated SQL Pool.