Cannot create delta table in lakehouse

[AdilH]

All,

We have a fabric capacity in West-europe and since this morning we cannot create delta tables in lakehouse(existing)

The error message is : "Create database for <<Lakehouse>> is not permitted using Apache Spark in Microsoft Fabric."

This was working until yesterday(same script)

Do you know if this a region issue? or am I missing something?

Thanks!

[Anonymous]

Hi @AdilH ,

Thanks for using Fabric Community.
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.

[AdilH]

Thanks, I look forward to your response.

[Anonymous]

Hi @AdilH ,

Are they trying to create a table or database?
Can you please share your script if possible or explain what you are trying to do?

[AdilH]

Hi @Anonymous,

Do you have any update on this?

[AdilH]

Hi,

I realize, also running just the select statement on the delta table results in the same error. Exact same query was working a day before.

Support page shows no issues in West europe region. 

I am afraid the product doesnt seem to be stable even in GA.

[AdilH]

Script : 

from pyspark.sql.types import *

from delta.tables import *

DeltaTable.createIfNotExists(spark).tableName("test_2") \

.addColumn("start_ts",TimestampType()) \

.addColumn("end_ts",TimestampType()) \

.addColumn("last_update_ts",TimestampType()) \

.addColumn("column1",IntegerType()) \

.addColumn("column2",IntegerType()) \

.addColumn("column3",IntegerType()) \

.addColumn("column4",IntegerType()) \

.addColumn("column5",DateType()) \

.addColumn("column6",DateType()) \

.addColumn("column7",IntegerType()) \

.addColumn("column8",IntegerType()) \

.addColumn("column9",IntegerType()) \

.addColumn("column10",IntegerType()) \

.addColumn("column11",IntegerType()) \

.addColumn("column12",IntegerType()) \

.addColumn("action",StringType()) \

.partitionedBy("column1")\

.execute()

[Anonymous]

Hi @AdilH ,

Just want to check have you detached any lakehouse or the attached lakehouse was deleted?

[AdilH]

No, none of this

[Anonymous]

Hi @AdilH ,

Internal Team suggest to open a support ticket.

Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link 

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Hope this helps. Please let us know if you have any other queries.

[Anonymous]

Hello @AdilH ,

We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket.
After creating a Support ticket please provide the ticket number as it would help us to track for more information.

[AdilH]

Error message : "Py4JJavaError: An error occurred while calling o299.sql. : org.apache.spark.sql.AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Create database for "Lakehouse" is not permitted using Apache Spark in Microsoft Fabric.)"

[AdilH]

It gives the same error even if I just run a select on the existing table