Update your database and table name in line number 1. table_name = 'database_name.table_name' # GET location path by the table ddl query = f"show create table {table_name}" ct_df = spark.sql(query)