How can I read a specific Delta table part file?

jose_gonzalez
Databricks Employee
Databricks Employee

‎06-16-2021 11:27 AM

is there a way to read a specific part off a delta table? When I try to read the parquet file as 

parquet I get an error in the notebook that I’m using the incorrect format as it’s part of a delta table. I just want to read a single Parquet file, not the whole Delta table

Labels:
0 Kudos

jose_gonzalez
Databricks Employee
Databricks Employee

‎06-16-2021 11:29 AM

Disable Delta format to read as Parquet you need to set to false the following Spark settings:

>> SET spark.databricks.delta.formatCheck.enabled=false

OR

>> spark.conf.set("spark.databricks.delta.formatCheck.enabled", "false")

its not recommended to read the delta table directory using the read.parquet because the delta table directory can always possibly have in-active files which are to be cleaned up by vacuum.

View solution in original post

0 Kudos