Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

The schema `delta` cannot be found error after first execution of delta table creation with path

Below statement works fine for the first time in Microsoft Fabric, subsequent execution throwing schema not found error.     %%sql create table if not exists delta.`Files/deltatables/table5` (...
data engineering
ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
2 years ago

Hi I haven't seen a way to insert with only sql to files at fabric. If you want to try it make sure you are querying the right schema. Check your schema with:

%%sql
SELECT current_schema()

That will show if "delta" is ok. I would say it might be the name of the lakehouse. 

 

As an alternative, you can consider pyspark. Have you tried delta api instead?

# Create or replace table with path and add properties
DeltaTable.createOrReplace(spark) \
  .addColumn("id", "INT") \
  .addColumn("firstName", "STRING") \
  .addColumn("middleName", "STRING") \
  .addColumn("lastName", "STRING", comment = "surname") \
  .addColumn("gender", "STRING") \
  .addColumn("birthDate", "TIMESTAMP") \
  .addColumn("ssn", "STRING") \
  .addColumn("salary", "INT") \
  .property("description", "table with people data") \
  .location("/tmp/delta/people10m") \
  .execute()

 I hope that helps,

v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Hi Anonymous 

 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.


Thanks.

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hi Anonymous 

     

    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .
    If you have any question relating to the current thread, please do let us know and we will try out best to help you.
    In case if you have any other question on a different issue, we request you to open a new thread.

     

    Thanks.