Forum Discussion
Unable to create external table through notebook
Hi I have check the documentation online and the issue was with the lakehouse I was writting to.
Currently, Fabric only support writting external table to lakehouse without schema.
Can reffer to Note section:
https://murggu.medium.com/creating-managed-and-external-spark-tables-in-fabric-lakehouse-ef6212e75e81Hence, I changed the lakehouse with no schema. It was working fine
Hi I have check the documentation online and the issue was with the lakehouse I was writting to.
Currently, Fabric only support writting external table to lakehouse without schema.
Can reffer to Note section:
https://murggu.medium.com/creating-managed-and-external-spark-tables-in-fabric-lakehouse-ef6212e75e81
Hence, I changed the lakehouse with no schema. It was working fine
Issue: AssertionError while creating table in Microsoft Fabric Spark
I am facing the following error while executing a Spark SQL / PySpark command to create a table in Microsoft Fabric Lakehouse:
Py4JJavaError: An error occurred while calling o402.sql
java.lang.AssertionError: assertion failed:
Only the following table types are supported:
MANAGED, MATERIALIZED_LAKE_VIEW, EXTERNALProblem Description
While creating or writing a table using Spark SQL / PySpark, the operation fails with an AssertionError. Fabric seems to reject the table definition because it is being created with a table type or storage format that Fabric does not support.
