topic Re: how to read delta table from the path? in Data Engineering

how to read delta table from the path?

andrew0117 — Wed, 25 Jan 2023 20:59:40 GMT

an unmanaged delta table is dropped and the real data still there. Now I'm trying to rebuild it, but don't know the schema. So, I tried: val myTable = DeltaTable.forPath("myPath"). But how can I get the data or schema out from myTable?

Thanks!

Re: how to read delta table from the path?

daniel_sahal — Thu, 26 Jan 2023 06:56:49 GMT

@andrew li

df = spark.read.format("delta").load("/file_path")
df.printSchema()

Re: how to read delta table from the path?

Hubert-Dudek — Thu, 26 Jan 2023 10:29:21 GMT

SELECT * FROM `delta`./mypathtodeltafolder/;