Running large volume of SQL queries in Python notebooks. How to minimise overheads/maintenance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-13-2023 05:39 AM
I have around 200 SQL queries id like to run in databricks python notebooks. Id like to avoid creating an ETL process for each of the 200 SQL processes.
Any suggestions on how to run the queries in a way that it loops through them so i have minimum amount of components to maintain.
- Labels:
-
Databricks Notebooks
-
ETL
-
Large Volume
-
Python
-
Python3
-
Run
-
SQL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-13-2023 11:19 AM
It depends what you want to do. You can certainly use python to write loops over spark.sql() queries.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2023 02:17 AM
Hi @Chris French
Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.
We'd love to hear from you.
Thanks!