How to create a placeholder in table name in databricks-CodePudding

Hope the title clarifies what I actually want. I will try to describe the problem.

I am looking for something like this :

variable = "1"
%sql 
DROP TABLE IF EXISTS database.table_{variable}

CodePudding user response：

If you use Spark SQL within Python notebook you can easily achieve this with strings as below -

%python

spark.sql("DROP TABLE IF EXISTS database.table_{variable}".format(variable=variable))

Alternatively, you can follow the link below achieving the same using SQL as well -