Forum Discussion

kobia10's avatar
kobia10
Microsoft Employee
2 years ago

Create a table shortcut to CSV folder using DDL 'Create Table' stopped working

For the last few months we ran a statement in a notebook to create a table under the tables folder The table was created correctly and we could run pySpark code against the table Very recently, aft...
data engineering
one lake
kobia10's avatar
kobia10
Microsoft Employee
2 years ago

No. The table is a new one.

Used to work before without any issues. Not clear when the change in Fabric has occured.

As I said i can use pySpark to query the table in a notebook. Just the Lakehouse UI seems to be broken

 

This works and returns data...

df = spark.sql("SELECT * FROM Sust.msdyn_facility LIMIT 1000")
display(df)
 
See below the error saying 'The requested file cannot be found' relating to the shortcut that returns data
 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi kobia10 ,

    Thanks for using Fabric Community.
    I would like to understand, what changes you made recently?
    When did you started observing this issue?
    Are you able to load the table in Notebooks? Sql Endpoint?

    I can guide you, if you can share these details. 

    • kobia10's avatar
      kobia10
      Microsoft Employee
      2 years ago

      No changes made

      Start seeing these last week. However, I have not visited the scenario for a while

      I can load the data using spark.sql('select * from lakehouse.tablename")

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hello kobia10 ,

        At this time, we are reaching out to the internal team to get some help on this .
        We will update you once we hear back from them.