---
title: "Get model"
method: GET
path: "/models/{model_id}"
tags: ["Models"]
---

# Get model

`GET /models/{model_id}`

Retrieve an model.

## Path parameters

- `model_id` string, required

## Response `200`

OK

- object
  - `status` 'success', required
  - `data` ModelConfigResponseDocumented, required
    - `model` ModelConfigDocumented, required
      - `model_name` string, required — The name of the model. This is customer facing and will be used as the table name in the destination.
      - `description` string — A brief description of the table. This is customer facing and will be used as the table comment in the destination.
      - `columns` ModelColumnDocumented[], required
        - `name_in_source` string, required — The column name in the source.
        - `name_in_destination` string, required — The column name in the destination.
        - `data_type` string, required — The data type of the column.
        - `is_primary_key` boolean, required — Whether the column is a primary key. Note: all properties of the primary key are immutable and cannot be changed after creation.
        - `is_last_modified` boolean, required — Indicates if the column represents the last modified date/time.
      - `source_id` string, uuid, required — The source ID.
      - `source_table` string — The schema qualified source table in the database.
      - `source_query` string — The source query to use for this model.
      - `destination_table_name` string — The destination table in the database.
      - `organization_column` string — The column in the source table that links to the organization.
      - `skip_transfer_source_validation` boolean
      - `is_append_only` boolean — Determines if the destination write logical will optimize itself for append only data. Use of this flag with duplicate primary keys in the source data will cause integrity issues.
      - `model_validation_id_in_provider_system` string — Optional override for the provider system ID.
      - `model_validation_start_time_epoch` string, date-time — Optional override for the start time.
      - `model_validation_end_time_epoch` string, date-time — Optional override for the end time.
      - `model_validation_tags` object — Optional override for the tags.
  - `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)