How to execute .sql file in volume
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2024 11:50 AM
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?
Labels:
- Labels:
-
Workflows