Managed secret providers
ClickHouse
Connect ClickHouse to Alter Vault for secure API access
Overview
Section titled “Overview”Use ClickHouse credentials to make authenticated API calls through Alter Vault without exposing API keys in code.
| Property | Value |
|---|---|
| Provider ID | clickhouse |
| Category | Database |
| Credential Type | Base64 Credentials |
Step 1: Get Credentials
Section titled “Step 1: Get Credentials”Log in to ClickHouse Cloud
Log in to the ClickHouse Cloud Console and open the service.
Note the connection details
Open Connect and note the HTTPS endpoint, username, and password (or create a dedicated database user).
Encode the credentials
Base64-encode the credentials: echo -n 'username:password' | base64 and paste the result into the credential field.
Step 2: Add to Alter Vault
Section titled “Step 2: Add to Alter Vault”Open the Developer Portal
Go to portal.alterauth.com and navigate to the application.
Add ClickHouse
Go to Managed Secrets > Add Provider > ClickHouse.
Enter credentials
Paste your Base64 Credentials into the credential field.
Save
Click Save. You’ll receive a grant_id to use with the SDK.
Using in Code
Section titled “Using in Code”response = await alter_app.request( HttpMethod.POST, "https://YOUR-SERVICE.clickhouse.cloud:8443", grant_id="YOUR_GRANT_ID", query_params={"query": "SELECT event, count() FROM events GROUP BY event LIMIT 5"},)- The HTTPS interface accepts SQL in the request body and listens on port 8443 on ClickHouse Cloud.