CREATED WIDGET - SQL syntax - how do I specify a label?

eriodega — Wed, 30 Oct 2024 22:04:57 GMT

What is the syntax in SQL for creating a widget in a notebook with a label?

This documentation says "The last argument is label, an optional value for the label shown over the widget text box or dropdown."
The one example provided on that page doesn't use a label for the widget. Here are my attempts:

CREATE WIDGET TEXT some_variable DEFAULT 'a great default' --succeeds, but no label CREATE WIDGET TEXT some_variable DEFAULT 'a great default' 'some label/description' --syntax error CREATE WIDGET TEXT some_variable DEFAULT 'a great default' LABEL 'some label/description' --syntax error

Re: CREATED WIDGET - SQL syntax - how do I specify a label?

nefflev — Thu, 31 Oct 2024 00:32:16 GMT

Hi @eriodega

I do not know how it works with sql but a possibility is to use a python cell in your SQL notebook and create it like this:

%python dbutils.widgets.text("some_name", "a great default", "some label/description")

All the best

topic CREATED WIDGET - SQL syntax - how do I specify a label? in Data Engineering

CREATED WIDGET - SQL syntax - how do I specify a label?

Re: CREATED WIDGET - SQL syntax - how do I specify a label?