Postgres

PostgreSQL is a powerful open-source relational database management system. It provides a rich set of data types, operators, and functions to work with structured and semi-structured data.

Postgres parameters

Required parameters are in red and Optional parameters are in blue.

---

• host, the IP address or URL of your postgres cluster

---

• port, how to write new data into existing tables
  default: 5432

---

• database, the database to write new data to
  if tables do not exist in the project.dataset location already, we'll auto-create them

---

• schema, the schema to write new data to
  default: public
  if tables do not exist in the project.dataset location already, we'll auto-create them

---

• username, your Snowflake username

---

• secret, the secret value to pass to the authentication mechanism
  this will be your password

---

• load_strategy, how to write new data into existing tables
  default: APPEND ( allowed: APPEND, TRUNCATE, UPSERT )

How do I use the Postgres syncer in commands?

cs_tools tools searchable bi-server --syncer postgres://host=192.168.1.25&username=postgres&database=cs_tools

- or -

cs_tools tools searchable bi-server --syncer postgres://definition.toml

Definition TOML Example

definition.toml

[configuration]
host = "192.168.1.25"
username = "postgres"
secret = "..."
database = "cs_tools"
load_strategy = 'truncate'