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.
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.
Import id from list_snowflake_imports. Required for run, pause, resume, reset and delete.
Minimum string length: 1
Response
200
Tool result.
Was this page helpful?
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Rippit","description":"Rippit product documentation","colors":{"primary":"#079669","light":"#56b98f","dark":"#008156"},"logo":{"light":"https://mintcdn.com/rippit-ddefb232/uzkTtzpXlUcSK32Q/logo/light.svg?fit=max\u0026auto=format\u0026n=uzkTtzpXlUcSK32Q\u0026q=85\u0026s=8950a1dcb68093d7ac8370f0f847f209","dark":"https://mintcdn.com/rippit-ddefb232/za2WGhSTe9ZLSBxZ/logo/dark.svg?fit=max\u0026auto=format\u0026n=za2WGhSTe9ZLSBxZ\u0026q=85\u0026s=8d626999b237e3103f24ffd34727bbd0"},"favicon":"https://mintcdn.com/rippit-ddefb232/uzkTtzpXlUcSK32Q/favicon.svg?fit=max\u0026auto=format\u0026n=uzkTtzpXlUcSK32Q\u0026q=85\u0026s=18b85aa33156e5e27477e6f3bc3a4242","navbar":{"links":[{"href":"https://status.rippit.com","label":"Status"}],"primary":{"type":"button","label":"Open Rippit","href":"https://app.rippit.com"}},"footer":{"socials":{}},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"rippit-ddefb232","hasAudioNarration":false,"actualSubdomain":"rippit-ddefb232","customDomains":["docs.rippit.com"],"gitSource":{"type":"github","owner":"adtribute","repo":"analytics","deployBranch":"master","contentDirectory":"docs","isPrivate":true,"mountPath":"","label":""},"feedback":{"thumbs":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6af12f972c3c90c870ace2bf","clientVersion":"0.0.4088","searchFilterCounts":[{"language":"default","tag":"Guides","count":89},{"language":"default","tag":"Connect your Data","count":44},{"language":"default","tag":"API reference","count":44},{"language":"default","tag":"MCP servers","count":29},{"language":"default","tag":"MCP Server details","count":27},{"language":"default","tag":"Connect data","count":27},{"language":"default","tag":"Connect your AI Agent","count":21},{"language":"default","tag":"AI Agent Details","count":17},{"language":"default","tag":"Data integrations","count":15},{"language":"default","tag":"Bulk API","count":14}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"comment-mode","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"#pagination{display:none}"}],"page":{"pagePath":"api-reference/manage_snowflake_import","slug":"/api-reference/manage_snowflake_import","pageMetadata":{"title":"manage_snowflake_import","description":"**Manage Snowflake import**\n\nImport 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.\n\nHow to use:\n- 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.\n- Changing `primary_keys` or `updated_at_column` replaces the import with a new table and a full re-pull.\n- `run` only works on an active import; `resume` also syncs a paused one right away. Syncs are async; list_snowflake_imports shows progress.\n- `delete` removes the import from Rippit's table list; rows already imported stay stored.\n- Workspace admins only; anyone else gets a 403 on every Snowflake call, so don't retry.","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/manage_snowflake_import","href":"/api-reference/manage_snowflake_import","autogeneratedByOpenApi":true},"description":{"compiledSource":"\"use strict\";\nconst {Fragment: _Fragment, jsx: _jsx, jsxs: _jsxs} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n code: \"code\",\n li: \"li\",\n p: \"p\",\n strong: \"strong\",\n ul: \"ul\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsxs(_Fragment, {\n children: [_jsx(_components.p, {\n children: _jsx(_components.strong, {\n children: \"Manage Snowflake import\"\n })\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"Import tables from the customer’s own Snowflake account into Rippit as scheduled syncs, change them, or run, pause, resume, reset or delete one. \", _jsx(_components.code, {\n children: \"create\"\n }), \" starts a full-table sync immediately, then repeats every \", _jsx(_components.code, {\n children: \"cadence_hours\"\n }), \", running queries on the customer’s warehouse and copying the rows into Rippit.\"]\n }), \"\\n\", _jsx(_components.p, {\n children: \"How to use:\"\n }), \"\\n\", _jsxs(_components.ul, {\n children: [\"\\n\", _jsx(_components.li, {\n children: \"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.\"\n }), \"\\n\", _jsxs(_components.li, {\n children: [\"Changing \", _jsx(_components.code, {\n children: \"primary_keys\"\n }), \" or \", _jsx(_components.code, {\n children: \"updated_at_column\"\n }), \" replaces the import with a new table and a full re-pull.\"]\n }), \"\\n\", _jsxs(_components.li, {\n children: [_jsx(_components.code, {\n children: \"run\"\n }), \" only works on an active import; \", _jsx(_components.code, {\n children: \"resume\"\n }), \" also syncs a paused one right away. Syncs are async; list_snowflake_imports shows progress.\"]\n }), \"\\n\", _jsxs(_components.li, {\n children: [_jsx(_components.code, {\n children: \"delete\"\n }), \" removes the import from Rippit’s table list; rows already imported stay stored.\"]\n }), \"\\n\", _jsx(_components.li, {\n children: \"Workspace admins only; anyone else gets a 403 on every Snowflake call, so don’t retry.\"\n }), \"\\n\"]\n })]\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){return _jsx(_Fragment,{})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"manage_snowflake_import","description":"**Manage Snowflake import**\n\nImport 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.\n\nHow to use:\n- 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.\n- Changing `primary_keys` or `updated_at_column` replaces the import with a new table and a full re-pull.\n- `run` only works on an active import; `resume` also syncs a paused one right away. Syncs are async; list_snowflake_imports shows progress.\n- `delete` removes the import from Rippit's table list; rows already imported stay stored.\n- Workspace admins only; anyone else gets a 403 on every Snowflake call, so don't retry.","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/manage_snowflake_import","href":"/api-reference/manage_snowflake_import","autogeneratedByOpenApi":true}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"openApiReferenceData":{"operation":{"operationId":"manage_snowflake_import","summary":"manage_snowflake_import","description":"**Manage Snowflake import**\n\nImport 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.\n\nHow to use:\n- 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.\n- Changing `primary_keys` or `updated_at_column` replaces the import with a new table and a full re-pull.\n- `run` only works on an active import; `resume` also syncs a paused one right away. Syncs are async; list_snowflake_imports shows progress.\n- `delete` removes the import from Rippit's table list; rows already imported stay stored.\n- Workspace admins only; anyone else gets a 403 on every Snowflake call, so don't retry.","requestBody":"2d2dc4d9-2c92-41bc-bee2-fdb4f25ea343","responses":{"200":"81656c34-79ef-4ea4-80d0-336a86ec8b9e"},"x-mint":{"metadata":{"playground":"none"}},"method":"post","type":"path","servers":["adeb82bd-a22a-4c6a-98ee-f48b86a1e79d"],"security":["44493fb5-0be1-4fe2-8ec1-c85fcb9b4491"],"path":"/v1/manage_snowflake_import","baseUrlOptions":["https://api.rippit.com"],"title":"manage_snowflake_import","codeSamples":[],"requiredOnlyExamples":false,"requestExampleType":"generated","responseExampleType":"generated"},"dependencies":{"parameters":{},"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.","isRequired":true,"uniqueKey":"action","typeLabel":"enum\u003cstring>"},"connection_id":{"description":"create and update only.","type":"string","minLength":1,"uniqueKey":"connection_id","typeLabel":"string"},"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.","isRequired":true,"uniqueKey":"tables.items.[INDEX].database","typeLabel":"string"},"schema_name":{"type":"string","minLength":1,"maxLength":256,"description":"Snowflake schema, exactly as Snowflake lists it.","isRequired":true,"uniqueKey":"tables.items.[INDEX].schema_name","typeLabel":"string"},"table":{"type":"string","minLength":1,"maxLength":256,"description":"Snowflake table, exactly as Snowflake lists it.","isRequired":true,"uniqueKey":"tables.items.[INDEX].table","typeLabel":"string"},"primary_keys":{"description":"Columns that uniquely identify a row. Required for create.","minItems":1,"maxItems":32,"type":"array","items":{"type":"string","minLength":1,"uniqueKey":"tables.items.[INDEX].primary_keys.items.[INDEX]","typeLabel":"string"},"uniqueKey":"tables.items.[INDEX].primary_keys","typeLabel":"string[]"},"updated_at_column":{"oneOf":[{"type":"string","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.","minLength":1,"uniqueKey":"tables.items.[INDEX].updated_at_column.oneOf.0","typeLabel":"string"},{"type":"null","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.","uniqueKey":"tables.items.[INDEX].updated_at_column.oneOf.1","typeLabel":"null"}],"uniqueKey":"tables.items.[INDEX].updated_at_column","typeLabel":"string | null"},"cadence_hours":{"oneOf":[{"type":"number","description":"Sync every 1 or 24 hours. Defaults to 24.","const":1,"uniqueKey":"tables.items.[INDEX].cadence_hours.oneOf.0","typeLabel":"number"},{"type":"number","description":"Sync every 1 or 24 hours. Defaults to 24.","const":24,"uniqueKey":"tables.items.[INDEX].cadence_hours.oneOf.1","typeLabel":"number"}],"uniqueKey":"tables.items.[INDEX].cadence_hours","typeLabel":"number"}},"required":["database","schema_name","table"],"additionalProperties":false,"uniqueKey":"tables.items.[INDEX]","typeLabel":"object"},"uniqueKey":"tables","typeLabel":"object[]"},"import_id":{"description":"Import id from list_snowflake_imports. Required for run, pause, resume, reset and delete.","type":"string","minLength":1,"uniqueKey":"import_id","typeLabel":"string"}},"required":["action"],"additionalProperties":false,"uniqueKey":"","typeLabel":"object"},"examples":{"Example":{"title":"Example","value":{"connection_id":"\u003cstring>","tables":[{"database":"\u003cstring>","schema_name":"\u003cstring>","table":"\u003cstring>","primary_keys":["\u003cstring>"],"updated_at_column":"\u003cstring>","cadence_hours":1}],"import_id":"\u003cstring>"}}},"exampleType":"generated"}},"exampleType":"generated"},"responses":{"81656c34-79ef-4ea4-80d0-336a86ec8b9e":{"description":"Tool result.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}}},"security":{"44493fb5-0be1-4fe2-8ec1-c85fcb9b4491":{"bearer":{"type":"http","scheme":"bearer","scopes":[],"schemeName":"bearer"}}},"servers":{"adeb82bd-a22a-4c6a-98ee-f48b86a1e79d":{"url":"https://api.rippit.com"}},"processedSecurityOptions":[{"schemes":[{"scheme":{"type":"http","scheme":"bearer","scopes":[],"schemeName":"bearer"},"schema":{"title":"Bearer Auth","type":"string","isRequired":true,"description":"Bearer authentication header of the form `Bearer \u003ctoken>`, where `\u003ctoken>` is your auth token.","format":"bearer","typeLabel":"string\u003cbearer>","deprecated":false},"schemeName":"bearer","name":"Authorization"}],"title":"bearer"}]},"originalFileLocation":"api-reference/tools-openapi.json"},"subdomain":"rippit-ddefb232","siteName":"Rippit","title":"manage_snowflake_import - Rippit","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-11-09T01:29:32.371Z","originalFileLocation":"api-reference/manage_snowflake_import.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Manage Snowflake import Import tables from the customer\u0026#x27;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\u0026#x27;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\u0026#x27;s table list; rows already imported stay stored. - Workspace admins only; anyone else gets a 403 on every Snowflake call, so don\u0026#x27;t retry.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Rippit\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/rippit-ddefb232/u1OvlVJ9fpltsljb/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/rippit-ddefb232/u1OvlVJ9fpltsljb/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/rippit-ddefb232/u1OvlVJ9fpltsljb/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/rippit-ddefb232/u1OvlVJ9fpltsljb/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/rippit-ddefb232/u1OvlVJ9fpltsljb/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/rippit-ddefb232/u1OvlVJ9fpltsljb/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/rippit-ddefb232/u1OvlVJ9fpltsljb/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/rippit-ddefb232/u1OvlVJ9fpltsljb/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/rippit-ddefb232/u1OvlVJ9fpltsljb/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"manage_snowflake_import - Rippit\">\u003cmeta data-mint-head property=\"og:description\" content=\"Manage Snowflake import Import tables from the customer\u0026#x27;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\u0026#x27;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\u0026#x27;s table list; rows already imported stay stored. - Workspace admins only; anyone else gets a 403 on every Snowflake call, so don\u0026#x27;t retry.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Rippit\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.rippit.com/api-reference/manage_snowflake_import\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://rippit-ddefb232.mintlify.site/_mintlify/api/og/v2?division=Snowflake\u0026amp;title=manage_snowflake_import\u0026amp;description=**Manage+Snowflake+import**%0A%0AImport+tables+from+the+customer%27s+own+Snowflake+account+into+Rippit+as+scheduled+syncs%2C+change+them%2C+or+run%2C+pause%2C+resume%2C+reset+o\u0026amp;theme=cc7de14802162a79d7966e1d\u0026amp;signature=7df6024c7b5262feaabce0f35bed2d178868d469781b1c040b31be61d8eb21c9\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"manage_snowflake_import - Rippit\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Manage Snowflake import Import tables from the customer\u0026#x27;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\u0026#x27;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\u0026#x27;s table list; rows already imported stay stored. - Workspace admins only; anyone else gets a 403 on every Snowflake call, so don\u0026#x27;t retry.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://rippit-ddefb232.mintlify.site/_mintlify/api/og/v2?division=Snowflake\u0026amp;title=manage_snowflake_import\u0026amp;description=**Manage+Snowflake+import**%0A%0AImport+tables+from+the+customer%27s+own+Snowflake+account+into+Rippit+as+scheduled+syncs%2C+change+them%2C+or+run%2C+pause%2C+resume%2C+reset+o\u0026amp;theme=cc7de14802162a79d7966e1d\u0026amp;signature=7df6024c7b5262feaabce0f35bed2d178868d469781b1c040b31be61d8eb21c9\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/rippit-ddefb232/u1OvlVJ9fpltsljb/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Rippit\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#079669\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.rippit.com/api-reference/manage_snowflake_import\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/api-reference/manage_snowflake_import.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.rippit.com/#organization\",\"name\":\"Rippit\",\"url\":\"https://docs.rippit.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/rippit-ddefb232/uzkTtzpXlUcSK32Q/logo/light.svg?fit=max\u0026auto=format\u0026n=uzkTtzpXlUcSK32Q\u0026q=85\u0026s=8950a1dcb68093d7ac8370f0f847f209\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.rippit.com#website\",\"name\":\"Rippit\",\"url\":\"https://docs.rippit.com\",\"publisher\":{\"@id\":\"https://docs.rippit.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.rippit.com/api-reference/manage_snowflake_import#webpage\",\"url\":\"https://docs.rippit.com/api-reference/manage_snowflake_import\",\"name\":\"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.\",\"dateModified\":\"2026-11-09T01:29:32.371Z\",\"isPartOf\":{\"@id\":\"https://docs.rippit.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.rippit.com/api-reference/manage_snowflake_import#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.rippit.com/api-reference/manage_snowflake_import#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Connect data\",\"item\":\"https://docs.rippit.com/api-reference/connect/overview\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Snowflake\",\"item\":\"https://docs.rippit.com/api-reference/connect/snowflake/overview\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"manage_snowflake_import\",\"item\":\"https://docs.rippit.com/api-reference/manage_snowflake_import\"}]},{\"@type\":[\"TechArticle\",\"APIReference\"],\"@id\":\"https://docs.rippit.com/api-reference/manage_snowflake_import#apireference\",\"headline\":\"manage_snowflake_import\",\"name\":\"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.\",\"url\":\"https://docs.rippit.com/api-reference/manage_snowflake_import\",\"mainEntityOfPage\":{\"@id\":\"https://docs.rippit.com/api-reference/manage_snowflake_import#webpage\"},\"dateModified\":\"2026-11-09T01:29:32.371Z\",\"publisher\":{\"@id\":\"https://docs.rippit.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.rippit.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Rippit\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Rippit","nav":{"global":null,"tabs":[{"tab":"Guides","pages":[{"title":"Guides","href":"/overview"}]},{"tab":"API reference","groups":[{"group":"Get started","pages":[{"title":"API overview","sidebarTitle":"Overview","href":"/api-reference/overview"},{"title":"Authentication","href":"/api-reference/authentication"}]},{"group":"Connect data","pages":[{"title":"Connect data","sidebarTitle":"Overview","href":"/api-reference/connect/overview"},{"group":"Built-in integrations","pages":[{"title":"Built-in integrations","sidebarTitle":"Overview","href":"/api-reference/connect/integrations/overview"},{"title":"get_integration_state","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/get_integration_state","href":"/api-reference/get_integration_state"},{"title":"connect_integration","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/connect_integration","href":"/api-reference/connect_integration"},{"title":"import_integration","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/import_integration","href":"/api-reference/import_integration"},{"title":"list_active_integrations","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/list_active_integrations","href":"/api-reference/list_active_integrations"}]},{"group":"Snowflake","pages":[{"title":"Snowflake","sidebarTitle":"Overview","href":"/api-reference/connect/snowflake/overview"},{"title":"list_snowflake_connections","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/list_snowflake_connections","href":"/api-reference/list_snowflake_connections"},{"title":"manage_snowflake_connection","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/manage_snowflake_connection","href":"/api-reference/manage_snowflake_connection"},{"title":"list_snowflake_tables","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/list_snowflake_tables","href":"/api-reference/list_snowflake_tables"},{"title":"describe_snowflake_table","description":"**Describe Snowflake table**\n\nRead the columns of a table in the customer's own Snowflake account, before importing it. Not for Rippit tables — use describe_table for those.\n\nHow to use:\n- Pick the import's `primary_keys` and `updated_at_column` from these columns. Snowflake rarely declares primary keys, so an empty `primary_keys` is normal: choose the column(s) that uniquely identify a row.\n- `merge_keys` is the key the pipeline itself loads on, derived from the last 7 days of successful MERGE, DELETE and UPDATE statements in Snowflake's query history. It's the strongest evidence for `primary_keys`. If the import rejects it for duplicates, report that as an upstream data bug and show the user the stats; don't swap in other columns. It's empty when no load matched or the role can't read query history.\n- `merge_updated_at` is the best `updated_at_column` when it comes from that same query history: the column in the pipeline's own incremental `> (SELECT MAX(col) ...)` filter. Without one, it's a guess: the only timestamp column named like updated, modified or loaded, or an ETL tool's sync column such as `_fivetran_synced` or `_airbyte_extracted_at`.\n- Workspace admins only; anyone else gets a 403 on every Snowflake call, so don't retry.","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/describe_snowflake_table","href":"/api-reference/describe_snowflake_table"},{"title":"manage_snowflake_import","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/manage_snowflake_import","href":"/api-reference/manage_snowflake_import"},{"title":"list_snowflake_imports","description":"**List Snowflake imports**\n\nList Snowflake tables being synced into Rippit, with each sync's schedule, status, rows written and last error.\n\nHow to use:\n- `status` failed with an `error` usually needs a fix in Snowflake (permissions, dropped column), then manage_snowflake_import with action `run`.\n- Workspace admins only; anyone else gets a 403 on every Snowflake call, so don't retry.","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/list_snowflake_imports","href":"/api-reference/list_snowflake_imports"}]},{"group":"Bulk API","pages":[{"title":"Bulk API","sidebarTitle":"Overview","href":"/api-reference/connect/bulk/overview"},{"title":"Conversations","href":"/api-reference/connect/bulk/conversations"},{"title":"Tables","href":"/api-reference/connect/bulk/tables"},{"title":"Bulk export","sidebarTitle":"Export","href":"/api-reference/connect/bulk/export"},{"title":"Bulk API skill","sidebarTitle":"Skill","href":"/api-reference/connect/bulk/rippit-bulk-ingest-api"},{"title":"Post Conversation Source","deprecated":null,"version":null,"openapi":"/api-reference/bulk-openapi.json post /bulk_ingest/conversation_sources","href":"/api-reference/bulk_ingest/post-conversation-source"},{"title":"Get Conversation Sources","deprecated":null,"version":null,"openapi":"/api-reference/bulk-openapi.json get /bulk_ingest/conversation_sources","href":"/api-reference/bulk_ingest/get-conversation-sources"},{"title":"Post Conversation Blocks Bulk","deprecated":null,"version":null,"openapi":"/api-reference/bulk-openapi.json post /bulk_ingest/conversation_blocks/bulk","href":"/api-reference/bulk_ingest/post-conversation-blocks-bulk"},{"title":"Post Dataset","deprecated":null,"version":null,"openapi":"/api-reference/bulk-openapi.json post /bulk_ingest/datasets","href":"/api-reference/bulk_ingest/post-dataset"},{"title":"Patch Dataset By Query","deprecated":null,"version":null,"openapi":"/api-reference/bulk-openapi.json patch /bulk_ingest/datasets","href":"/api-reference/bulk_ingest/patch-dataset-by-query"},{"title":"Post Dataset Bulk By Query","deprecated":null,"version":null,"openapi":"/api-reference/bulk-openapi.json post /bulk_ingest/datasets/bulk","href":"/api-reference/bulk_ingest/post-dataset-bulk-by-query"},{"title":"Post Job Start","deprecated":null,"version":null,"openapi":"/api-reference/bulk-openapi.json post /bulk_ingest/jobs/{job_id}/start","href":"/api-reference/bulk_ingest/post-job-start"},{"title":"Get Job","deprecated":null,"version":null,"openapi":"/api-reference/bulk-openapi.json get /bulk/jobs/{job_id}","href":"/api-reference/bulk/get-job"},{"title":"Create Export Job","deprecated":null,"version":null,"openapi":"/api-reference/bulk-openapi.json post /bulk_export/tables","href":"/api-reference/bulk_export/create-export-job"}]}]},{"group":"Analyze data","pages":[{"group":"Query data","pages":[{"title":"Query data","sidebarTitle":"Overview","href":"/api-reference/query/overview"},{"title":"list_data_sources","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/list_data_sources","href":"/api-reference/list_data_sources"},{"title":"describe_table","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/describe_table","href":"/api-reference/describe_table"},{"title":"describe_column","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/describe_column","href":"/api-reference/describe_column"},{"title":"read_table","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/read_table","href":"/api-reference/read_table"},{"title":"aggregate_table","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/aggregate_table","href":"/api-reference/aggregate_table"},{"title":"pivot_table","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/pivot_table","href":"/api-reference/pivot_table"},{"title":"read_conversations","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/read_conversations","href":"/api-reference/read_conversations"}]},{"group":"Worksheets","pages":[{"title":"Worksheets","sidebarTitle":"Overview","href":"/api-reference/worksheets/overview"},{"title":"list_worksheets","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/list_worksheets","href":"/api-reference/list_worksheets"},{"title":"create_worksheet","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/create_worksheet","href":"/api-reference/create_worksheet"},{"title":"enrich_worksheet","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/enrich_worksheet","href":"/api-reference/enrich_worksheet"},{"title":"get_enrich_status","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/get_enrich_status","href":"/api-reference/get_enrich_status"},{"title":"export_worksheet","deprecated":null,"version":null,"playground":"none","openapi":"/api-reference/tools-openapi.json post /v1/export_worksheet","href":"/api-reference/export_worksheet"}]}]},{"group":"AI pipelines","pages":[{"title":"AI pipelines","sidebarTitle":"Overview","href":"/api-reference/pipelines/overview"}]}]}]},"basePath":"","title":"manage_snowflake_import - Rippit","buildId":"dpl_DTau1J5HqS9UTgVSDwGksstFWtPa","deploymentId":"dpl_DTau1J5HqS9UTgVSDwGksstFWtPa","dynamics":["c2aa737661","2b790eda92","b0f84f53ff","a9bb46feb3"],"chunks":["OpenApiReferenceProvider-5FCzAcfS.js","utils-SLtAG4EZ.js","cloneDeep-izs3Hzxb.js","_Uint8Array-BVIqJ90l.js","isObjectLike-C8vmzPEN.js","isArray-Dcu1dQ5t.js","utils-2DZi8ZMu.js","toString-BX-iyh8G.js","isSymbol-CSH9U2Gm.js","addUniqueKeysToSchema-D7J3nkzE.js","snippetPresets-D0Alv0AH.js","style-to-object-BY3JEAdk.js","v4-DIgz8zy6.js","conditional-requirements-CFM0id0Q.js","ApiExamples-BI4qNJ2c.js","isEqual-BfaiBbcl.js","usePlaygroundInputsStore-BD3uyr8j.js","shallow-D8iEBr5z.js","getApiPlaygroundDisplay-CgNP4lzR.js","CodeSnippet-CX-QHuMs.js","CodeSnippets-VlXE-ZUf.js","Page-D9ithiIZ.js","getPastedJson-DYNQkZ1M.js","icon-CzacdwOi.js","MethodPill-2JVqoYKi.js","DuplicateIcon-_xVXs-U8.js","createIcon-BRHrweLo.js","DynamicMarkdown-mQG_iQiE.js","SectionHeading-DMpJzv8f.js","axios-vUo_bRtp.js","Markdown-5FGIym-8.js","clsx-D-TRO5q5.js","lib-DuNMoZ05.js","lib-B8HbPgcC.js","html-void-elements-mCSPHezU.js","dist-CdrJecqK.js","katex-YMM-FMeD.js","marked.esm-CZWythHk.js","AssistantPageLink-CHlcWBLM.js"]}