Create Dataprovider

LLM-friendly URL

POST

https://api.luzmo.com/0.1.0/dataprovider

API call form

Examples

List of examples

Adding PostgreSQL datasets using an already existing account
Adding AWS Athena datasets using an already existing account.
Adding Clickhouse datasets using an already existing account.
Adding Clickhouse SQL datasets using an already existing account.
Adding BigQuery datasets using an already existing account
Adding BigQuery SQL datasets using an already existing account
Adding Databricks datasets using an already existing account
Adding ElasticSearch datasets using an already existing account.
Adding MariaDB datasets using an already existing account
Adding MariaDB SQL datasets using an already existing account
Adding MongoDB datasets using an already existing account
Adding MySQL datasets using an already existing account
Adding MySQL SQL datasets using an already existing account
Adding Oracle datasets using an already existing account
Adding PostgreSQL datasets using an already existing account
Adding PostgreSQL SQL datasets using an already existing account
Adding Presto datasets using an already existing account.
Adding Presto datasets using an already existing account.
Adding Redshift datasets using an already existing account
Adding Redshift SQL datasets using an already existing account
Adding SAP Hana datasets using an already existing account
Adding Snowflake datasets using an already existing account
Adding Snowflake SQL datasets using an already existing account
Adding SQL Server datasets using an already existing account
Adding SQL Server SQL datasets using an already existing account
Adding Azure Synapse datasets using an already existing account
Adding Trino datasets using an already existing account.
Adding Trino datasets using an already existing account.
Adding Plugin datasets using an already existing account

Description

Add one MySQL-backed SQL dataset, using an account that exists. This will create the Securable and Column entities and make them available for querying. The fields to be specified are:

Connection ID: The ID of the Connection. Retrieve the ID to specify as detailed here
provider: mysql
tables: array of one or multiple datasets you would like to add.
- For direct table import, specify an object containing the table and schema for the dataset.
- For SQL datasets, specify an object containing the internationalized name and sql for the dataset.

Install

pkg:maven/com.luzmo/sdk@1.0.0

Example Request

Shell

Node

Java

.NET

Python

PHP

Luzmo client = new Luzmo(
  "<your Luzmo API key>",
  "<your Luzmo API token>",
  "https://api.luzmo.com"
);


JSONObject response = client.create("dataprovider",
  ImmutableMap.of(
    "provider" , "mysql",
    "account_id" , "<your connection id>",
    "tables" , ImmutableList.of(
      ImmutableMap.of(
        "name" , ImmutableMap.of(
          "en" , "SQL query"
        ),
        "sql" , "SELECT * FROM <schema>.<table>"
      )
    )
  )
);

Example Response

200

400

500

{
  "count": 1,
  "data": [
    {
      "rows": 0,
      "featured": false,
      "modified_at": "2024-08-02T15:38:03.081Z",
      "cache": 0,
      "uses_clickhouse_experimental": false,
      "meta_sync_interval": 1,
      "meta_sync_inherit": true,
      "meta_sync_enabled": true,
      "id": "b5f0a751-5609-48b6-8419-b1fe928e873d",
      "type": "dataset",
      "account_id": "<your connection id>",
      "source_dataset": "<your connection id>",
      "subtype": "mysql",
      "storage": "client",
      "name": {
        "en": "SQL query"
      },
      "source_query": "SELECT * FROM <schema>.<table>",
      "updated_at": "2024-08-02T15:38:03.109Z",
      "created_at": "2024-08-02T15:38:03.081Z",
      "description": null,
      "contents": null,
      "css": null,
      "transformation": null,
      "subtitle": null,
      "source_sheet": null,
      "is_variant": false,
      "migrated_rows": null,
      "last_metadata_sync_at": null,
      "last_metadata_sync_attempt_at": "2024-08-02T15:38:03.084Z",
      "original_id": null,
      "acceleration_id": null,
      "template_id": null,
      "modifier_id": "abca9830-0dad-4b11-a6d4-23972c124020",
      "owner_id": "abca9830-0dad-4b11-a6d4-23972c124020",
      "source_template_id": null
    }
  ]
}