superset_dataset_create
Create a dataset in Apache Superset as a physical table/view or virtual SQL query by providing a table name and database ID.
Instructions
Create a new dataset (physical or virtual).
A physical dataset references an existing table/view in the database. A virtual dataset uses an arbitrary SQL query as the data source.
Args: table_name: Table/view name (for physical) or dataset name (for virtual). database: Database connection ID (from superset_database_list). schema_name: Database schema (e.g. "public", "source"). If omitted, uses the DB default schema. sql: SQL query for a virtual dataset. If provided, creates a virtual dataset based on this query.
Returns: JSON string with the created dataset details.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | No | ||
| database | Yes | ||
| table_name | Yes | ||
| schema_name | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |