You must enter the following credentials when configuring this source:
| Key | Description | Sample value |
|---|---|---|
database |
The name of the database you want to export data to. | demo |
host |
The host name of your PostgreSQL database. | db.bit.io |
password |
Password for the PostgreSQL user to access the database. | abc123... |
port |
Port of the running database (typically 5432). | 5432 |
schema |
Schema of the data you want to export to. | public |
table |
Name of the table that will be created to store data from your source. | dim_users_v1 |
username |
Name of the user that will access the database (must have permissions to read and write to specified schema). | guest |
| Key | Description | Sample value |
|---|---|---|
skip_schema_creation |
If true, Mage won't run CREATE SCHEMA command. For more information, see this issue |
true |
lower_case |
If true, Mage will set all columns name as lower case. Default is true |
true |