Ultimate access to all questions.
A data engineer is working with Databricks and has a Python variable named table_name
which contains the name of a table they wish to query. They aim to construct a Python code block that uses this variable to dynamically inject the table name into a SQL query. Below is the partially completed code block that they are working with:
____(f"SELECT customer_id, spend FROM {table_name}")
Which of the following options can be used to fill in the blank to successfully complete this task?