Forum Discussion
Dedicated sql pool-->Fabric
How can I query the Dedicated sql pool database directly from its current location without copying the data into Fabric? @Fabric Fabric
Hi Anonymous ,
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'.
4 Replies
Hello Anonymous
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 kudosActually, 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-warehouse
Hi Anonymous ,
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'.
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?
