topic Re: Use '%sql' inside a python cmd cell? in Data Engineering

Use '%sql' inside a python cmd cell?

pjp94 — Thu, 23 Dec 2021 14:03:53 GMT

Hi so I want to essentially execute a sql query if a condition is met. So one of my cells in my python notebook is a sql query (%sql followed by the query). Is there any way to put that in an 'IF' statement ie if an environment variable = some value, run this query?

Re: Use '%sql' inside a python cmd cell?

Hubert-Dudek — Thu, 23 Dec 2021 15:29:44 GMT

in python cell just use:

query = "SELECT 1"

spark.sql(query)