Guide

Snowflake Endpoint

Snowflake endpoints connect Gateway to Snowflake accounts for governed warehouse access, analytics, and workflow automation.

Endpoint Kind

Use snowflake as the endpoint kind when creating this endpoint through the API or dashboard.

What Gateway Uses This Endpoint For

Run governed SQL against Snowflake warehouses.
Control access to databases, schemas, and roles through Gateway RBAC.
Expose warehouse data to AI Orchestration and approved tools.
Coordinate Snowflake with Postgres, Databricks, and object storage endpoints.

Basic Endpoint Shape

json

{
  "endpoint": "snowflake-analytics",
  "kind": "snowflake",
  "config": {
    "read_conn": {
      "account": "xy12345.us-east-1",
      "user": "EVE_SERVICE",
      "warehouse": "COMPUTE_WH",
      "database": "ANALYTICS",
      "schema": "PUBLIC",
      "role": "ANALYST"
    }
  }
}

Create it with the endpoint API:

bash

curl -sS -X POST "$EDEN/endpoints" \
  -H "$AUTH_HEADER" \
  -H "Content-Type: application/json" \
  -d '{
  "endpoint": "snowflake-analytics",
  "kind": "snowflake",
  "config": {
    "read_conn": {
      "account": "xy12345.us-east-1",
      "user": "EVE_SERVICE",
      "warehouse": "COMPUTE_WH",
      "database": "ANALYTICS",
      "schema": "PUBLIC",
      "role": "ANALYST"
    }
  }
}'

Configuration Fields

Field	Purpose
`account`	Snowflake account identifier
`user`	Snowflake username
`private_key`	Private key for key-pair authentication
`oauth_token`	OAuth token alternative
`warehouse`	Optional warehouse
`database`	Optional default database
`schema`	Optional default schema
`role`	Optional role

Operating Notes

Prefer key-pair or OAuth authentication over shared passwords.
Set warehouse, database, schema, and role defaults explicitly for predictable query behavior.
Watch warehouse cost and concurrency when many users access Snowflake through Gateway.