Forum Discussion
Cannot create delta table in lakehouse
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!
12 Replies
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.Hi Anonymous,
Do you have any update on this?
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.
- 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()
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.)"
It gives the same error even if I just run a select on the existing table
