Hi @lauraxyz , We can load the SQL file using dbutils.fs from volumes and then we can create a dataframe using spark.sql()
Example:
sql_query = dbutils.fs.head("/Volumes/jahnavi/datasets/data/test.sql")
result_df = spark.sql(sql_query)
display(result_df)
Jahnavi N
