Connections
SQL Data Sources
Mprove connects to SQL databases that are supported by Malloy:
- PostgreSQL
- MySQL
- Presto / Trino
- SnowFlake
- BigQuery
- DataBricks
- MotherDuck (DuckDb)
API Data Sources
The API connection is universal and can work with different API providers. Logic for creating a request body and logic for transforming a response data must be defined in the Store Model.
Store connection types:
- API
- Google API
For API query, Mprove does a single request to the data source.
For Google API query, Mprove does 2 requests:
- Auth request to get credentials
- Data request (query)
Internal Host and Internal Port Connection Parameters
Some connection types have optional internal host and internal port parameters.
If you provide connection credentials to an external sandbox provider, it will use the host and port that are not internal, because the sandbox is not on a local network with the mprove server.
If the mprove server has an internal host and internal port specified for a connection, it will use them instead of the host/port. This removes an extra network hop from the mprove server to the DWH.