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

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

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments