BI tools and Postgres client
Bauplan includes a PostgreSQL-compatible Proxy that enables Read-Only data access from major BI Tools.
Bauplan tables are in Iceberg format and the data they contain is stored in parquet files on an S3 bucket; while this facilitates handling large amounts of data, it makes challenging for traditional BI Tools to access this data or query its content.
Bauplan's Proxy bridges this gap by introducing support for PostgreSQL's SQL dialect and using its protocol to manage connections between the client (BI Proxy) and server (Bauplan).
Configuration
Once your Bauplan instance setup is complete, a dedicated hostname and port number will be made available for accessing the PostgreSQL Proxy.
When configuring the database connection, you need to define:
- Hostname + Port
- Database name: the
ref
orbranch
name from which to read data - Password: a valid Bauplan API Key
- Username: must match the username of the user to whom the API Key is linked.
- SSL: enabled
JDBC connections
For connections from Java
clients or BI Tools that use JDBC
to connect to the PostgreSQL database, you need to add the following configuration option:
preferQueryMode=simple