Explanation:
The correct approach involves using an f-string to dynamically insert the order_date variable into the SQL query. The f-string allows embedding Python expressions directly into the string, and the variable is enclosed in single quotes to ensure it's treated as a string value within the SQL query. This method effectively retrieves the widget value and uses it to filter the data dynamically based on user input.
Ultimate access to all questions.
No comments yet.
In a Python notebook cell, which statement correctly reads a notebook widget and passes the Python variable to a SQL statement?
A
order_date = dbutils.widgets.get('widget_order_date')spark.sql('SELECT * FROM sales WHERE orderDate = order_date')
B
order_date = dbutils.widgets.get('widget_order_date')spark.sql(f'SELECT * FROM sales WHERE orderDate = '{order_date}'')
C
order_date = dbutils.widgets.get('widget_order_date')spark.sql(f'SELECT * FROM sales WHERE orderDate = '${order_date}'')
D
order_date = dbutils.widgets.get('widget_order_date')spark.sql(f'SELECT * FROM sales WHERE orderDate = 'f{order_date}'')
E
order_date = dbutils.widgets.get('widget_order_date')spark.sql(f'SELECT * FROM sales WHERE orderDate = 'order_date'')