How can I read a specific Delta table part file?

[jose_gonzalez]

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

[jose_gonzalez · Accepted solution]

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.