PostgreSQL
Currently, Stream Pipelines for PostgreSQL supports these platforms:
- Amazon Aurora PostgreSQL
- Azure Databases for PostgreSQL
Stream Pipelines is compatible with PostgreSQL version 10 and later versions.
To establish a connection, ensure that the database endpoint can be accessed publicly through the JDBC connection. The database must be authenticated with a user and password.
We recommend that you create a database user for Stream Pipelines and grant the user appropriate read and write permissions.
Stream Pipelines does not support creating tables automatically in the database. You must create tables in PostgreSQL. When you create tables, ensure that you use PostgreSQL and that the column names and data types match the properties of the corresponding objects. To guarantee successful data delivery with Pipelines, we recommend that you refer to the provided table that maps data types of object properties, as defined in Data Catalog, to their corresponding PostgreSQL data types. Ensure that the case sensitivity of the object property names and the corresponding table column names is identical.
This table shows the object properties data types, as defined in Data Catalog, and their corresponding PostgreSQL data types:
Data Catalog data type | PostgreSQL data type | alias |
---|---|
Boolean | Boolean | bool |
Date:
|
Date |
Datetime:
|
Character varying | varchar |
Datetime:
|
Timestamp without time zone | timestamp or timestamp with time zone or timestamptz |
Datetime:
|
BigInt or Int |
Integer:
|
Smallint | int2 |
Integer:
|
Integer | int4 |
Integer:
|
Bigint | int8 |
Number | Numeric | numeric |
String | Character varying | varchar |
Time:
|
Time without time zone | time |
Time:
|
Varchar |
Object | Character varying | varchar |
{“desc”: {“en_US”:”Blue Car”, “de_DE”: “Blaues Auto”, “es_ES”: “Coche
Azul”},
, then only the first value, ”Blue
Car”
, is stored in the table column.