Issue with Synapse Lake Database Table
Admin (KK)
136
Reputation points
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
Sign in to answer