Connecting to ClickHouse

What you can do

List databases and tables and run supported read-only SQL queries to answer questions about analytics data.

Connect

Choose ClickHouse and supply the host, port, user and password in the secure form, with an optional default database. The connection requires HTTPS. Start at Integrations. Connecting an app covers the shared steps.

Access and limits

Writes are not exposed. Use a read-only database user as well, and grant only the databases needed. A default database does not itself restrict access to other databases that user can query.

See How connections work for personal, team and document-sharing choices.

Try a request

@OpenTag Count active accounts by week for the last two months and show the SQL you used.

Check the source and result before using them elsewhere. If the account stops working, follow Fixing a broken connection.