https://community.databricks.com/t5/data-engineering/additional-permission-for-delta-compared-to-parquet/m-p/19348#M12951 <P>Delta table is the non-hive compatible format. So there must also be permissions for a client to access the path to the database’s location so that it can create a new temporary “directory” there. This comes from Spark SQL’s handling of external tables. Delta tables just happen to always go through this path.&nbsp;</P><P></P><P>See Apache Spark code <A href="https://github.com/apache/spark/blob/branch-2.4/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveExternalCatalog.scala#L471-L489" target="test_blank">https://github.com/apache/spark/blob/branch-2.4/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveExternalCatalog.scala#L471-L489</A> for more information</P> Fri, 25 Jun 2021 17:15:47 GMT brickster_2018 2021-06-25T17:15:47Z https://community.databricks.com/t5/data-engineering/additional-permission-for-delta-compared-to-parquet/m-p/19347#M12950 <P>I am trying to create a Delta table and it seems the Delta table requires additional permissions on the parent folder of the table. The command failed telling permission errors. I tried to create a parquet table and it works fine.&nbsp;</P><P></P> Fri, 25 Jun 2021 17:15:28 GMT https://community.databricks.com/t5/data-engineering/additional-permission-for-delta-compared-to-parquet/m-p/19347#M12950 brickster_2018 2021-06-25T17:15:28Z https://community.databricks.com/t5/data-engineering/additional-permission-for-delta-compared-to-parquet/m-p/19348#M12951 <P>Delta table is the non-hive compatible format. So there must also be permissions for a client to access the path to the database’s location so that it can create a new temporary “directory” there. This comes from Spark SQL’s handling of external tables. Delta tables just happen to always go through this path.&nbsp;</P><P></P><P>See Apache Spark code <A href="https://github.com/apache/spark/blob/branch-2.4/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveExternalCatalog.scala#L471-L489" target="test_blank">https://github.com/apache/spark/blob/branch-2.4/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveExternalCatalog.scala#L471-L489</A> for more information</P> Fri, 25 Jun 2021 17:15:47 GMT https://community.databricks.com/t5/data-engineering/additional-permission-for-delta-compared-to-parquet/m-p/19348#M12951 brickster_2018 2021-06-25T17:15:47Z