cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Running large volume of SQL queries in Python notebooks. How to minimise overheads/maintenance.

dispersion
New Contributor

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.

2 REPLIES 2

Anonymous
Not applicable

It depends what you want to do. You can certainly use python to write loops over spark.sql() queries.

Anonymous
Not applicable

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!