> ## Documentation Index
> Fetch the complete documentation index at: https://docs.rippit.com/llms.txt
> Use this file to discover all available pages before exploring further.

# manage_snowflake_import

> **Manage Snowflake import**

Import tables from the customer's own Snowflake account into Rippit as scheduled syncs, change them, or run, pause, resume, reset or delete one. `create` starts a full-table sync immediately, then repeats every `cadence_hours`, running queries on the customer's warehouse and copying the rows into Rippit.

How to use:
- create and update touch only the listed tables (up to 100); other imports on the connection keep running. update needs only the fields that change.
- Changing `primary_keys` or `updated_at_column` replaces the import with a new table and a full re-pull.
- `run` only works on an active import; `resume` also syncs a paused one right away. Syncs are async; list_snowflake_imports shows progress.
- `delete` removes the import from Rippit's table list; rows already imported stay stored.
- Workspace admins only; anyone else gets a 403 on every Snowflake call, so don't retry.



## OpenAPI

````yaml /api-reference/tools-openapi.json post /v1/manage_snowflake_import
openapi: 3.1.0
info:
  title: Rippit API
  version: 1.0.0
  description: Every operation is also an MCP tool with the same name and parameters.
servers:
  - url: https://api.rippit.com
security:
  - bearer: []
paths:
  /v1/manage_snowflake_import:
    post:
      summary: manage_snowflake_import
      description: >-
        **Manage Snowflake import**


        Import tables from the customer's own Snowflake account into Rippit as
        scheduled syncs, change them, or run, pause, resume, reset or delete
        one. `create` starts a full-table sync immediately, then repeats every
        `cadence_hours`, running queries on the customer's warehouse and copying
        the rows into Rippit.


        How to use:

        - create and update touch only the listed tables (up to 100); other
        imports on the connection keep running. update needs only the fields
        that change.

        - Changing `primary_keys` or `updated_at_column` replaces the import
        with a new table and a full re-pull.

        - `run` only works on an active import; `resume` also syncs a paused one
        right away. Syncs are async; list_snowflake_imports shows progress.

        - `delete` removes the import from Rippit's table list; rows already
        imported stay stored.

        - Workspace admins only; anyone else gets a 403 on every Snowflake call,
        so don't retry.
      operationId: manage_snowflake_import
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                action:
                  type: string
                  enum:
                    - create
                    - update
                    - run
                    - pause
                    - resume
                    - reset
                    - delete
                  description: >-
                    create or update imports for tables on a connection; run
                    syncs an active import now; pause/resume its schedule; reset
                    re-imports the whole table; delete stops it.
                connection_id:
                  description: create and update only.
                  type: string
                  minLength: 1
                tables:
                  description: 'create and update only: tables to import or change.'
                  minItems: 1
                  maxItems: 100
                  type: array
                  items:
                    type: object
                    properties:
                      database:
                        type: string
                        minLength: 1
                        maxLength: 256
                        description: Snowflake database, exactly as Snowflake lists it.
                      schema_name:
                        type: string
                        minLength: 1
                        maxLength: 256
                        description: Snowflake schema, exactly as Snowflake lists it.
                      table:
                        type: string
                        minLength: 1
                        maxLength: 256
                        description: Snowflake table, exactly as Snowflake lists it.
                      primary_keys:
                        description: >-
                          Columns that uniquely identify a row. Required for
                          create.
                        minItems: 1
                        maxItems: 32
                        type: array
                        items:
                          type: string
                          minLength: 1
                      updated_at_column:
                        description: >-
                          Timestamp column used as the high-watermark filter for
                          incremental syncs and the version ordering key to
                          deduplicate rows by primary key (e.g., updated_at).
                          null re-reads the whole table each sync.
                        anyOf:
                          - type: string
                            minLength: 1
                          - type: 'null'
                      cadence_hours:
                        description: Sync every 1 or 24 hours. Defaults to 24.
                        anyOf:
                          - type: number
                            const: 1
                          - type: number
                            const: 24
                    required:
                      - database
                      - schema_name
                      - table
                    additionalProperties: false
                import_id:
                  description: >-
                    Import id from list_snowflake_imports. Required for run,
                    pause, resume, reset and delete.
                  type: string
                  minLength: 1
              required:
                - action
              additionalProperties: false
      responses:
        '200':
          description: Tool result.
components:
  securitySchemes:
    bearer:
      type: http
      scheme: bearer

````

This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.