Connect your warehouse
You will: give tripl a read-only connection to the warehouse your analytics events already land in.
You need: to be an owner or admin of the organization, and credentials for a warehouse user that can read the events table. tripl only reads: it never writes to the warehouse, and it keeps aggregated counts, not your raw events.
1. Open Data sources
Open the settings (Settings in the account menu at the bottom left, or Settings in the sidebar of All projects) and choose Data sources in the Organization group. A connection belongs to the organization, so every project in it can scan from it.

2. Add the connection
Press Add connection, give it a name your team will recognize, and pick the Type. The form asks for what that warehouse needs:
| Warehouse | What to fill in |
|---|---|
| ClickHouse | Host, port (8123), database, username, password. |
| PostgreSQL | Host, port (5432), database, username, password. Version 14 or newer. |
| BigQuery | GCP project ID, a default dataset, and a service-account JSON key pasted into the form. |
| Databricks | Server hostname, catalog, the SQL warehouse's HTTP path, and an access token (or a service principal's OAuth client ID and secret). See Databricks below. |
| Snowflake (preview) | Account identifier, database, user, the virtual warehouse, and a password or the user's private key. See Snowflake below. |
| Amazon Redshift (preview) | Endpoint host, port (5439), database, username, password. Serverless and provisioned clusters. No JSON columns. See Amazon Redshift below. |
| Greenplum | Coordinator host, port (5432), database, username, password. Greenplum 6 or 7, and the Cloudberry, Greengage and WarehousePG forks. See Greenplum below. |
| Trino (preview) | Coordinator host, port (443), catalog, user, and a password when the coordinator asks for one. Starburst too. See Trino below. |
| Amazon Athena (preview) | AWS region, Glue database, an access key ID and secret access key, and optionally a workgroup and S3 result location. See Amazon Athena below. |
Snowflake, Amazon Redshift, Trino and Amazon Athena are in preview until their live value-conformance suites pass. The Type picker lists them as <name> (preview) and says under it that support is in preview and has not yet been verified against a live warehouse; a connected source of one of these types carries a Preview chip on its card. See proven versus believed for what is and is not proven for each.
Schema and dataset names — a default schema, a schema allowlist, a BigQuery dataset allowlist — are given alone, without a catalog or project prefix (no dots). A schema allowlist takes at most 50 entries on Databricks, Snowflake, Trino and Athena.

Press Test connection before Create: it tries the credentials without saving anything.
A warehouse user that can only SELECT from the events tables is all tripl needs.
It also makes tripl's queries easy to find in the warehouse's own query log.
Databricks
tripl queries a Databricks SQL warehouse (serverless, pro or classic) in a Unity Catalog workspace. All-purpose clusters are not supported.
-
Find the connection details. In the workspace, open SQL Warehouses, pick the warehouse, and open Connection details. Copy the Server hostname (for example
dbc-a1b2c3d4-e5f6.cloud.databricks.com, withouthttps://) and the HTTP path (for example/sql/1.0/warehouses/1234abcd). -
Pick an identity. Either:
- a personal access token (Settings → Developer → Access tokens), or a token issued to a service principal. Choose Access token under Authentication and paste it into Access token or OAuth secret; or
- a service principal with OAuth machine-to-machine. Create an OAuth
secret for the service principal, choose OAuth machine-to-machine under
Authentication, put its client ID in OAuth client ID (required
with this method) and the
secret in Access token or OAuth secret. tripl exchanges them for
short-lived tokens at the workspace's
/oidc/v1/tokenendpoint.
-
Grant read-only access. The identity needs
CAN USEon the SQL warehouse and, in Unity Catalog, nothing more than:GRANT USE CATALOG ON CATALOG main TO `tripl-reader`;GRANT USE SCHEMA ON SCHEMA main.analytics TO `tripl-reader`;GRANT SELECT ON SCHEMA main.analytics TO `tripl-reader`;tripl only ever sends
SELECT(andDESCRIBE QUERY) statements; its SQL gate refusesINSERT,MERGE,COPY INTO,CREATE/ALTER/DROP,OPTIMIZE,VACUUM,SET,USEand every other statement before it reaches the warehouse. -
Fill in the form.
Field What goes in it Server hostname The workspace hostname from step 1. Catalog The Unity Catalog catalog queries and the schema browser use, for example main.HTTP path The warehouse's HTTP path from step 1. Required. Authentication Access token or OAuth machine-to-machine. Default schema Where unqualified table names resolve. Empty means default.Schema allowlist Other schemas of the catalog the schema browser may list, comma-separated. Timeout (seconds) The per-statement budget. tripl sets it as the warehouse's STATEMENT_TIMEOUTand also cancels the statement itself when it runs over.The port is always 443. Every session runs with its time zone set to UTC, so buckets and windows line up with the other warehouses.
A stopped serverless warehouse starts on the first query, which can take a few seconds; set the timeout with that in mind. Queries tripl runs are billed as warehouse time like any other.
Snowflake
tripl runs its queries on a Snowflake virtual warehouse you name, as a user you create for it.
-
Find the account identifier. In Snowsight, open the account menu → Account → View account details and copy the Account identifier (
myorg-myaccount). The account locator with its region (xy12345.eu-central-1.aws) and the fullmyorg-myaccount.snowflakecomputing.comhostname work too. -
Create a read-only role and user. Key-pair sign-in is recommended: it needs no password and is what Snowflake asks service users to use.
CREATE ROLE tripl_reader;GRANT USAGE ON WAREHOUSE compute_wh TO ROLE tripl_reader;GRANT USAGE ON DATABASE analytics TO ROLE tripl_reader;GRANT USAGE ON SCHEMA analytics.events TO ROLE tripl_reader;GRANT SELECT ON ALL TABLES IN SCHEMA analytics.events TO ROLE tripl_reader;GRANT SELECT ON FUTURE TABLES IN SCHEMA analytics.events TO ROLE tripl_reader;CREATE USER tripl_reader TYPE = SERVICE DEFAULT_ROLE = tripl_readerRSA_PUBLIC_KEY = 'MIIBIjANBgkqh...';GRANT ROLE tripl_reader TO USER tripl_reader;Make the key pair with
openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocryptandopenssl rsa -in rsa_key.p8 -pubout; the public key goes intoRSA_PUBLIC_KEYwithout its-----BEGIN/-----ENDlines. Encrypted private keys are not supported.tripl only ever sends
SELECTstatements (and asks Snowflake to describe a query without running it); its SQL gate refuses every other statement, andSYSTEM$functions, before they reach the warehouse. -
Fill in the form.
Field What goes in it Account identifier From step 1. Database The database queries and the schema browser use, for example ANALYTICS.User The user from step 2. Required. Password or private key The password, or, for key-pair sign-in, the whole PEM private key ( -----BEGIN PRIVATE KEY-----…).Warehouse The virtual warehouse queries run on. Required. An X-Small one is enough. Role The role to use. Empty means the user's default role. Authentication Password or Key pair. Default schema Where unqualified table names resolve. Empty means PUBLIC.Schema allowlist Other schemas of the database the schema browser may list, comma-separated. Timeout (seconds) The per-statement budget. tripl sets it as STATEMENT_TIMEOUT_IN_SECONDSand also cancels the statement itself when it runs over.The port is always 443. Every session runs with its time zone set to UTC, so buckets and windows line up with the other warehouses, and its queries carry the query tag
tripl.
Snowflake upper-cases unquoted names, so a column written event_name in the
base query comes back as EVENT_NAME, and that is how scans and metrics refer to
it. A suspended warehouse resumes on the first query; queries tripl runs are
billed as warehouse time like any other, so let the warehouse auto-suspend.
Amazon Redshift
tripl connects to a Redshift Serverless workgroup or a provisioned cluster over Redshift's PostgreSQL-compatible endpoint, with a database user and password.
-
Find the endpoint. For Serverless, open the workgroup and copy its Endpoint (
wg.123456789012.eu-west-1.redshift-serverless.amazonaws.com); for a cluster, the cluster's Endpoint. Put the host part in Host and the port (5439 unless you changed it) in Port. The endpoint must be reachable from tripl: publicly accessible, or in a network tripl can route to, with the security group allowing the port. -
Create a read-only user.
CREATE USER tripl_reader PASSWORD '...';GRANT USAGE ON SCHEMA analytics TO tripl_reader;GRANT SELECT ON ALL TABLES IN SCHEMA analytics TO tripl_reader;ALTER DEFAULT PRIVILEGES IN SCHEMA analytics GRANT SELECT ON TABLES TO tripl_reader; -
Fill in the form like PostgreSQL's: host, port, database (
devby default), username, password. SSL mode defaults torequirefor a remote host; Search path names the schemas unqualified table names resolve in.
Every session runs with its time zone set to UTC. Redshift has no read-only
session switch like PostgreSQL's, so the user's own privileges are what keep
tripl from writing — grant SELECT and nothing more.
A SUPER column is read as an opaque value: tripl does not list its paths,
track its properties or parse a text column as JSON on Redshift. Scans, metrics,
breakdowns and field contracts on ordinary columns work as on PostgreSQL.
Greenplum
tripl connects to the Greenplum coordinator (master) like any PostgreSQL server. Greenplum 6 and 7 are supported, and so are the forks built on them — Apache Cloudberry, Greengage and WarehousePG.
Fill in the form like PostgreSQL's: host, port (5432), database, username, password, and optionally SSL mode and Search path. A read-only role is enough:
CREATE ROLE tripl_reader LOGIN PASSWORD '...';
GRANT USAGE ON SCHEMA analytics TO tripl_reader;
GRANT SELECT ON ALL TABLES IN SCHEMA analytics TO tripl_reader;
Every session runs in UTC and read-only, exactly as on PostgreSQL. Greenplum 6
is built on PostgreSQL 9.4, so a regex field contract that uses lookbehind
((?<=...)) is not evaluated there; the contracts beside it still run.
Trino
tripl connects to a Trino coordinator, or a Starburst cluster, over
Trino's HTTP protocol. The database field names the catalog tripl reads
(hive, iceberg, delta, …); a scan's base query can still name tables in
other catalogs in full (catalog.schema.table).
- Host and port. The coordinator's host name and its HTTPS port (443 by
default; 8443 is common on self-managed clusters). A coordinator without TLS —
inside a private network, or the
trinodb/trinocontainer on port 8080 — needs Scheme set tohttp. - User (required). With password (LDAP / file) authentication, the user
and its password. A coordinator without authentication takes only a user
name, which Trino records as the query's user. A password is only ever sent
over HTTPS: a password is accepted only with the
httpsscheme, and both the form and the save refuse one withhttp. When you edit a source, Remove the stored password clears a stored password; do that before you switch an existing source tohttp. - Default schema (optional): where a bare table name resolves, and the schema the schema browser lists first. Schema allowlist (optional, up to 50): which schemas the schema browser reads; empty lists every schema in the catalog.
Grant the user read access to the catalog's tables and nothing more. With Trino's file-based access control:
{
"catalogs": [{ "user": "tripl", "catalog": "hive", "allow": "read-only" }],
"tables": [{ "user": "tripl", "privileges": ["SELECT"] }]
}
Every statement runs with its session time zone set to UTC and with
query_max_run_time set to the source's timeout, so the coordinator itself
cancels a statement that runs too long.
A json column is a JSON column to tripl: its keys are discovered and become
properties. A map column is read the same way, through its JSON cast, so each
of its keys becomes a property, as with a ClickHouse Map or a Databricks
map. A varchar column holding JSON text can be ticked under Parse as
JSON in the scan form. row and array columns are read as values (rendered
as JSON text), not expanded into properties.
Amazon Athena
tripl runs its queries through the Athena API, in a workgroup, with an IAM user's access key. Athena engine version 3 is built on Trino, and tripl writes the same SQL for both.
-
AWS region: where the Glue database lives (
eu-west-1). The form takes the region code, or the regional endpointathena.eu-west-1.amazonaws.com; nothing else is accepted. -
Database: the Glue database a bare table name resolves in.
-
Access key ID (required) and secret access key of an IAM user (or a role's long-lived key) allowed to run Athena queries. The policy below is the minimum:
{"Version": "2012-10-17","Statement": [{ "Effect": "Allow","Action": ["athena:StartQueryExecution", "athena:GetQueryExecution","athena:GetQueryResults", "athena:StopQueryExecution","athena:GetWorkGroup"],"Resource": "arn:aws:athena:eu-west-1:123456789012:workgroup/analytics" },{ "Effect": "Allow","Action": ["glue:GetDatabase", "glue:GetDatabases", "glue:GetTable","glue:GetTables", "glue:GetPartitions"],"Resource": "*" },{ "Effect": "Allow","Action": ["s3:GetObject", "s3:ListBucket", "s3:GetBucketLocation"],"Resource": ["arn:aws:s3:::my-events-bucket", "arn:aws:s3:::my-events-bucket/*"] },{ "Effect": "Allow","Action": ["s3:PutObject", "s3:GetObject", "s3:ListBucket","s3:GetBucketLocation", "s3:AbortMultipartUpload"],"Resource": ["arn:aws:s3:::my-athena-results", "arn:aws:s3:::my-athena-results/*"] }]} -
Workgroup (optional,
primaryby default) and Query result location (ans3://bucket/prefix/, required unless the workgroup sets one). Athena writes every query's result there; it is the only place the key needs to write. A dedicated workgroup lets you cap the data each query scans. -
Catalog (optional,
AwsDataCatalogby default) and a schema allowlist for the schema browser.
Every statement runs in UTC. Athena has no per-query timeout setting, so tripl
stops a statement itself (StopQueryExecution) when the source's timeout
passes. Athena bills by data scanned: give scans a lookback window, and point
them at partitioned tables where you can.
Athena reports a map column's type without its key and value types, so on
Athena a map column is read as a value (rendered as JSON text), like row and
array. json columns, and varchar columns ticked under Parse as JSON,
are expanded into properties as on Trino.
3. Check it stays healthy
The new card shows the result of the last test: Healthy in green, a warning in amber once that result is more than a week old, or the error in red with Re-test connection and Edit connection beside it. A test only proves the warehouse was reachable at that moment, so re-test after you rotate a password or change the network.
Next
A connection does nothing on its own. Next, draft your tracking plan from a scan, which reads from it.
More detail: the User Guide covers TLS modes, BigQuery cost guards, Databricks and Snowflake settings and query timeouts, and the warehouse capability matrix says what each warehouse supports and how well it is tested.