Forum Discussion

kobia10's avatar
kobia10
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Microsoft Employee rankMicrosoft 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
        Icon for Microsoft Employee rankMicrosoft 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")