---
title: "Get import source schema"
method: POST
path: "/import/sources/{id}/get-schema"
tags: ["Import Sources"]
---

# Get import source schema

`POST /import/sources/{id}/get-schema`

Get column schema for an import source table or SQL query.

## Path parameters

- `id` string, required

## Request body

- union
  - object
    - `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.
  - object
    - `method` 'sql', required
    - `sql` SQLOptions, required
      - `query` string, required — SQL query to execute.
  - object
    - `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.

## Response `200`

OK

- object
  - `status` 'success', required
  - `data` SourceSchemaResponse, required
    - `schema` SourcePreviewSchemaField[], required
      - `name` string, required
      - `raw_type` string, required
      - `prequel_type` string, required
      - `ordinal_position` integer, required
      - `is_nullable` boolean
  - `message` string, required

## Other responses

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

---

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