How can I read a specific Delta table part file?

jose_gonzalez — Wed, 16 Jun 2021 18:27:27 GMT

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

Re: How can I read a specific Delta table part file?

jose_gonzalez — Wed, 16 Jun 2021 18:29:17 GMT

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

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

>> 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.

topic Re: How can I read a specific Delta table part file? in Data Engineering

How can I read a specific Delta table part file?

Re: How can I read a specific Delta table part file?