Forum Discussion

felipe_regis's avatar
felipe_regis
New Member
2 years ago
Solved

Failed to create table and schema

hi folks   I failed to run a simple create table into a spark notebook using python and then in SQL as well.   It follows my code:     %%sql CREATE TABLE IF NOT EXISTS sales.sales_silver ( ...
  • rahuldwh's avatar
    rahuldwh
    2 years ago

    felipe_regis , Yes we can't create schema in the lakehouse. In the code given in the lab the sales denotes lakehouse name not the schema. So if you haven't created the sales lakehouse your code will show this error.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi felipe_regis 

Thanks for using Fabric Community.

Apologies I could not understand the issue properly. Are you trying to say that you are able to create a new table in the Lakehouse using SQL code in the notebook, but getting an error while using python?

 

felipe_regis's avatar
felipe_regis
New Member
2 years ago

Actually, answers and thoughts mentioned were pretty useful. Just to clarify, I was not able to create a table using the following synthax [sales].[table_name]. As "sales" lakehouse didn't exist I got that error, "schema not found or does not exist".

 

I understood that it's not possible to create schemas when using a Lakehouse but, indeed, it's possible to create a table when referencing a lakehouse name instead. Such as [Lakehouse_name].[table_name].

 

Thanks anyways

 

Regards

Related content