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

Question

I am working on Tutorial 4 of this doc from Azure Team where this section in a Dedicated SQL pool (that actually is also a database - as item 2 of Tutorial states) creates a database named nyctaxi with a table nyctaxi.trip as follows:

%%pyspark
spark.sql("CREATE DATABASE IF NOT EXISTS nyctaxi")
df.write.mode("overwrite").saveAsTable("nyctaxi.trip")

Then Tutorial 5 creates another table NYCTaxiTripSmall. After completing these tutorials, I can see (on the Data Hub of the Synapse studio) my Dedicated SQL Pool as shown below. But when I click on any database object folder it does not show any db object (tables, external tables etc.) and instead, it shows a red cross sign (as shown below).

Question: Why I am not seeing the db objects (described above) in the Dedicated SQL pool below.

Remarks: Please note that I also created DataExplorationDB db and an external source in tutorial 2 using serverless SQL pool - and, as shown in yellow below, I can see that db and its objects. So why same is not true for Dedicated SQL Pool db? I have also restarted the Dedicated SQL pool and it's online. But still no db objects are showing.

David Browne - Microsoft · Accepted Answer · 2021-11-13 22:11:16Z

1

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.

answered Nov 13, 2021 at 22:11

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

nam Over a year ago

Thank you for pointing it out - as I do see those tables inside Lake Database section that is created above SQL Database section in the Data Hub of Synapse studio. But, in what cases, one would be able to see the db tables (for example) inside Tables folder of DedicatedSQLPool folder (shown in yellow in image above?

David Browne - Microsoft Over a year ago

Only when you create a table using TSQL in a SQL Script or from SQL Server Management Studio.

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related