📄️ Amazon RDS PostgreSQL connection
Overview
📄️ Amazon RDS PostgreSQL as a target
Unlike Analytics Data Warehouses, PostgreSQL is primarily used as an operational database. It structures data in a row-based format, similar to other operational RDBMSs, as opposed to a column-based format. This row-based structure offers specific advantages and disadvantages, particularly when processing large volumes of data. However, it provides optimized performance for key columns, indexes, and JOIN operations.
📄️ Amazon RDS PostgreSQL columns mapping
Supported data types
