Bridging the SQL-Python Gap

Hubert-Dudek
Databricks MVP

‎08-14-2023 12:07 PM

Python often edges out SQL with its metaprogramming capabilities. However, dbt bridges this gap with Jinja templates. Introducing simple "for" loops, especially for parameter iteration, in databricks SQL could significantly enhance the user experience.

ezgif-5-0f8c73663b.gif


My blog: https://databrickster.medium.com/

Rajeev45
Databricks Employee
Databricks Employee

‎08-23-2023 09:10 AM

Thanks for the feedback, we have raised an Internal Idea request  for this suggestion. Based on the need of the customers this will be prioritized and added to the roadmap in the future.

Meanwhile you can alos refer our query  parameters  section for your reference https://docs.databricks.com/en/sql/user/queries/query-parameters.html

Greg_c
New Contributor II

‎01-20-2025 05:39 AM

Was this solved @Rajeev45  Do you have any docs?

0 Kudos