Dedicated sql pool-->Fabric

[SaiPReddy]

How can I query the Dedicated sql pool database directly from its current location without copying the data into Fabric? @Fabric  @Fabric 

[V-yubandi-msft · Accepted solution]

Hi @SaiPReddy ,

Since Microsoft Fabric doesn't support direct queries from a Dedicated SQL Pool, it's best to copy or migrate the data into Fabric. This ensures smooth integration and allows you to use shortcuts, Direct Lake, and Fabric's optimized performance features.

Workaround.

If you need to query the data without migration, you can use Spark in Fabric to connect to the Dedicated SQL Pool. However, keep in mind that this isn't an officially supported method and may come with performance limitations.

• For long-term scalability and full Fabric functionality, migrating the data into Fabric is the way to go. If you just need a temporary solution, you can explore using Spark
• If migration isn't an immediate option, Spark might help as a workaround, but for full Fabric capabilities, moving the data is the best approach. Let me know how you’d like to proceed, and I’d be happy to assist.

Thank you to @nilendraFabric  & @KevinChant  for providing these valuable insights. Your expertise and contribution to our community are  appreciated.

If my response solved your query, please mark it as the Accepted solution to help others find it easily.

And if my answer was helpful, I'd really appreciate a 'Kudos'.

[SaiPReddy]

Hi @V-yubandi-msft,

Thank you for your assistance. For now, I would like to proceed with the Spark option. Could you please provide me with the details of the process?

[nilendraFabric]

Hello @SaiPReddy 

Microsoft Fabric does not support directly querying a Dedicated SQL Pool database located in Azure Synapse Analytics without first copying the data into Fabric.

Please accept this answer if this is helpful and give kudos

[KevinChant]

Actually, I am think you can query the data using Spark.

However, a migration would be better since you cannot take advantage of technologies such as shortcuts from dedicated SQL Pools:
https://learn.microsoft.com/en-us/fabric/data-warehouse/migration-synapse-dedicated-sql-pool-warehou...