Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Synapse - Spark database shows up in serverless SQL, but not all tables/views within
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 25%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
Eirik Magnussen
1
Reputation point
I've been creating facts and dimensions through various operations in Synapse notebooks. I am using spark sql to create a couple of spark tables whereas one of them become viewable in synapse serverless sql, while the other table does not (which is in fact identical in schema - data comes from a legacy source).
Both tables are there in the synapse UI and I can query them like any other. whileas in serverless sql I can only find one of them.
I can not for the life of me figure out why. There is not much difference in how these tables are defined, both are created from a "CREATE OR REPLACE TABLE ..."-statement and are almost identical.
Are there any common mistakes one (me) might have done or something I've probably overlooked? I really would like to be able to query these tables from an sql endpoint.
Azure Synapse Analytics
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
HimanshuSinha 19,547 Reputation points Microsoft Employee Moderator2022-11-17T03:37:12.627+00:00 Hello @Eirik Magnussen ,
Thanks for the question and using MS Q&A platform.
Can you pleease check the connect to option and check with the Serverless and dedicated instance .
Please do let me if you have any queries.
Thanks
Himanshu
- Please don't forget to click on
or upvote 
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how - Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
- Please don't forget to click on
-
Eirik Magnussen 1 Reputation point
2022-11-18T12:38:52.233+00:00 Unfortunately that also fails. The query fails using the built-in on-demand (and a dedicated) pool. Using a notebook to query the data using spark works however.
The two tables I am querying here are defined almost exactly the same way, but using a couple of different sources.
(edit: posted too early)
Sign in to comment
Sign in to answer