Stefan-Koch
Databricks Partner

You can use Databricks widgets to create a form-like experience and capture user input dynamically.

 

dbutils.widgets.text("catalog", "", "Enter Catalog Name")
dbutils.widgets.text("schema", "", "Enter Schema Name")
dbutils.widgets.text("table", "", "Enter Table Name")

catalog = dbutils.widgets.get("catalog")
schema = dbutils.widgets.get("schema")
table = dbutils.widgets.get("table")

query = f"SELECT * FROM {catalog}.{schema}.{table} LIMIT 10"

display(spark.sql(query))

 

StefanKoch_0-1740549451050.png