WidgetSQLQuery

class orion_notebook.widgets.widget_sql_query.SQLQueryWidget(**kwargs)

Bases: orion_notebook.widgets.widget_base.RuntimeWidget

Class for building a Query Widget.

  • Input(s): an SQL query

  • Operation: the widget builds an interactive field for each of the parameters defined in the SQL query

  • Outputs(s): the result of the SQL query

class Outputs(value)

Bases: enum.Enum

Enum of outputs of the widget

DATAFRAME = 'dataframe'
configure_outputs()

Configures the outputs of the widget

execute(**kwargs)

Configures the widget’s functionality and generates the SQLQuery widget (executing the provided query)

stringify_complex_types()

Format values from the input items dictionary to string depending on its type in order to execute the query correctly (without syntax errors)