Home > database >  Azure Synapse dedicated sql pool not showing data objects in synapse studio
Azure Synapse dedicated sql pool not showing data objects in synapse studio

Time:11-14

I am working on enter image description here

CodePudding user response:

When you create a Spark database the tables aren't automatically added to your Dedicated SQL Pool. You can add them as External Tables if you want, but there's no automatic metadata sync between Spark and Dedicated SQL Pool.

Synapse does create a serverless "Lake Database" corresponding to your Spark database, which you can use from SQL Scripts or access with SQL Server reporting tools.

  • Related