Skip to content
(opens in a new tab)Quickstart
← All release notesNewanfra Cloud

Connect your data warehouse

Admins connect the organization's databases in Settings → Data sources, and anfra Cloud tests each connection before saving it.

anfra Cloud connects to PostgreSQL, Snowflake, BigQuery, Amazon Redshift, Databricks, MySQL, SQL Server, ClickHouse, Amazon Athena, Presto and Trino, Oracle, and MotherDuck.

The Add data source panel: a Name field set to warehouse, a grid of data source types from PostgreSQL to MotherDuck, then Host, Port, Database, User and Password fields, Advanced options, and Test connection and Add data source buttons

Give a data source the name your project's models refer to, fill in the connection, and save. anfra Cloud tests the connection first and shows what failed on the field it belongs to. Advanced options, such as timeouts and SSL, are tucked away until you need them.

Saved secrets stay secret

Once saved, a password or key is never shown again, only that one is saved. When you edit a data source, leave a secret blank to keep it. If you change where the data source connects, such as its host, anfra Cloud asks for its secrets again, so they can't be sent to a new server.

Only admins manage data sources and can query them in SQL directly. Everyone else queries through the semantic layer.