---
title: "Update Ingestion Source"
method: PATCH
path: "/console/v1/ingestion"
tags: ["Ingestions"]
---

# Update Ingestion Source

`PATCH /console/v1/ingestion`

## Request body

- union
  - object
    - `dataset` 'Metrics', required
    - `column_mapping` object
      - `unit_id` string, required — The unique user identifier this metric is for. This might not necessarily be a user_id - it could be a custom_id of some kind. Make sure this is in the same format as your logged unit_ids.
      - `id_type` string, required — The id_type the unit_id represents. Must be valid id_type. Default Statsig types are user_id/stable_id, but you may have generated custom id_types. Make sure this matches (case sensitive) a customID in your project, or you won’t get experiment results.
      - `dateid` string, required — Date of the daily metric, ISO formatted (ex. 2021-02-17). We’ll load custom metrics to whatever date you use here.
      - `metric_name` string, required — String format. Not null. Length < 128 characters.
      - `metric_value` string — Numeric value for the metric. This OR both of numerator and denominator need to be provided.
      - `numerator` string — Required for ratio metrics. If present along with a denominator in any record, the metric will be treated as ratio and only calculated for users with non-null denominators
      - `denominator` string — Required for ratio metrics. If present along with a numerator in any record, the metric will be treated as ratio and only calculated for users with non-null numerators.
    - `type` 'redshift' | 'bigquery-v2' | 'snowflake-v2' | 'databricks' | 'azure-synapse' | 's3' | 'athena' | 'adls', required
    - `source_name` string
    - `query` string
    - `share` string
    - `schema` string
    - `table` string
    - `enabled` boolean
  - object
    - `dataset` 'Events', required
    - `column_mapping` object
      - `unit_id` string — The unique user identifier this event is for. This might not necessarily be a single column for userID - it could be spread across multiple columns for deviceID etc.
      - `event_name` string, required — Name of the event. String under 128 characters, using ‘_’ for spaces.
      - `timestamp` string, required — Unix timestamp in seconds of the event (ex. 1613584800)
      - `ids` object, required
      - `metadata` object
      - `metadata_object` string
      - `event_value` string
    - `type` 'redshift' | 'bigquery-v2' | 'snowflake-v2' | 'databricks' | 'azure-synapse' | 's3' | 'athena' | 'adls', required
    - `source_name` string
    - `query` string
    - `share` string
    - `schema` string
    - `table` string
    - `enabled` boolean
  - object
    - `dataset` 'Exposures' | 'export_exposures', required
    - `column_mapping` object
      - `experiment` string, required — Unique identifier for the experiment.
      - `group_id` string, required — Unique identifier for the experiment groups.
      - `unit_id` string — The unique user identifier this exposure is for. This might not necessarily be a single column for userID - it could be spread across multiple columns for deviceID etc.
      - `timestamp` string, required — Unix timestamp in seconds of the event (ex. 1613584800)
      - `ids` object, required
      - `metadata` object
      - `metadata_object` string
      - `event_value` string
    - `type` 'redshift' | 'bigquery-v2' | 'snowflake-v2' | 'databricks' | 'azure-synapse' | 's3' | 'athena' | 'adls', required
    - `source_name` string
    - `query` string
    - `share` string
    - `schema` string
    - `table` string
    - `enabled` boolean

## Response `200`

Update Ingestion Success

- object
  - `message` string, required — A simple string explaining the result of the operation.
  - `data` object, required — A single result.
    - `id` string, required
    - `type` string, required
    - `enabled` boolean, required
    - `data` object, required

---

[API](https://skmtc.net/statsig/apis/console-api.md) · [All operations](https://skmtc.net/statsig/apis/console-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/statsig/console-api/versions/3189f450c93b/schema)