SELECT from table saved under path

[johnb1]

Hi!

I saved a dataframe as a delta table with the following syntax:

(test_df
  .write
  .format("delta")
  .mode("overwrite")
  .save(output_path)
)

How can I issue a SELECT statement on the table?

What do I need to insert into [table_name] below?

SELECT * FROM [table_name]

[Ajay-Pandey]

Hi @John B​ there is two way to access your delta table-

SELECT * FROM delta.`your_delta_table_path`

df.write.format("delta").mode("overwrite").option("path", "your_path").saveAsTable("table_name")

Now you can use your select query-

SELECT * FROM [table_name]

[johnb1]

Hi @Ajay Pandey​ 

When trying the first option I get:

[Ajay-Pandey]

Hi @John B​ in the above code instead of your path variable put your absolute path. Please refer to snapshot-

[Ajay-Pandey]