...
| Code Block |
|---|
{
"parameters" : {
"query" : "select * from nodes",
"groupby" : [
"group_column"
],
"aggregation_function" : 1,
"value_column" : "unused",
"lineType" : "column",
"axis" : "0",
},
"data_source" : "local_mysql",
"options" : {
"datasetTitle" : "Groups"
},
"name" : "sqlquery_dataset",
"typemodel" : "sql_query"
} |
Breaking this down:
...
this is of little consequence, functionally not used at all right now but a way for you to name the dataset for later recognition.
model (formerly 'type'):
must be sql_query for the above parameters to work.
...
The name is the unique name that identifies this chart when using it elsewhere (like creating a dashboard). What is type model_view for?
model_view (also formerly 'type')
"typemodel_view" : "non-time-chart"
"typemodel_view" : "graph"
2 options exist for this. "non-time-chart" means the data will not be an "over time" graph, but a snapshot of the data at a specific time. This is the most likely candidate for an SQL chart. "graph" is a data over time view, the time base is in unix epoc, the SQL query must return the time column in this format and "time_column" must be specified in the dataset telling it what the column is that holds the time value.
...