cap-snowflake — CAP database adapter for Snowflake

[sleibach]

We've built an open-source CAP database adapter for Snowflake: sleibach/cap-snowflake

What it does

• Connects SAP CAP applications to Snowflake as the persistence layer
• Uses the Snowflake SQL API (HTTPS/REST with JWT key-pair auth) — no ODBC or native drivers needed
• Full cds deploy support: generates tables, views, and draft artifacts from CDS models (using cds.compile.to.sql() adapted for Snowflake dialect)
• OData V4 support including $select, $filter, $expand, $orderby, $search, $count, pagination
• Draft support (@odata.draft.enabled) working with Fiori Elements — create, edit, activate, discard
• Localized entities, temporal data, managed aspects (createdAt, modifiedAt, etc.)
• Streaming for large result sets via LIMIT/OFFSET paging
• Also supports snowflake-sdk (native TCP driver) as an alternative transport

How it works

Install and configure as a CDS plugin:

{
  "cds": {
    "requires": {
      "db": {
        "kind": "snowflake",
        "credentials": {
          "account": "your-account",
          "database": "MY_DB",
          "schema": "PUBLIC",
          "auth": "jwt",
          "jwt": { "privateKey": "..." }
        }
      }
    }
  }
}

Then cds deploy and cds watch work as expected.

Current status

• CI with real Snowflake E2E tests on every push (Node 20 + 22)
• Tested with Fiori Elements (list report + object page + full draft lifecycle)
• Covers: basic CRUD, all OData query options, $expand (to-one/to-many), draft create/edit/activate/discard, localization, temporal queries, $search
• Used internally at adesso SE

Looking for feedback

We'd appreciate feedback from the CAP community, especially around:

• Patterns where the adapter diverges from the HANA adapter
• Missing CQL constructs or OData edge cases
• Interest in contributing or co-maintaining

Repository: https://github.com/sleibach/cap-snowflake