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 two Clickhouse-backed datasets, 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
action: create
provider: clickhouse
datasets: array of one or multiple datasets that you would like to add.
- For direct table import, specify a concatenation of a database and table identifier, separated by a dot '.' (i.e. database.table ).
- For SQL datasets, specify an object containing the name and SQL for the dataset.

Install

npm install @luzmo/nodejs-sdk

Example Request

Shell

Node

Java

.NET

Python

PHP

import Luzmo from '@luzmo/nodejs-sdk';
const client = new Luzmo({
  api_key: '<your Luzmo API key>',
  api_token: '<your Luzmo API token>',
  host: 'https://api.luzmo.com'
});


const response = await client.create('dataprovider',
  {
    action: "create",
    account_id: "<your connection id>",
    provider: "clickhouse",
    datasets: [
      "database.table",
      "database.table"
    ]
  }
);

Example Response

200

400

500

{
  "count": 2,
  "data": [
    {
      "rows": 0,
      "featured": false,
      "modified_at": "2024-08-01T16:42:35.441Z",
      "cache": 0,
      "uses_clickhouse_experimental": false,
      "meta_sync_interval": 1,
      "meta_sync_inherit": true,
      "meta_sync_enabled": true,
      "id": "2c1c32f2-12f4-4a62-88dc-b235a0f0f172",
      "type": "dataset",
      "description": {
        "en": ""
      },
      "account_id": "441c9a9a-a291-484a-803c-3af93011a98c",
      "source_dataset": "441c9a9a-a291-484a-803c-3af93011a98c",
      "subtype": "clickhouse",
      "storage": "client",
      "source_sheet": "database.table",
      "name": {
        "en": "default - actors"
      },
      "updated_at": "2024-08-01T16:42:35.464Z",
      "created_at": "2024-08-01T16:42:35.441Z",
      "contents": null,
      "css": null,
      "transformation": null,
      "subtitle": null,
      "source_query": null,
      "is_variant": false,
      "migrated_rows": null,
      "last_metadata_sync_at": null,
      "last_metadata_sync_attempt_at": "2024-08-01T16:42:35.442Z",
      "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
    },
    {
      "rows": 0,
      "featured": false,
      "modified_at": "2024-08-01T16:42:35.441Z",
      "cache": 0,
      "uses_clickhouse_experimental": false,
      "meta_sync_interval": 1,
      "meta_sync_inherit": true,
      "meta_sync_enabled": true,
      "id": "1c8d02be-c37d-43a9-aac0-938c7c631759",
      "type": "dataset",
      "description": {
        "en": ""
      },
      "account_id": "441c9a9a-a291-484a-803c-3af93011a98c",
      "source_dataset": "441c9a9a-a291-484a-803c-3af93011a98c",
      "subtype": "clickhouse",
      "storage": "client",
      "source_sheet": "database.table",
      "name": {
        "en": "default - benchmark_results"
      },
      "updated_at": "2024-08-01T16:42:35.502Z",
      "created_at": "2024-08-01T16:42:35.441Z",
      "contents": null,
      "css": null,
      "transformation": null,
      "subtitle": null,
      "source_query": null,
      "is_variant": false,
      "migrated_rows": null,
      "last_metadata_sync_at": null,
      "last_metadata_sync_attempt_at": "2024-08-01T16:42:35.443Z",
      "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
    }
  ]
}