strip_plot
Generate strip plots from SQL queries on CSV or Parquet data sources using DuckDB SQL syntax. Visualize query results with customizable x, y, and color dimensions for effective data analysis.
Instructions
Run query against specified source and make a strip 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 show multiple colored strips representing another dimension | |
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 |