query_and_plotly_chart
Execute SQL queries to extract data from a StarRocks database and generate interactive Plotly charts for visualization using a simple Python expression.
Instructions
using sql query to extract data from database, then using python plotly_expr to generate a chart for UI to display
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| plotly_expr | No | a one function call expression, with 2 vars binded: `px` as `import plotly.express as px`, and `df` as dataframe generated by query `plotly_expr` example: `px.scatter(df, x="sepal_width", y="sepal_length", color="species", marginal_y="violin", marginal_x="box", trendline="ols", template="simple_white")` | |
| query | No | SQL query to execute |