Issue with Synapse Lake Database Table

Admin (KK) 136 Reputation points
2025-02-24T18:40:52.9966667+00:00

Hello, I am having an issue with Synapse Lake Database Table.

I created a table in Lakehouse database, I was able to do a select and everything from pyspark notebook. However when i try to do the select from SSMS or synapse it doesn't work. It says table not found.

It was working till yesterday. I drop the table and recreated

Can someone help me how this can be fixed.

Table Creation :
%%sql
sql_query = f"""
CREATE TABLE processed.dimdata
USING DELTA
LOCATION 'abfss://******@adlsdatadev.dfs.core.windows.net/dimData/'
"""

# Execute SQL in PySpark
spark.sql(sql_query)

# Select
select * from processed.dimdata //works
when i run the same command in SSMS or Synapse, i get the following error

Started executing query at Line 1
Invalid object name 'processed.dbo.dimdata'.
Total execution time: 00:00:00.551
Azure Synapse Analytics
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.
5,228 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.