ClickHouse SQL

Analytics & dataCredentials form

Query a ClickHouse database, such as a ClickHouse Cloud service, over its HTTPS interface: run SQL and browse databases, tables and columns.

5 actions

Action	Effect	Data handled
clickhouse_sql_run_queryRuns a read-only SQL query, such as SELECT, SHOW or DESCRIBE, and returns the rows as JSON with column types and statistics	read	Personal data
clickhouse_sql_execute_statementRuns any SQL statement, including INSERT, CREATE, ALTER and DROP, within the user's grants	write	Personal data
clickhouse_sql_list_databasesLists the databases the user can see, with their engines and comments	read	General
clickhouse_sql_list_tablesLists the tables and views of a database with their engines, row counts, sizes on disk and sorting keys	read	General
clickhouse_sql_describe_tableLists a table's columns with their types, defaults, comments and whether they are in the primary or sorting key	read	General

Sign-in

Also included

dexby.createSession({
  userId: customer.id,
  connectors: ['clickhouse_sql']
})