Brett Arnott, VP Marketing
Mar 22, 20221 min
Updated: Mar 24, 2022
The PostgreSQL connector allows data to be cataloged, queried, transformed and to create tables in PostgreSQL. This can be used to quickly and easily join data between different systems like PostgreSQL and Hive, or between different PostgreSQL instances.
The PostgreSQL connector is available for all Promethium editions, including Free (coming soon), Professional and Enterprise.
If you don't have a Promethium account, get your free account now
Jump to the how to video.
Connecting to PostgreSQL is fast and easy. Simply click Data Sources from the menu, then click + New Data Source. Select PostgreSQL and enter the information for your PostgreSQL.
PostgreSQL connection details can be case sensitive. Ensure that data is entered with the correct case for your PostgreSQL.
Click the Connect button then select schemas. After successful connection and schema selection Promethium will automatically crawl and catalog data in your PostgreSQL, then make the data easily searchable and usable.
Click Data Explorer from the menu and begin exploring the data in your PostgreSQL Data Cloud.
No. Your data stays in PostgreSQL and isn't moved to Promethium.
Datasets can be published as a view, as a table in PostgreSQL or as a dbt model.
Yes. The PostgreSQL connector is designed for all-sized Datasets.