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

How to configure PostgreSql 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 "PostgreSql, Amazon Redshift" option.
  4. Fill all required fields:
    Cube Name
    short title that describes this data source
    Connection String
    Valid connection string for NpgSql driver. Example:
    Host=hostName;Port=5432;Database=db;User ID=user;Password=password;
    Select Query
    determines tabular data (columns) that can be used as dimensions or measures in a pivot table reports. In simplest case this might be something like SELECT * FROM some_table; you can specify more complex query if needed (JOINs, WHERE).
  5. Keep Infer dimensions and measures by columns checked (until you want to define dimensions and measures by yourself) and 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
"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").
Unique dimension identifier. For Type=Field this is column name specifier (possibly with table alias prefix).
User-friendly dimension title displayed on UI (optional).
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
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).