topic Re: Running large volume of SQL queries in Python notebooks. How to minimise overheads/maintenance. in Data Engineering

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

dispersion — Mon, 13 Feb 2023 13:39:50 GMT

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.

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

Anonymous — Mon, 13 Feb 2023 19:19:34 GMT

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

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

Anonymous — Tue, 21 Feb 2023 10:17:23 GMT

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!