Table not visible in SQL EP : The requested Lakehouse operation failed. A retry of the operation may

[nilendraFabric]

Hello ,

I have created a table in lakehouse using notebook :

    df.write.format("delta").mode("append").saveAsTable("BudgetData_API")

Table is created successfully.

the issue is 

Data is visible in Lakehouse , but these tables are not visible in SQL EP.

this is happenig with all the tables I am writting using NB.

Any suggestions.

[nilendraFabric]

I am facing same issue. But its intermittent 

[v-csrikanth]

Hi @nilendraFabric 
If the above suggested approach works for you could you please accept as solution.

Best regards,
Cheri Srikanth

[v-csrikanth · Accepted solution]

Hi @nilendraFabric 
I tried to reproduce your scenario it works fine for me.
Steps to create a table using a Notebook:

1. Inside the Lakehouse, go to Notebooks → + New Notebook.
2. Attach the notebook to lakehouse.
3. Run the following Python code:
   ********************************************************
   

   from pyspark.sql import SparkSession

   spark = SparkSession.builder.getOrCreate()

   data = [(1, "Product A", 100), (2, "Product B", 150)]
   columns = ["ID", "Product", "Sales"]

   df = spark.createDataFrame(data, columns)

   df.write.format("delta").mode("overwrite").saveAsTable("TestTable")

   ********************************************************
4. Refresh and confirm that TestTable appears under the Tables section in your Lakehouse.
   

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.