Skip to main content
Connect ClickHouse Cloud to OPTIMAZE with a control-plane API key. OPTIMAZE imports daily usage costs for the organisation, and splits longer periods into 31-day windows automatically.
ClickHouse is in beta. The tile on the Integrations page is marked Beta.

​
Prerequisites

  • Permission to create API keys in your ClickHouse Cloud organisation.

​
Set up the ClickHouse integration

1

Create an API key in ClickHouse Cloud

  1. In ClickHouse Cloud, open Organization, then API keys.
  2. Create a key that can view the organisation. The read-only Developer role is enough.
  3. Copy the organisation ID, key ID and key secret.
2

Enter the details in OPTIMAZE

Under Data, select Integrations. On the ClickHouse tile, select Connect, then fill in the form.
3

Connect

Select Connect.

​
What happens next

When you select Connect, OPTIMAZE runs a connection check before it starts importing. Each part of the check shows as passed, failed or not checked, and a later part is not checked when an earlier one fails. Once the check passes, the integration appears under Connected on the Integrations page. OPTIMAZE imports the previous six months of history on the first sync, and each later sync re-reads the last three days to pick up late changes.

​
Troubleshooting

  • Authentication fails: the key ID or secret is wrong, or the key has been deleted.
  • Access fails: the key cannot view the organisation, or belongs to a different organisation.
  • Data available fails: ClickHouse has no cost data for the period yet. Wait for ClickHouse to report usage, then connect again.