sources

Add Snowflake connection

Create a new Snowflake data warehouse connection. Supports both password and key-pair authentication.

POST /api/v1/sources/add/snowflake/

Headers

Authorizationrequired

any - API key authentication using Bearer scheme

Request Body

typerequired

string - Connection type identifier. Must be `SNOWFLAKE`

account_name

string - Display name for the connection

accountrequired

string - Snowflake account identifier (e.g., xy12345.us-east-1)

userrequired

string - Snowflake username

password

string - Password for authentication (optional - use either password or public_key)

public_key

string - Public key for key-pair authentication (optional - use either password or public_key)

warehouse

string - Snowflake warehouse to use (optional)

Response

id

integer - The ID of the created connection

public_key_sql

string - SQL command to add public key to Snowflake (only for key-pair auth)

cURL

curl --request POST \
  --url https://api.camelai.com/api/v1/sources/add/snowflake/ \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{
  "type": "SNOWFLAKE",
  "account_name": "Snowflake",
  "account": "production",
  "user": "db_user",
  "password": "secure-password",
  "public_key": "secure-password",
  "warehouse": "<string>"
}'

200

{
  "id": 123,
  "public_key_sql": "key_123"
}