how to read delta table from the path?

[andrew0117]

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!

[daniel_sahal]

@andrew li​ 

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

[Hubert-Dudek · Accepted solution]

or

SELECT * FROM `delta`./mypathtodeltafolder/;