Snowflake Endpoint

Snowflake endpoints connect Eve 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 Eve Uses This Endpoint For

  • Run governed SQL against Snowflake warehouses.
  • Control access to databases, schemas, and roles through Eve RBAC.
  • Expose warehouse data to Adam 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

FieldPurpose
accountSnowflake account identifier
userSnowflake username
private_keyPrivate key for key-pair authentication
oauth_tokenOAuth token alternative
warehouseOptional warehouse
databaseOptional default database
schemaOptional default schema
roleOptional 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 Eve.
Last updated: October 20, 2018
    Eden | Govern AI Access