OVERALL CONTROL / 0.6-customer-control
Grades and scoring
Data access
25% of the overall score before applicability adjustment.
Scored answers and evidence
Read interface 10.0/10
Queryable database or replicated schema
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
SQL API submits statements and returns partitioned results under the granted database/schema/warehouse context. Tables are queryable directly rather than only through fixed report APIs.
Snowflake SQL API ↗
Submit SQL, data access and result retrieval · Checked 2026-10-16
Bulk delivery 10.0/10
Customer-initiated native snapshot or full scoped table export
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
COPY INTO a customer-selected cloud location unloads table/query records in portable formats. This credits table data, while full DDL, roles, policies, functions, shares and account configuration require a separate restore inventory.
Snowflake table data unloading ↗
Unload tables/queries to named or external storage · Checked 2026-10-16
Query expressiveness 10.0/10
SQL or equivalent joins and aggregations against the operational system
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
Customers can issue SQL joins and aggregates against authorized tables. Resource governance, masking and row policies still apply to results.
Snowflake SQL API ↗
Submit SQL, data access and result retrieval · Checked 2026-10-16
Access cost barrier -
-
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
Standard includes SQL API, table streams and bulk unloading. Edition eligibility is established (not a fixed-price API allowance); complete fixed/API fees remain unresolved, with compute, storage and transfer charges assessed separately.
Snowflake edition feature matrix ↗
Feature and edition matrix: Snowflake SQL API; Bulk unloading; Streams for tracking table changes · Checked 2026-10-16
Third-party accessibility
20% of the overall score before applicability adjustment.
Scored answers and evidence
Third-party eligibility 10.0/10
Customer authorization without discretionary provider approval
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
Customer administrators create a custom OAuth security integration and grant roles, warehouse and object privileges. The chosen external client acts within those grants; Marketplace data listings are a separate product.
Snowflake custom OAuth clients ↗
Create custom security integration and role scope · Checked 2026-10-16
Downstream permission -
-
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
Applicable third-party processing, AI-use and redistribution terms require a separate contractual review.
Snowflake custom OAuth clients ↗
Create custom security integration and role scope · Checked 2026-10-16
External action
15% of the overall score before applicability adjustment.
Scored answers and evidence
Write interface 7.5/10
Create and update in one business domain
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
INSERT and UPDATE modify authorized table rows. Those DML operations depend on table privileges and transaction semantics; no arbitrary provider-service action is implied.
Snowflake INSERT operation ↗
INSERT rows and privilege requirements · Checked 2026-10-16
Snowflake UPDATE operation ↗
UPDATE syntax and table privileges · Checked 2026-10-16
Custom application path 10.0/10
Customer applications using fixed APIs without provider selection
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
Customers can build or choose applications using the documented API and the disclosed authorization route.
Snowflake custom OAuth clients ↗
Create custom security integration and role scope · Checked 2026-10-16
Continuity
15% of the overall score before applicability adjustment.
Scored answers and evidence
Refresh mechanism 10.0/10
Database change-data capture
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
Standard table streams expose change action, update flags and immutable row IDs, with transactional offset advancement. Consume before STALE_AFTER and coordinate independent consumers through separate streams.
Snowflake standard stream semantics ↗
Stream offsets, metadata columns and staleness · Checked 2026-10-16
Limit visibility 2.5/10
Governors or limits stated without quantities
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
SQL API documents rate/concurrency failures and exponential jittered backoff. The reviewed reference does not establish a universal numeric request quota across accounts and warehouses.
Snowflake SQL API errors and limits ↗
429, concurrency and jittered backoff · Checked 2026-10-16
CDC and deletion capture 10.0/10
Scoped database/change log captures inserts, updates and deletes with identity requirements disclosed
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
Standard table streams expose inserts, deletes and update pairs with METADATA$ROW_ID. Append-only and external-table stream semantics are outside this score.
Snowflake standard stream semantics ↗
Stream offsets, metadata columns and staleness · Checked 2026-10-16
Replay and gap recovery 7.5/10
Replay/change queries within a documented retention window
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
Streams retain a transactional offset within source history retention. STALE_AFTER and table retention limit recovery; stale streams require recreation and current-table reconciliation.
Snowflake standard stream semantics ↗
Stream offsets, metadata columns and staleness · Checked 2026-10-16
Data exit
20% of the overall score before applicability adjustment.
Scored answers and evidence
Export custody 10.0/10
Feed into a customer-controlled store
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
COPY INTO a customer-selected cloud location unloads table/query records in portable formats. This credits table data, while full DDL, roles, policies, functions, shares and account configuration require a separate restore inventory.
Snowflake table data unloading ↗
Unload tables/queries to named or external storage · Checked 2026-10-16
Post-cancellation access Disclosure
-
Disclosure only; does not reduce planned-exit credit.
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
The reviewed extraction guide does not establish contractual retrieval rights after cancellation.
Snowflake table data unloading ↗
Unload tables/queries to named or external storage · Checked 2026-10-16
Planned migration fidelity 7.5/10
Portable structured records on documented routes; whole-product completeness unverified
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
COPY INTO a customer-selected cloud location unloads table/query records in portable formats. This credits table data, while full DDL, roles, policies, functions, shares and account configuration require a separate restore inventory.
Snowflake table data unloading ↗
Unload tables/queries to named or external storage · Checked 2026-10-16
Business logic and customization
5% of the overall score before applicability adjustment.
Scored answers and evidence
Logic authoring 7.5/10
Customer-authored native scripts or custom APIs
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
Customers can author native SQL and JavaScript functions subject to runtime and privilege constraints. Ownership and independent reuse remain unresolved (downloaded table records do not include every executable definition).
Snowflake function definitions ↗
Create functions and supported languages · Checked 2026-10-16
Rights to custom logic -
-
Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded.
Native workflow ownership, reusable export and independent execution rights remain unresolved.
Snowflake custom OAuth clients ↗
Create custom security integration and role scope · Checked 2026-10-16
Scores are out of 10. * Incomplete evidence discounts verified capabilities (unknown answers stay unknown). Planned migration drives data exit. Scoring method ↗
CUSTOMER CHOICE
Third-party accessibility
Customer administrators create a custom OAuth security integration and grant roles, warehouse and object privileges. The chosen external client acts within those grants; Marketplace data listings are a separate product.
Confirm who can connect, who owns the credentials and which uses are permitted. Customer consent and provider approval can be separate requirements; the selected plan and contract still matter.
READ / INTEGRATE
API and export routes
SQL API submits statements and returns partitioned results under the granted database/schema/warehouse context. Tables are queryable directly rather than only through fixed report APIs. Customers can issue SQL joins and aggregates against authorized tables. Resource governance, masking and row policies still apply to results.
| Access route | Authentication | Credential owner | Provider approval | Access requirement | Last checked |
|---|---|---|---|---|---|
| Customer-authorized application | OAuth 2.0 | Integration provider | No | customer authorization | 2026-10-16 |
Availability depends on your product, plan and agreement. See the documentation below for the requirements of each route.
ECONOMIC ACCESS
Cost, authentication and limits
Standard includes SQL API, table streams and bulk unloading. Edition eligibility is established (not a fixed-price API allowance); complete fixed/API fees remain unresolved, with compute, storage and transfer charges assessed separately.
Check API entitlement, credential ownership and rate limits for the route you intend to use. Include review fees, customer-plan upgrades and ongoing access charges in the total.
ACT FROM OUTSIDE
External action
INSERT and UPDATE modify authorized table rows. Those DML operations depend on table privileges and transaction semantics; no arbitrary provider-service action is implied.
Validate the supported operation, acting identity and permission scope (read access does not imply write permission). Ambiguous retries and revoked credentials also affect whether an external workflow can run safely.
KEEP ACCESS USEFUL
Continuity
Standard table streams expose change action, update flags and immutable row IDs, with transactional offset advancement. Consume before STALE_AFTER and coordinate independent consumers through separate streams. SQL API documents rate/concurrency failures and exponential jittered backoff. The reviewed reference does not establish a universal numeric request quota across accounts and warehouses.
CDC, deletions and recovery
| Question | Answer / applicable route | Evidence |
|---|---|---|
| Can ongoing extraction identify updates and deleted records on the declared route? | Scoped database/change log captures inserts, updates and deletes with identity requirements disclosedSnowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. Standard table streams expose inserts, deletes and update pairs with METADATA$ROW_ID. Append-only and external-table stream semantics are outside this score. | Snowflake standard stream semantics ↗Stream offsets, metadata columns and stalenessChecked 2026-10-16 |
| How can extraction recover after missed events or an interrupted consumer? | Replay/change queries within a documented retention windowSnowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. Streams retain a transactional offset within source history retention. STALE_AFTER and table retention limit recovery; stale streams require recreation and current-table reconciliation. | Snowflake standard stream semantics ↗Stream offsets, metadata columns and stalenessChecked 2026-10-16 |
Useful ongoing access includes corrections and deletions, not only the first export. A failed request, changed filter or lost resource permission should not be interpreted as a deleted record.
LEAVE WITH YOUR DATA
Data exit and portability
COPY INTO a customer-selected cloud location unloads table/query records in portable formats. This credits table data, while full DDL, roles, policies, functions, shares and account configuration require a separate restore inventory.
Test the output against the destination’s required fields and history. Check stable identifiers, relationships, attachments and extraction time; a sample file proves only the coverage of that sample.
BUILD / INSPECT / REUSE
Business logic and customization
Customers can author native SQL and JavaScript functions subject to runtime and privilege constraints. Ownership and independent reuse remain unresolved (downloaded table records do not include every executable definition).
Custom API access, ownership of workflows and the right to export their definitions are separate questions. A custom-app capability alone does not establish that business rules can move to another system.
AGREEMENTS / API DOCS / PROGRAM REQUIREMENTS
Documented conditions
Answers below come from public provider materials. Every answer retains its source check date, scope (a partner agreement does not describe every customer route). Customer contracts and live behavior still need verification.
| Question | Answer / applicable route | Evidence |
|---|---|---|
| What structured read interface is documented? | Queryable database or replicated schemaSnowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. SQL API submits statements and returns partitioned results under the granted database/schema/warehouse context. Tables are queryable directly rather than only through fixed report APIs. | Snowflake SQL API ↗Submit SQL, data access and result retrievalChecked 2026-10-16 |
| How can customers retrieve data in bulk? | Customer-initiated native snapshot or full scoped table exportSnowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. COPY INTO a customer-selected cloud location unloads table/query records in portable formats. This credits table data, while full DDL, roles, policies, functions, shares and account configuration require a separate restore inventory. | Snowflake table data unloading ↗Unload tables/queries to named or external storageChecked 2026-10-16 |
| What queries can a customer issue outside the provider UI? | SQL or equivalent joins and aggregations against the operational systemSnowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. Customers can issue SQL joins and aggregates against authorized tables. Resource governance, masking and row policies still apply to results. | Snowflake SQL API ↗Submit SQL, data access and result retrievalChecked 2026-10-16 |
| Who decides whether a chosen third party may connect? | Customer authorization without discretionary provider approvalSnowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. Customer administrators create a custom OAuth security integration and grant roles, warehouse and object privileges. The chosen external client acts within those grants; Marketplace data listings are a separate product. | Snowflake custom OAuth clients ↗Create custom security integration and role scopeChecked 2026-10-16 |
| What extra commercial condition applies to the routes supplying the assessed read capability, relative to the lowest paid plan? | -Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. Standard includes SQL API, table streams and bulk unloading. Edition eligibility is established (not a fixed-price API allowance); complete fixed/API fees remain unresolved, with compute, storage and transfer charges assessed separately. | Snowflake edition feature matrix ↗Feature and edition matrix: Snowflake SQL API; Bulk unloading; Streams for tracking table changesChecked 2026-10-16 |
| What permission is needed for the documented downstream use? | -Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. Applicable third-party processing, AI-use and redistribution terms require a separate contractual review. | Snowflake custom OAuth clients ↗Create custom security integration and role scopeChecked 2026-10-16 |
| Which external write operations are documented? | Create and update in one business domainSnowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. INSERT and UPDATE modify authorized table rows. Those DML operations depend on table privileges and transaction semantics; no arbitrary provider-service action is implied. | Snowflake INSERT operation ↗INSERT rows and privilege requirementsChecked 2026-10-16 Snowflake UPDATE operation ↗UPDATE syntax and table privilegesChecked 2026-10-16 |
| How can customers connect an application they build or choose? | Customer applications using fixed APIs without provider selectionSnowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. Customers can build or choose applications using the documented API and the disclosed authorization route. | Snowflake custom OAuth clients ↗Create custom security integration and role scopeChecked 2026-10-16 |
| What mechanism supports repeatable extraction of changes? | Database change-data captureSnowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. Standard table streams expose change action, update flags and immutable row IDs, with transactional offset advancement. Consume before STALE_AFTER and coordinate independent consumers through separate streams. | Snowflake standard stream semantics ↗Stream offsets, metadata columns and stalenessChecked 2026-10-16 |
| How are integration limits disclosed? | Governors or limits stated without quantitiesSnowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. SQL API documents rate/concurrency failures and exponential jittered backoff. The reviewed reference does not establish a universal numeric request quota across accounts and warehouses. | Snowflake SQL API errors and limits ↗429, concurrency and jittered backoffChecked 2026-10-16 |
| Where can a usable data copy be delivered? | Feed into a customer-controlled storeSnowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. COPY INTO a customer-selected cloud location unloads table/query records in portable formats. This credits table data, while full DDL, roles, policies, functions, shares and account configuration require a separate restore inventory. | Snowflake table data unloading ↗Unload tables/queries to named or external storageChecked 2026-10-16 |
| What retrieval rights are documented at cancellation? | -Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. The reviewed extraction guide does not establish contractual retrieval rights after cancellation. | Snowflake table data unloading ↗Unload tables/queries to named or external storageChecked 2026-10-16 |
| How can customers define their own business logic? | Customer-authored native scripts or custom APIsSnowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. Customers can author native SQL and JavaScript functions subject to runtime and privilege constraints. Ownership and independent reuse remain unresolved (downloaded table records do not include every executable definition). | Snowflake function definitions ↗Create functions and supported languagesChecked 2026-10-16 |
| What rights or portability are documented for custom workflow artifacts? | -Snowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. Native workflow ownership, reusable export and independent execution rights remain unresolved. | Snowflake custom OAuth clients ↗Create custom security integration and role scopeChecked 2026-10-16 |
| What usable data or native definitions can leave before cancellation? | Portable structured records on documented routes; whole-product completeness unverifiedSnowflake / customer custom OAuth integration and granted SQL tables, standard table streams and COPY INTO customer storage; append-only/external-table streams and complete account migration are excluded. COPY INTO a customer-selected cloud location unloads table/query records in portable formats. This credits table data, while full DDL, roles, policies, functions, shares and account configuration require a separate restore inventory. | Snowflake table data unloading ↗Unload tables/queries to named or external storageChecked 2026-10-16 |
SOURCES / SCOPE / HISTORY
Sources and open questions
This review is based on the documentation below. Live account behavior and customer-specific agreements haven’t been tested.
Still to confirm
- Applicable downstream processing and redistribution terms
- Post-cancellation retrieval rights
- Native workflow artifact ownership and independent execution
- Whole-product completeness beyond the declared objects and routes
- Complete fixed and API access fees for the assessed portfolio
Documentation
Assessment checked 2026-10-16. Each answer retains its source and applicable route; the check date does not establish live account behavior.