bar_plot
Create bar plots by running SQL queries on data sources like CSV or Parquet files. Specify x and y axes, add color dimensions, and customize orientation for clear data visualization.
Instructions
Run query against specified source and make a bar plot using result For both csv and parquet sources, use DuckDB SQL syntax Use 'CSV' as the table name in the SQL query for csv sources. Use 'PARQUET' as the table name in the SQL query for parquet sources.
This will return an image of the plot
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| color | No | Optional column name from SQL result to use as a 3rd dimension by splitting each bar into colored sections | |
| orientation | No | Orientation of the box plot, use 'v' for vertical (default) and 'h' for horizontal. Be mindful of choosing the correct X and Y columns as per orientation | v |
| query | Yes | SQL query to run on the data source | |
| source_id | Yes | The data source to run the query on | |
| x | Yes | Column name from SQL result to use for x-axis | |
| y | Yes | Column name from SQL result to use for y-axis |
Input Schema (JSON Schema)
{
"properties": {
"color": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"description": "Optional column name from SQL result to use as a 3rd dimension by splitting each bar into colored sections",
"title": "Color"
},
"orientation": {
"default": "v",
"description": "Orientation of the box plot, use 'v' for vertical (default) and 'h' for horizontal. Be mindful of choosing the correct X and Y columns as per orientation",
"title": "Orientation",
"type": "string"
},
"query": {
"description": "SQL query to run on the data source",
"title": "Query",
"type": "string"
},
"source_id": {
"description": "The data source to run the query on",
"title": "Source Id",
"type": "string"
},
"x": {
"description": "Column name from SQL result to use for x-axis",
"title": "X",
"type": "string"
},
"y": {
"description": "Column name from SQL result to use for y-axis",
"title": "Y",
"type": "string"
}
},
"required": [
"source_id",
"query",
"x",
"y"
],
"type": "object"
}