Vendors / Warehouses and lakehouses

Databricks

Databricks exposes governed SQL and retained Delta table changes. Change data feed begins after enablement and is not a permanent audit archive; consumers must manage table keys, retained versions and checkpoints.

Overall controlB7.8*/10
Assessment checked 2026-10-16Public documentation · No live account test

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Databricks vs Snowflake: compare API access and data control ↗

OVERALL CONTROL / 0.6-customer-control

Grades and scoring

Overall B / 7.8*/10, with 13 of 16 applicable scoring inputs verified. Missing evidence discounts the supported score (unknown answers remain unknown).

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Data access and planned exit carry the most weight. Known commercial barriers cap access; an unpublished price applies a bounded discount. Post-cancellation retrieval is a separate disclosure. Open each dimension to inspect its inputs and sources.

B7.6*/10

Data access

25% of the overall score before applicability adjustment.

Scored answers and evidence

Read interface 10.0/10

Queryable database or replicated schema

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

The Statement Execution API runs SQL and retrieves chunked results. Warehouse access and data privileges constrain table discovery and queries; result-size and expiry limits require complete retrieval.

Databricks SQL statement execution ↗
Execute statements and fetch result chunks · Checked 2026-10-16

Answer-to-score anchors ↗

Bulk delivery 8.8/10

Batched or iterable API requests

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

The Statement Execution API runs SQL and retrieves chunked results. Warehouse access and data privileges constrain table discovery and queries; result-size and expiry limits require complete retrieval.

Databricks SQL statement execution ↗
Execute statements and fetch result chunks · Checked 2026-10-16

Answer-to-score anchors ↗

Query expressiveness 10.0/10

SQL or equivalent joins and aggregations against the operational system

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

SQL permits joins, filtering and aggregation against granted warehouse tables. These queries operate on the customer’s current governed data rather than a vendor-provided universal schema.

Databricks SQL statement execution ↗
Execute statements and fetch result chunks · Checked 2026-10-16

Answer-to-score anchors ↗

Access cost barrier -

-

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Premium is the current entry paid AWS tier after Standard ended on October 1, 2025. SQL requires Premium or above (plus SQL entitlement and warehouse grants); this requirement alone is not a plan uplift. Complete fixed/API fees and compute/storage pricing remain unresolved.

Databricks SQL plan requirements ↗
Requirements: Premium plan or above; Databricks SQL is available only on these plans · Checked 2026-10-16

Databricks AWS platform tiers and billing ↗
Upgrade your Databricks plan: Standard tier end of life October 1, 2025; current Premium and Enterprise tiers; new accounts default to Premium · Checked 2026-10-16

Answer-to-score anchors ↗
A8.8*/10

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

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Customer administrators create a service principal, bind OAuth scopes and grant warehouse and catalog/table permissions. A token alone does not confer access to data or compute.

Databricks service principal OAuth ↗
Service principal, OAuth scopes and warehouse grants · Checked 2026-10-16

Answer-to-score anchors ↗

Downstream permission -

-

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Applicable third-party processing, AI-use and redistribution terms require a separate contractual review.

Databricks service principal OAuth ↗
Service principal, OAuth scopes and warehouse grants · Checked 2026-10-16

Answer-to-score anchors ↗
C5.5/10

External action

15% of the overall score before applicability adjustment.

Scored answers and evidence

Write interface 2.5/10

Named operations in a limited domain

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

INSERT adds rows to authorized tables, including explicitly declared overwrite/replace modes. This narrow finding does not assume every foreign table or SQL engine supports updates.

Databricks INSERT operation ↗
INSERT syntax, supported tables and schema validation · Checked 2026-10-16

Answer-to-score anchors ↗

Custom application path 10.0/10

Customer applications using fixed APIs without provider selection

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Customers can build or choose applications using the documented API and the disclosed authorization route.

Databricks service principal OAuth ↗
Service principal, OAuth scopes and warehouse grants · Checked 2026-10-16

Answer-to-score anchors ↗
A10.0/10

Continuity

15% of the overall score before applicability adjustment.

Scored answers and evidence

Refresh mechanism 10.0/10

Database change-data capture

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Enabled Delta change data feed exposes insert, update pre/post-images and deletes with commit metadata. Persist a stable business key and commit version; retention and VACUUM can remove the needed history.

Databricks Delta change data feed ↗
Change schema, retained versions, checkpoint recovery and initial snapshot · Checked 2026-10-16

Answer-to-score anchors ↗

Limit visibility 10.0/10

Published numeric quotas and recovery instructions

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Databricks publishes service-specific workspace quotas and Statement Execution result-size/timeout controls. Respect 429 and retry guidance; compute concurrency is a separate warehouse constraint.

Databricks resource limits ↗
Workspace/service quotas and SQL limits · Checked 2026-10-16

Answer-to-score anchors ↗

CDC and deletion capture 10.0/10

Scoped database/change log captures inserts, updates and deletes with identity requirements disclosed

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Enabled Delta CDF supplies change type and commit version for table rows. Stable customer-defined row identity is required for correct downstream application; unconfigured tables do not inherit this score.

Databricks Delta change data feed ↗
Change schema, retained versions, checkpoint recovery and initial snapshot · Checked 2026-10-16

Answer-to-score anchors ↗

Replay and gap recovery 10.0/10

Consumer checkpoint with documented retention limits and resnapshot recovery

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Structured Streaming supports checkpoints and a retained starting version; expired versions cannot be replayed. A new stream can emit current rows as inserts, so a full rebuild is the fallback after history loss.

Databricks Delta change data feed ↗
Change schema, retained versions, checkpoint recovery and initial snapshot · Checked 2026-10-16

Answer-to-score anchors ↗
B7.5/10

Data exit

20% of the overall score before applicability adjustment.

Scored answers and evidence

Export custody 7.5/10

Customer-held structured files or API records

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Chunked SQL results provide portable table records, and administrators can permit UI result downloads. Complete catalog grants, notebooks, jobs, credentials and executable workspace reconstruction remain unverified.

Databricks SQL result retrieval ↗
Chunked result retrieval and external result links · Checked 2026-10-16

Answer-to-score anchors ↗

Post-cancellation access Disclosure

-

Disclosure only; does not reduce planned-exit credit.

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

The reviewed extraction guide does not establish contractual retrieval rights after cancellation.

Databricks SQL result retrieval ↗
Chunked result retrieval and external result links · Checked 2026-10-16

Answer-to-score anchors ↗

Planned migration fidelity 7.5/10

Portable structured records on documented routes; whole-product completeness unverified

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Chunked SQL results provide portable table records, and administrators can permit UI result downloads. Complete catalog grants, notebooks, jobs, credentials and executable workspace reconstruction remain unverified.

Databricks SQL result retrieval ↗
Chunked result retrieval and external result links · Checked 2026-10-16

Answer-to-score anchors ↗
B6.2*/10

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

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Customers can define SQL functions in the Databricks runtime. Engine/version constraints apply, and independent execution and reusable ownership remain unresolved (a SQL definition alone is not an exit license).

Databricks SQL function definitions ↗
Create SQL functions and runtime constraints · Checked 2026-10-16

Answer-to-score anchors ↗

Rights to custom logic -

-

Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Native workflow ownership, reusable export and independent execution rights remain unresolved.

Databricks service principal OAuth ↗
Service principal, OAuth scopes and warehouse grants · Checked 2026-10-16

Answer-to-score anchors ↗

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 service principal, bind OAuth scopes and grant warehouse and catalog/table permissions. A token alone does not confer access to data or compute.

Third-party eligibilityCustomer authorization without discretionary provider approvalSource & scope ↗
Access cost barrier-Source & scope ↗
Downstream permission-Source & scope ↗

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

The Statement Execution API runs SQL and retrieves chunked results. Warehouse access and data privileges constrain table discovery and queries; result-size and expiry limits require complete retrieval. SQL permits joins, filtering and aggregation against granted warehouse tables. These queries operate on the customer’s current governed data rather than a vendor-provided universal schema.

Access routeAuthenticationCredential ownerProvider approvalAccess requirementLast checked
Customer-authorized applicationOAuth client credentialsCustomerNocustomer authorization2026-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

Premium is the current entry paid AWS tier after Standard ended on October 1, 2025. SQL requires Premium or above (plus SQL entitlement and warehouse grants); this requirement alone is not a plan uplift. Complete fixed/API fees and compute/storage pricing remain unresolved.

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 adds rows to authorized tables, including explicitly declared overwrite/replace modes. This narrow finding does not assume every foreign table or SQL engine supports updates.

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

Enabled Delta change data feed exposes insert, update pre/post-images and deletes with commit metadata. Persist a stable business key and commit version; retention and VACUUM can remove the needed history. Databricks publishes service-specific workspace quotas and Statement Execution result-size/timeout controls. Respect 429 and retry guidance; compute concurrency is a separate warehouse constraint.

CDC, deletions and recovery

QuestionAnswer / applicable routeEvidence
Can ongoing extraction identify updates and deleted records on the declared route?Scoped database/change log captures inserts, updates and deletes with identity requirements disclosedDatabricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Enabled Delta CDF supplies change type and commit version for table rows. Stable customer-defined row identity is required for correct downstream application; unconfigured tables do not inherit this score.

Databricks Delta change data feed ↗Change schema, retained versions, checkpoint recovery and initial snapshotChecked 2026-10-16
How can extraction recover after missed events or an interrupted consumer?Consumer checkpoint with documented retention limits and resnapshot recoveryDatabricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Structured Streaming supports checkpoints and a retained starting version; expired versions cannot be replayed. A new stream can emit current rows as inserts, so a full rebuild is the fallback after history loss.

Databricks Delta change data feed ↗Change schema, retained versions, checkpoint recovery and initial snapshotChecked 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

Chunked SQL results provide portable table records, and administrators can permit UI result downloads. Complete catalog grants, notebooks, jobs, credentials and executable workspace reconstruction remain unverified.

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 define SQL functions in the Databricks runtime. Engine/version constraints apply, and independent execution and reusable ownership remain unresolved (a SQL definition alone is not an exit license).

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.

QuestionAnswer / applicable routeEvidence
What structured read interface is documented?Queryable database or replicated schemaDatabricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

The Statement Execution API runs SQL and retrieves chunked results. Warehouse access and data privileges constrain table discovery and queries; result-size and expiry limits require complete retrieval.

Databricks SQL statement execution ↗Execute statements and fetch result chunksChecked 2026-10-16
How can customers retrieve data in bulk?Batched or iterable API requestsDatabricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

The Statement Execution API runs SQL and retrieves chunked results. Warehouse access and data privileges constrain table discovery and queries; result-size and expiry limits require complete retrieval.

Databricks SQL statement execution ↗Execute statements and fetch result chunksChecked 2026-10-16
What queries can a customer issue outside the provider UI?SQL or equivalent joins and aggregations against the operational systemDatabricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

SQL permits joins, filtering and aggregation against granted warehouse tables. These queries operate on the customer’s current governed data rather than a vendor-provided universal schema.

Databricks SQL statement execution ↗Execute statements and fetch result chunksChecked 2026-10-16
Who decides whether a chosen third party may connect?Customer authorization without discretionary provider approvalDatabricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Customer administrators create a service principal, bind OAuth scopes and grant warehouse and catalog/table permissions. A token alone does not confer access to data or compute.

Databricks service principal OAuth ↗Service principal, OAuth scopes and warehouse grantsChecked 2026-10-16
What extra commercial condition applies to the routes supplying the assessed read capability, relative to the lowest paid plan?-Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Premium is the current entry paid AWS tier after Standard ended on October 1, 2025. SQL requires Premium or above (plus SQL entitlement and warehouse grants); this requirement alone is not a plan uplift. Complete fixed/API fees and compute/storage pricing remain unresolved.

Databricks SQL plan requirements ↗Requirements: Premium plan or above; Databricks SQL is available only on these plansChecked 2026-10-16
Databricks AWS platform tiers and billing ↗Upgrade your Databricks plan: Standard tier end of life October 1, 2025; current Premium and Enterprise tiers; new accounts default to PremiumChecked 2026-10-16
What permission is needed for the documented downstream use?-Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Applicable third-party processing, AI-use and redistribution terms require a separate contractual review.

Databricks service principal OAuth ↗Service principal, OAuth scopes and warehouse grantsChecked 2026-10-16
Which external write operations are documented?Named operations in a limited domainDatabricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

INSERT adds rows to authorized tables, including explicitly declared overwrite/replace modes. This narrow finding does not assume every foreign table or SQL engine supports updates.

Databricks INSERT operation ↗INSERT syntax, supported tables and schema validationChecked 2026-10-16
How can customers connect an application they build or choose?Customer applications using fixed APIs without provider selectionDatabricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Customers can build or choose applications using the documented API and the disclosed authorization route.

Databricks service principal OAuth ↗Service principal, OAuth scopes and warehouse grantsChecked 2026-10-16
What mechanism supports repeatable extraction of changes?Database change-data captureDatabricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Enabled Delta change data feed exposes insert, update pre/post-images and deletes with commit metadata. Persist a stable business key and commit version; retention and VACUUM can remove the needed history.

Databricks Delta change data feed ↗Change schema, retained versions, checkpoint recovery and initial snapshotChecked 2026-10-16
How are integration limits disclosed?Published numeric quotas and recovery instructionsDatabricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Databricks publishes service-specific workspace quotas and Statement Execution result-size/timeout controls. Respect 429 and retry guidance; compute concurrency is a separate warehouse constraint.

Databricks resource limits ↗Workspace/service quotas and SQL limitsChecked 2026-10-16
Where can a usable data copy be delivered?Customer-held structured files or API recordsDatabricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Chunked SQL results provide portable table records, and administrators can permit UI result downloads. Complete catalog grants, notebooks, jobs, credentials and executable workspace reconstruction remain unverified.

Databricks SQL result retrieval ↗Chunked result retrieval and external result linksChecked 2026-10-16
What retrieval rights are documented at cancellation?-Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

The reviewed extraction guide does not establish contractual retrieval rights after cancellation.

Databricks SQL result retrieval ↗Chunked result retrieval and external result linksChecked 2026-10-16
How can customers define their own business logic?Customer-authored native scripts or custom APIsDatabricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Customers can define SQL functions in the Databricks runtime. Engine/version constraints apply, and independent execution and reusable ownership remain unresolved (a SQL definition alone is not an exit license).

Databricks SQL function definitions ↗Create SQL functions and runtime constraintsChecked 2026-10-16
What rights or portability are documented for custom workflow artifacts?-Databricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Native workflow ownership, reusable export and independent execution rights remain unresolved.

Databricks service principal OAuth ↗Service principal, OAuth scopes and warehouse grantsChecked 2026-10-16
What usable data or native definitions can leave before cancellation?Portable structured records on documented routes; whole-product completeness unverifiedDatabricks on AWS / customer service principal, SQL warehouse table queries/DML, result download and enabled Delta change data feed; only tables with an explicit identity/mutation contract qualify for CDC.

Chunked SQL results provide portable table records, and administrators can permit UI result downloads. Complete catalog grants, notebooks, jobs, credentials and executable workspace reconstruction remain unverified.

Databricks SQL result retrieval ↗Chunked result retrieval and external result linksChecked 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.