Superset charts Data

Superset charts Data

Certified

Fetch chart data

Queries chart data via POST /chart/data and outputs rows using fetchType. Rows can be fetched in memory or streamed as Amazon Ion into internal storage.

yaml
type: io.kestra.plugin.superset.charts.Data

Query chart data and store rows

yaml
id: get_chart_data
namespace: company.team
tasks:
  - id: fetch_data
    type: io.kestra.plugin.superset.charts.Data
    url: "{{ secret('SUPERSET_URL') }}"
    username: "{{ secret('SUPERSET_USER') }}"
    password: "{{ secret('SUPERSET_PASSWORD') }}"
    chartPayload:
      datasource:
        id: 1
        type: table
      queries:
        - columns: []
          metrics: ["count"]
          row_limit: 1000
      result_format: json
      result_type: full
Installation

Our standard Docker images already include this plugin. If you use a -slim image or another setup, install it with the following command:

kestractl plugins get io.kestra.plugin:plugin-superset --compatible-for $KESTRA_VERSION

For kestractl, use your Kestra version with --compatible-for, or specify an exact plugin version.

Properties

The JSON query payload to send to /chart/data

Map representing the Superset chart query context (including datasource and queries) submitted as JSON to POST /api/v1/chart/data.

The Superset password

Password associated with the Superset username. Always store this value in a Kestra secret.

The Superset API base URL

Base URL of the Apache Superset API, including the /api/v1 path suffix (for example https://superset.example.com/api/v1).

The Superset username

Username used to authenticate against Apache Superset via POST /security/login.

Assets this task consumes as inputs or produces as outputs, for lineage tracking and the asset graph (Enterprise Edition). A flow declaring this property on a task is rejected in the open-source edition.

Definitions
assetFailureBehaviorstring
Possible Values
IGNOREFAILWARN

Asset failure behavior

Behavior applied to the task state when a declared asset fails to render, emit, or be persisted (e.g. a lock conflict): FAIL escalates it to FAILED, WARN (default) warns it if it would otherwise succeed, IGNORE leaves the state untouched.

enableAutobooleanstring

Whether to auto-register assets referenced dynamically at runtime that are not statically declared in inputs or outputs.

inputsarray

The assets consumed as inputs.

id*string
Min length1
typestring
outputs

The assets produced as outputs.

id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*string
Min length1

Custom asset type

descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
DefaultSTORE
Possible Values
STOREFETCHFETCH_ONENONE

How to return output data

Controls how chart rows are returned: STORE (written as Amazon Ion in internal storage, default), FETCH (all rows in output), or FETCH_ONE (first row only).

Defaultdb

Authentication provider

Superset authentication provider passed to /security/login. Supported values include db (default), ldap, oauth, and oid.

First fetched row (when FETCH_ONE)

SubTypeobject

All fetched rows (when FETCH)

Total number of rows returned

Formaturi

URI of stored chart data in Kestra internal storage (when STORE)