SELECT * FROM ____________________

SELECT * FROM ____________________
A . SELECT * FROM f{schema_name.table_name}
B. SELECT * FROM {schem_name.table_name}
C. SELECT * FROM ${schema_name}.${table_name}
D. SELECT * FROM schema_name.table_name

View Answer

Answer: C

Explanation:

The answer is, SELECT * FROM ${schema_name}.${table_name} %python

table_name = "sales"

schema_name = "bronze"

%sql

SELECT * FROM ${schema_name}.${table_name}

${python variable} -> Python variables in Databricks SQL code