This documentation page assumes that you already have a SeekTable account.

How to configure Yandex ClickHouse data source

  1. Click on "Connect to Database" item at "Cubes" view, or just open this link (ensure that you're logged in).
  2. Select "SQL-compatible database" in Data Source Type selector: SQL database connection settings
  3. Switch Database Connector to "Yandex ClickHouse" option.
  4. Fill all required fields:
    Cube Name
    short title that describes this data source
    Connection String
    Valid connection string for ClickHouse driver. Example:
    Compress=True;Compressor=lz4;Host=hostName;Port=9000;Database=default;User=default;Password=
    Note: Driver uses CH binary protocol like "clickhouse-client".
    Select Query
    determines tabular data (columns) that can be used as dimension or measure in a pivot table reports. In simplest case this might be something like SELECT * FROM some_table.
  5. Infer dimensions and measures by columns option: keep it checked to determine dimensions and measures by first N documents - in this case you don't need to define Dimensions and Measures by yourself. You can edit configuration later and remove excessive elements, or customize automatically determined ones.
  6. Click on "Save" button.

If everything is fine you should see a new cube dashboard with the list of available dimensions. In case of connection error you'll see an orange box with the error message.

Dimensions setup

Dimension name should refer to the column returned by specified Select Query:

Cube dimensions form
Type
"Field": dimension value is a table column or result of SQL expression (provided as first "Parameter").
"Expression": custom formula that uses another dimensions as arguments (specified in "Parameters").
Name
Unique dimension identifier. For Type=Field this is column name specifier (possibly with table alias prefix).
Label
User-friendly dimension title displayed on UI (optional).
Format
Custom format string (.NET String.Format) for dimension values (optional). Examples:
  • for number values: ${0:0.##} → $10.25
  • for date values: {0:yyyy-MM-dd} → 2017-05-25
Parameters
For Type=Field: you can specify custom SQL expression for this dimension.
For Type=Expression: you can specify custom formula (1-st parameter) and dimension names for the arguments (2-nd, 3-rd etc parameter).