Viswanth
New Contributor II

Thanks sathya,

I initially explored this approach but ran into challenges passing the SQL query output directly into an If/Else condition within the control flow. As a workaround, I used a Spark script to execute the SQL and then passed the output via dbutils.jobs.taskValues.set(key="my_value", value=my_result). However, if there’s a more streamlined method to achieve this directly, I’d love to learn about it. Any specific techniques or examples you could share on handling SQL outputs in control flow conditions would be invaluable. Thank you again for your insights!