---
title: "Create import dataset"
method: POST
path: "/import/datasets"
tags: ["Import Datasets"]
---

# Create import dataset

`POST /import/datasets`

Add a new import dataset.

## Query parameters

- `skip_validation` boolean

## Request body

- CreateDatasetRequest
  - `dataset` union, required
    - object
      - `type` 'dimension', required
      - `dimension` DimensionOptions, required
        - `primary_key_column` string, required — Name of the primary key column.
        - `last_modified_column` string — Name of the last modified timestamp column (optional).
        - `is_deleted_column` string — Name of the soft delete column (optional).
      - `method` 'table', required
      - `table` TableOptions, required
        - `source_table_namespace` string, required — Namespace or schema of the source table.
        - `source_table_name` string, required — Name of the source table.
      - `name` string — Name of the dataset.
      - `source_id` string, uuid, required — ID of the import source this dataset belongs to.
      - `is_enabled` boolean — Whether this dataset is enabled.
      - `frequency_minutes` integer, required — Frequency in minutes for syncing this dataset.
    - object
      - `type` 'dimension', required
      - `dimension` DimensionOptions, required
        - `primary_key_column` string, required — Name of the primary key column.
        - `last_modified_column` string — Name of the last modified timestamp column (optional).
        - `is_deleted_column` string — Name of the soft delete column (optional).
      - `method` 'sql', required
      - `sql` SQLOptions, required
        - `query` string, required — SQL query to execute.
      - `name` string — Name of the dataset.
      - `source_id` string, uuid, required — ID of the import source this dataset belongs to.
      - `is_enabled` boolean — Whether this dataset is enabled.
      - `frequency_minutes` integer, required — Frequency in minutes for syncing this dataset.
    - object
      - `type` 'dimension', required
      - `dimension` DimensionOptions, required
        - `primary_key_column` string, required — Name of the primary key column.
        - `last_modified_column` string — Name of the last modified timestamp column (optional).
        - `is_deleted_column` string — Name of the soft delete column (optional).
      - `method` 'glob', required
      - `glob` GlobOptions, required
        - `pattern` string, required — Glob pattern for object files.
        - `format` 'csv' | 'parquet' | 'jsonl' | 'json', required — Format of the object files.
      - `name` string — Name of the dataset.
      - `source_id` string, uuid, required — ID of the import source this dataset belongs to.
      - `is_enabled` boolean — Whether this dataset is enabled.
      - `frequency_minutes` integer, required — Frequency in minutes for syncing this dataset.
    - object
      - `type` 'fact', required
      - `fact` FactOptions, required
        - `primary_key_column` string, required — Name of the primary key column.
        - `created_at_column` string, required — Name of the created at timestamp column (required for facts).
      - `method` 'table', required
      - `table` TableOptions, required
        - `source_table_namespace` string, required — Namespace or schema of the source table.
        - `source_table_name` string, required — Name of the source table.
      - `name` string — Name of the dataset.
      - `source_id` string, uuid, required — ID of the import source this dataset belongs to.
      - `is_enabled` boolean — Whether this dataset is enabled.
      - `frequency_minutes` integer, required — Frequency in minutes for syncing this dataset.
    - object
      - `type` 'fact', required
      - `fact` FactOptions, required
        - `primary_key_column` string, required — Name of the primary key column.
        - `created_at_column` string, required — Name of the created at timestamp column (required for facts).
      - `method` 'sql', required
      - `sql` SQLOptions, required
        - `query` string, required — SQL query to execute.
      - `name` string — Name of the dataset.
      - `source_id` string, uuid, required — ID of the import source this dataset belongs to.
      - `is_enabled` boolean — Whether this dataset is enabled.
      - `frequency_minutes` integer, required — Frequency in minutes for syncing this dataset.
    - object
      - `type` 'fact', required
      - `fact` FactOptions, required
        - `primary_key_column` string, required — Name of the primary key column.
        - `created_at_column` string, required — Name of the created at timestamp column (required for facts).
      - `method` 'glob', required
      - `glob` GlobOptions, required
        - `pattern` string, required — Glob pattern for object files.
        - `format` 'csv' | 'parquet' | 'jsonl' | 'json', required — Format of the object files.
      - `name` string — Name of the dataset.
      - `source_id` string, uuid, required — ID of the import source this dataset belongs to.
      - `is_enabled` boolean — Whether this dataset is enabled.
      - `frequency_minutes` integer, required — Frequency in minutes for syncing this dataset.

## Response `200`

OK

- object
  - `status` 'success', required
  - `data` GetDatasetResponse, required
    - `dataset` union, required
      - object
        - `type` 'dimension', required
        - `dimension` DimensionResource, required
          - `primary_key_column` string, required
          - `last_modified_column` string
          - `is_deleted_column` string
        - `method` 'table', required
        - `table` TableResource, required
          - `source_table_namespace` string, required
          - `source_table_name` string, required
        - `id` string, required
        - `name` string, required
        - `source_id` string, required
        - `is_enabled` boolean, required
        - `frequency_minutes` integer, required
        - `datalake_schema` string, required
        - `datalake_table_name` string, required
        - `created_at` string, required
        - `updated_at` string, required
      - object
        - `type` 'dimension', required
        - `dimension` DimensionResource, required
          - `primary_key_column` string, required
          - `last_modified_column` string
          - `is_deleted_column` string
        - `method` 'sql', required
        - `sql` SQLResource, required
          - `query` string, required
        - `id` string, required
        - `name` string, required
        - `source_id` string, required
        - `is_enabled` boolean, required
        - `frequency_minutes` integer, required
        - `datalake_schema` string, required
        - `datalake_table_name` string, required
        - `created_at` string, required
        - `updated_at` string, required
      - object
        - `type` 'dimension', required
        - `dimension` DimensionResource, required
          - `primary_key_column` string, required
          - `last_modified_column` string
          - `is_deleted_column` string
        - `method` 'glob', required
        - `glob` GlobResource, required
          - `pattern` string, required
          - `format` string, required
        - `id` string, required
        - `name` string, required
        - `source_id` string, required
        - `is_enabled` boolean, required
        - `frequency_minutes` integer, required
        - `datalake_schema` string, required
        - `datalake_table_name` string, required
        - `created_at` string, required
        - `updated_at` string, required
      - object
        - `type` 'fact', required
        - `fact` FactResource, required
          - `primary_key_column` string, required
          - `created_at_column` string, required
        - `method` 'table', required
        - `table` TableResource, required
          - `source_table_namespace` string, required
          - `source_table_name` string, required
        - `id` string, required
        - `name` string, required
        - `source_id` string, required
        - `is_enabled` boolean, required
        - `frequency_minutes` integer, required
        - `datalake_schema` string, required
        - `datalake_table_name` string, required
        - `created_at` string, required
        - `updated_at` string, required
      - object
        - `type` 'fact', required
        - `fact` FactResource, required
          - `primary_key_column` string, required
          - `created_at_column` string, required
        - `method` 'sql', required
        - `sql` SQLResource, required
          - `query` string, required
        - `id` string, required
        - `name` string, required
        - `source_id` string, required
        - `is_enabled` boolean, required
        - `frequency_minutes` integer, required
        - `datalake_schema` string, required
        - `datalake_table_name` string, required
        - `created_at` string, required
        - `updated_at` string, required
      - object
        - `type` 'fact', required
        - `fact` FactResource, required
          - `primary_key_column` string, required
          - `created_at_column` string, required
        - `method` 'glob', required
        - `glob` GlobResource, required
          - `pattern` string, required
          - `format` string, required
        - `id` string, required
        - `name` string, required
        - `source_id` string, required
        - `is_enabled` boolean, required
        - `frequency_minutes` integer, required
        - `datalake_schema` string, required
        - `datalake_table_name` string, required
        - `created_at` string, required
        - `updated_at` string, required
  - `message` string, required

## Other responses

- `400` — Bad Request
- `401` — Unauthorized
- `404` — Not Found
- `500` — Internal Server Error

---

[API](https://skmtc.net/prequel/apis/prequel-data-export.md) · [All operations](https://skmtc.net/prequel/apis/prequel-data-export/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/prequel/prequel-data-export/versions/09c662a871f8/schema)