Databases and warehouses
Where: Sources in the sidebar → New source → Connect database → pick the database under Connector.
Follow Connect a database, application or cloud source and pick the database under Connector. Most databases share one form:
| Field | Required | Notes |
|---|---|---|
| Host | Yes | A hostname or IP address, for example db.example.com. |
| Port | Yes | Filled in with the engine’s default; change it if yours differs. |
| Database | Yes | The database to read. |
| Schema | Depends on the engine | See the table below. |
| User | Yes | Use an account that can read the tables you want to load. |
| Password | Yes |
Teramot only reads from your database. A read-only user with access to the tables you want is enough: Prepare your sources has the script to create one on each engine.
| Connector | Default port | Schema | Connection methods |
|---|---|---|---|
| PostgreSQL | 5432 | Optional | Direct, IP Whitelisting, SSH Tunnel, Private Connection |
| MySQL | 3306 | — | Direct, IP Whitelisting, SSH Tunnel, Private Connection |
| MariaDB | 3306 | — | Direct, IP Whitelisting |
| SQL Server | 1433 | Required | Direct, IP Whitelisting, SSH Tunnel, Private Connection |
| Azure SQL | 1433 | Required | Direct, IP Whitelisting |
| Amazon Redshift | 5439 | Optional | Direct, IP Whitelisting |
| ClickHouse | 8123 | Optional | Direct, IP Whitelisting |
| Oracle DB | 1521 | Optional | Direct, IP Whitelisting, SSH Tunnel, Private Connection |
| SAP Hana | 30015 | Optional | Direct, IP Whitelisting |
| Databricks | — | Optional | Direct, IP Whitelisting |
| Snowflake | — | Optional | Direct, IP Whitelisting |
| Teradata | 1025 | Optional | Direct, IP Whitelisting |
The connection methods are explained in How Teramot reaches a database. MongoDB is covered in Applications and cloud sources.
Oracle DB
- Service name replaces Database and is required.
- Oracle SID is optional.
- Table owner replaces Schema. It is optional; enter it in upper case.
Snowflake
- Account identifier replaces Host: your account identifier, not a full URL.
- There is no port.
- Warehouse is required.
- Role is optional; without it, the user’s default role is used.
Databricks
- Server hostname: without
https://. - HTTP path: required, starts with
/. - Catalog replaces Database.
- Access token replaces User and Password: a Databricks personal access token.