Forum Discussion

clayduvall's avatar
clayduvall
Copper Contributor
Jan 22, 2025

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 that are mapped as external tables in the serverless sql pool and load them into some dedicated sql pool tables.   Is there a simple way to do this without having to define external tables in the dedicated sql pool too?  I tried this and there seem to be many limitations (delta not supported, etc.). 

1 Reply

Sort By
  • petevern's avatar
    petevern
    Brass Contributor
    Feb 13, 2025

    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.

Resources