@Machireddy Nikithaโ :
you can use the DESCRIBE command in SQL to see the table location. Here is an example:
DESCRIBE EXTENDED my_database.my_table;
This command will display the metadata of the table, including its location on the local file system of the Databricks runtime. Note that the location might change every time you restart your Databricks cluster.