How to execute .sql file in volume

lauraxyz
Contributor

I have giant queries (SELECT.. FROM) that i store in .sql files. I want to put those files in the Volume, and run the queries from a workflow task.

I can load the file content into a 'text' format string, then run the query.  My question is,  is there another option, where I don't need to load the file content, but directly execute the .sql file and store the results in a Dataframe?