Skip to main content

Overview

At the Initialize, we can know a file name config.properties that has all settings. 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 start

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 enter into the folder.

    mdkir etc
    cd etc
  2. Create a file name config.properties in the etc. We rely on wren.datasource.type attribute to get what kind of data source you use. If you want to connect to PostgreSQL, you can set it as 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.