Create Data

LLM-friendly URL
POST
https://api.luzmo.com/0.1.0/data
API call form
Examples

The data endpoint is rather a service than a resource. This service can be used to:

The create endpoint of the data service can be used to push data to Luzmo (and create a dataset to push into).

This endpoint can be used to:

  • add data to an existing dataset

  • overwrite data of an existing dataset

  • create a dataset and columns automatically from your data by analyzing the types.

Data in Luzmo is pushed to our highly efficient OLAP. This engine is be performant enough to handle aggregations on millions of rows.

There is a limit of pushing 10000 data points (i.e. rows) per call and a storage limit which can be found in our licensing information.

Tips on performance: out of the box, the performance should be very good. However, by linking datasets together, the performance will go down. How much the performance suffers depends on the cardinality of the columns that were linked. In general, prefer to store a table with many columns over many linked tables. If these columns will be queried in the same dashboard they probably belong together.

Parameters
Expand all Reset
properties *OBJECTrequired
securable_id STRING
data ARRAY[ARRAY]
type STRING
options OBJECT
Can be executed by:
Securable Owner
Can be associated to:
Create AI Chart
Get Data
Did this page help you?
Yes No
Language
Shell
Node
Java
.NET
Python
PHP
Install
npm install @luzmo/nodejs-sdk
Example Request 
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('data',
  {
    type: "create",
    data: [
      
      [
        "Chicken baconito ",
        3,
        500,
        "menu"
      ],
      
      [
        "Quesarito",
        3.5,
        700,
        "menu"
      ]
    ],
    options: {
      update_metadata: true,
      header: [
        "Burrito",
        "price",
        "weight",
        "order type"
      ],
      name: {
        en: "Burritos"
      }
    }
  }
);
You are not authenticated.
Log in to try
Example Response
200
400
500
{
  "count": 1,
  "rows": [
    {
      "id": "2b00508b-9a8a-4de8-b091-6c5b38be80a0",
      "type": "dataset",
      "subtype": "api",
      "name": {
        "en": "Burritos"
      },
      "description": null,
      "contents": null,
      "css": null,
      "rows": 2,
      "featured": false,
      "modified_at": "2025-05-28T13:10:16.096Z",
      "transformation": null,
      "subtitle": null,
      "source_dataset": null,
      "source_sheet": null,
      "source_query": null,
      "cache": 0,
      "storage": "clickhouse",
      "is_variant": false,
      "migrated_rows": null,
      "uses_clickhouse_experimental": true,
      "meta_sync_interval": 1,
      "meta_sync_inherit": true,
      "meta_sync_enabled": true,
      "last_metadata_sync_at": null,
      "last_metadata_sync_attempt_at": "2025-05-28T13:10:16.101Z",
      "shared_storage_version": "01971703-e8e7-71b4-8a33-38cab8493e44",
      "storage_location_override": null,
      "shared_storage_metadata": {
        "numeric": [
          "df6bb364-9673-4cf7-a401-aa01980ee6e4",
          "62f5b138-1887-40b1-a5db-999d08b84c5b"
        ],
        "hierarchy": [
          "e0e0e460-c88c-45b7-8dba-1addf33134c4",
          "df6bb364-9673-4cf7-a401-aa01980ee6e4",
          "62f5b138-1887-40b1-a5db-999d08b84c5b",
          "4fbf3d25-1400-4214-b449-1a2b931310de"
        ]
      },
      "original_id": null,
      "created_at": "2025-05-28T13:10:16.097Z",
      "updated_at": "2025-05-28T13:10:23.287Z",
      "acceleration_id": null,
      "account_id": null,
      "template_id": null,
      "modifier_id": "e64a9830-0dad-4b11-a6d4-23972c124020",
      "owner_id": "e64a9830-0dad-4b11-a6d4-23972c124020",
      "source_template_id": null,
      "columns": [
        {
          "id": "e0e0e460-c88c-45b7-8dba-1addf33134c4",
          "name": {
            "en": "Burrito"
          },
          "description": null,
          "order": 1,
          "source_name": "Burrito",
          "type": "hierarchy",
          "subtype": null,
          "format": "",
          "informat": "hierarchy",
          "previous_datetime_informat": null,
          "color": "#3182bd",
          "prefix": null,
          "suffix": null,
          "isLabel": false,
          "minBound": null,
          "maxBound": null,
          "cardinality": null,
          "lowestLevel": 0,
          "highestLevel": 0,
          "minimum": null,
          "maximum": null,
          "expression": null,
          "derivation": null,
          "version": 0,
          "width": 170,
          "hierarchy_enabled": false,
          "ordering_enabled": false,
          "colors_enabled": true,
          "aggregation_type": "sum",
          "custom_aggregations": null,
          "duration_levels": null,
          "duration_format": "long",
          "created_at": "2025-05-28T13:10:16.147Z",
          "updated_at": "2025-05-28T13:10:16.147Z",
          "securable_id": "2b00508b-9a8a-4de8-b091-6c5b38be80a0",
          "aggregation_id": null,
          "currency_id": null,
          "timezone_id": null
        },
        {
          "id": "df6bb364-9673-4cf7-a401-aa01980ee6e4",
          "name": {
            "en": "price"
          },
          "description": null,
          "order": 2,
          "source_name": "price",
          "type": "numeric",
          "subtype": null,
          "format": ".1af",
          "informat": "numeric",
          "previous_datetime_informat": null,
          "color": "#6baed6",
          "prefix": null,
          "suffix": null,
          "isLabel": false,
          "minBound": null,
          "maxBound": null,
          "cardinality": null,
          "lowestLevel": 0,
          "highestLevel": 0,
          "minimum": null,
          "maximum": null,
          "expression": null,
          "derivation": null,
          "version": 0,
          "width": 170,
          "hierarchy_enabled": false,
          "ordering_enabled": false,
          "colors_enabled": true,
          "aggregation_type": "sum",
          "custom_aggregations": null,
          "duration_levels": null,
          "duration_format": "long",
          "created_at": "2025-05-28T13:10:16.147Z",
          "updated_at": "2025-05-28T13:10:16.147Z",
          "securable_id": "2b00508b-9a8a-4de8-b091-6c5b38be80a0",
          "aggregation_id": null,
          "currency_id": null,
          "timezone_id": null
        },
        {
          "id": "62f5b138-1887-40b1-a5db-999d08b84c5b",
          "name": {
            "en": "weight"
          },
          "description": null,
          "order": 3,
          "source_name": "weight",
          "type": "numeric",
          "subtype": null,
          "format": ".0af",
          "informat": "numeric",
          "previous_datetime_informat": null,
          "color": "#9ecae1",
          "prefix": null,
          "suffix": null,
          "isLabel": false,
          "minBound": null,
          "maxBound": null,
          "cardinality": null,
          "lowestLevel": 0,
          "highestLevel": 0,
          "minimum": null,
          "maximum": null,
          "expression": null,
          "derivation": null,
          "version": 0,
          "width": 170,
          "hierarchy_enabled": false,
          "ordering_enabled": false,
          "colors_enabled": true,
          "aggregation_type": "sum",
          "custom_aggregations": null,
          "duration_levels": null,
          "duration_format": "long",
          "created_at": "2025-05-28T13:10:16.147Z",
          "updated_at": "2025-05-28T13:10:16.147Z",
          "securable_id": "2b00508b-9a8a-4de8-b091-6c5b38be80a0",
          "aggregation_id": null,
          "currency_id": null,
          "timezone_id": null
        },
        {
          "id": "4fbf3d25-1400-4214-b449-1a2b931310de",
          "name": {
            "en": "order type"
          },
          "description": null,
          "order": 4,
          "source_name": "order type",
          "type": "hierarchy",
          "subtype": null,
          "format": "",
          "informat": "hierarchy",
          "previous_datetime_informat": null,
          "color": "#c6dbef",
          "prefix": null,
          "suffix": null,
          "isLabel": false,
          "minBound": null,
          "maxBound": null,
          "cardinality": null,
          "lowestLevel": 0,
          "highestLevel": 0,
          "minimum": null,
          "maximum": null,
          "expression": null,
          "derivation": null,
          "version": 0,
          "width": 170,
          "hierarchy_enabled": false,
          "ordering_enabled": false,
          "colors_enabled": true,
          "aggregation_type": "sum",
          "custom_aggregations": null,
          "duration_levels": null,
          "duration_format": "long",
          "created_at": "2025-05-28T13:10:16.147Z",
          "updated_at": "2025-05-28T13:10:16.147Z",
          "securable_id": "2b00508b-9a8a-4de8-b091-6c5b38be80a0",
          "aggregation_id": null,
          "currency_id": null,
          "timezone_id": null
        }
      ]
    }
  ]
}