You can't use this until you register with us!

Description

Generate a Bokeh graph from the results of an SQL Query

Purchasing Options

SQL Plotter: Bokeh - $0.0 / month

Available Actions

Bar Graph

Creates a Bokeh Bar Graph visualization from the results of an SQL Query.

Variables

Database Parameters
target_db required

Database to run the SQL Query on.

sql_query required

SQL Query to produce X and Y axis values.


Graph Parameters
title

Title for the visualization output.

palette

Predefined Color Palette. For more details on the color palette choices go to https://docs.bokeh.org/en/latest/docs/reference/palettes.html


X Parameters
x_name required

Name of the column in your SQL Query result that contains the names of your bars.

x_label

Label for the X axis.

x_axis_orientation required

Display labels along the X axis horizontally or vertically.


Y Parameters
y_name required

Name of the column in your SQL Query result that contains height values for your bars. Only a single column of values is supported.

y_label

Label for the Y axis.

y_range

Two item list with the minimum value and maximum value allowed. Values lower than the minimum and higher than the maximum will not be displayed on the graph.


Line Graph

Creates a Bokeh Line Graph visualization from the results of an SQL Query.

Variables

Database Parameters
target_db required

Database to run the SQL Query on.

sql_query required

SQL Query to produce X and Y axis values.


Graph Parameters
title

Title for the visualization output.

palette

Predefined Color Palette. For more details on the color palette choices go to https://docs.bokeh.org/en/latest/docs/reference/palettes.html


X Parameters
x_name required

Name of the column in your SQL Query result that contains the values for your X axis.

x_label

Label for the X axis.

x_axis_type required

Type of X axis to generate.

x_axis_orientation required

Display labels along the X axis horizontally or vertically.


Y Parameters
y_names required

List of the column names in your SQL query result that contains the values for your Y axis.

y_label

Label for the Y axis.

y_range

Two item list with the minimum value and maximum value allowed. Values lower than the minimum and higher than the maximum will not be displayed on the graph.


Legend Parameters
legend_show

Display a Legend on the graph.

legend_name

Title displayed in the Legend.

legend_rename

Mapping from the column names in your SQL Query result to names displayed in the Legend.

legend_orientation required

List items horizontally or vertically in the Legend.

legend_location required

Location of the Legend on the graph.


Table Output

Creates a Bokeh Table visualization from the results of an SQL Query.

Variables

Database Parameters
target_db required

Database to run the SQL Query on.

sql_query required

SQL Query to produce the table data.


Table Parameters
title

Title for the visualization output.