Settings Reference for self-hosted SeekTable

You can modify default configuration of SeekTable application by specifying docker container environment variables:

seektable/seektable file: docker-compose.seektable.env

Variable Default Value Description
SeekTable_ST:BaseUrl / Web application base URL. It is used when SeekTable needs to generate full URL, and most likely you'll want to specify http://your_host_name_or_ip/.
SeekTable_ST:InstallationId (not set) Unique installation ID that activates advanced features (paid subscriptions).
SeekTable_ST:Mail:Server (not set) SMTP server host name or IP. If not set SeekTable cannot send emails. If you have "system/users admin" subscription you can configure SMTP settings from web interface (Admin → System Setup).
SeekTable_ST:Mail:Port (not set) SMTP server port. Typical values are: 25, 465, 587.
SeekTable_ST:Mail:User (not set) SMTP user name if your SMTP server requires authentication.
SeekTable_ST:Mail:Password (not set) SMTP user password if your SMTP server requires authentication.
SeekTable_ST:PivotDataService:ExternalBaseUrl http://@host:5200/ Specifies external base URL for web API exposed by 'seektable/pivotdataservice' (for access from a web browser).
SeekTable_ST:PivotDataService:InternalBaseUrl http://pivotdataservice:5000/ Specifies internal base URL for web API exposed by 'seektable/pivotdataservice' (for access from 'seektable/seektable' container).
SeekTable_ST:PivotDataService:Jwt:IssuerSigningKeyString (some unique value) JWT signing key that secures access to 'seektable/pivotdataservice' web API. This should be the same value as for PivotDataService_PivotDataService:Auth:Jwt:IssuerSigningKeyString. You might want to set your own signing key to improve the security.

seektable/pivotdataservice file: docker-compose.pivotdataservice.env

Variable Default Value Description
PivotDataService_PivotDataService:License:Owner (not set) Unique per-deployment license identifier for PivotData microservice (reporting engine used by SeekTable).
PivotDataService_PivotDataService:License:Key (not set) Unique per-deployment license key for PivotData microservice (reporting engine used by SeekTable).
PivotDataService_PivotDataService:PivotTableCellsLimit 1000000 Max number of cells in the pivot table report.
PivotDataService_PivotDataService:FlatTableRowsLimit 50000 Max number of rows in the flat table report (HTML, JSON, CSV).
PivotDataService_PivotDataService:FlatTableNonStreamExportLimit 10000 Max number of rows in PDF or Excel export of the flat table report.
PivotDataService_PivotDataService:CubeLookupDictionarySizeLimit 100000 Max dictionary size for external lookups used by Cube().Lookup() function (in expression-type dimensions).
PivotDataService_PivotDataService:Export:MaxHtmlLength (not set) Max length of the HTML input for PDF export. PDF export of large reports (>10MB HTML) is rather CPU and RAM intensive task, and this parameter allows to prevent server overload with huge exports.
PivotDataService_PivotDataService:Export:WkhtmltopdfTimeout 2 Timeout for PDF export generation in minutes. PDF export is rather CPU and RAM intensive task, and this parameter allows to prevent server overload with long-running exports.
PivotDataService_PivotDataService:Auth:Jwt:IssuerSigningKeyString (not set) JWT signing key that secures access to 'seektable/pivotdataservice' web API. This should be the same value as for SeekTable_ST:PivotDataService:Jwt:IssuerSigningKeyString.