Skip to main content

Overview

At the Initialize, we can know a file name config.properties that has all setting. The settings about the data source is also in the file. You can find a field wren.datasource.type that means what data source is used in the Wren Engine. We support many data source types like DuckDB, PostgreSQL, and BigQuery.

Quick to use

Setting up a data source connector is easy, you can follow the steps below to set up a connector.

  1. Create a folder name etc then into the folder.

    mdkir etc
    cd etc

  2. Create a file name config.properties in the etc. We use wren.datasource.type to get the data source is what. If you want to connect to PostgreSQL, you can set it with postgres.

    wren.datasource.type=postgres
    postgres.jdbc.url=jdbc:postgresql://host:port/database
    postgres.user=username
    postgres.password=password

Then, you can query the data in the Wren Engine.