Data Ingestion
PostgreSQL
Data Ingestion
PostgreSQL
PostgreSQL is a powerful, open source object-relational database system.
Overview
PostgreSQL is an advanced open-source relational database that supports both SQL (relational) and JSON (non-relational) querying. Datazone provides native integration with PostgreSQL databases, allowing you to easily connect and extract data from your PostgreSQL instances.
Connection Parameters
| Parameter | Required | Description |
|---|---|---|
| Name | Yes | A unique identifier for your PostgreSQL source |
| Host | Yes | The hostname or IP address of your PostgreSQL server |
| Port | Yes | The port number on which PostgreSQL is running (default: 5432) |
| Database Name | Yes | The name of the database you want to connect to |
| Schema Name | No | Optional schema name (if different from the default ‘public’ schema) |
| User | Yes | Username with appropriate permissions to access the database |
| Password | Yes | Password for the specified user |
Required Permissions
The PostgreSQL user account needs the following permissions:
SELECT- For reading data from tablesUSAGE- For accessing schemasCONNECT- For connecting to the database
Limitations
Be aware of the following limitations when working with PostgreSQL sources:
- Supported PostgreSQL versions: 9.6 and above
- Some PostgreSQL-specific types will be converted to standard types
Next Steps
After configuring your PostgreSQL source:
- Create extracts to specify which tables to ingest
- Configure scheduling for recurring extracts
- Integrate the source into your data pipelines
For more information about working with extracts and pipelines, refer to their respective documentation sections.