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.
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'')
No comments yet.