Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-11-2024 08:43 AM - edited 12-11-2024 08:47 AM
I'm struggeling using the databricks widget to set up the location in an sql create table statement.
I tried the following to set up the location:
Step1: Creating a notebook (Notebook1) to define the variable.
Location_Path = 'abfss:xxxxx@xxxx.xxx.net/Tabelname1'
Step2: Creating a notebook with widgets (Notebook2) to create the table.
Cell1:
%python
# create the widget with the location path
dbutils.widgets.text("Location_Path", "")
Cell2:
%sql
-- create table using widget
CREATE OR REPLACE TABLE schema.Tabelname1
LOCATION :Location_Path
AS
SELECT
...
from schema.Tabelname
Step 3: Runing Notebook2 from Notebook1 using dbutils.notebook.run() function
dbutils.notebook.run("Notebook2", 600, {"Location_Path":Location_Path})
Is there documentation available how to setup the location using a test widget?
