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
| 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 Eve.
Related
Last updated: October 20, 2018