Select Star for Postgres

Database

Select Star brings powerful data discovery to your Postgres SQL-based cloud database in Amazon RDS. Connect and get insights into your table structure, column-level lineage, and automated documentation for downstream tables. Easily deploy with CloudFormation scripts for optimal configuration and access for Select Star.

Postgres Integration Features

Column-level Lineage

Select Star provides automated, column-level lineage for all your data for Amazon RDS. You can explore upstream and downstream dependencies to better understand the impact of making changes to your data, all the way down to your dashboards and reports.

Popularity and Usage Analytics

Popularity and usage metrics help users sift through the noise in cloud-based databases by surfacing the most current and relevant tables and columns based on query history and access.See which tables and columns are the most accessed and joined to understand how to better interpret the data.

Surface Popular Joins and Queries

Select Star shows you the most popular joins run on your cloud database environment by leveraging the metadata in the SQL logs. Connect your Amazon RDS environment to SelectStar and see full ER-Diagrams and full join histories.

Select Star for Postgres includes:

Primary Key / Foreign Key for Columns & ER Diagrams
Enriched ER Diagram for Joins
Automated PII Detection
Auto-generated Data Documentation

Browse more integrations

dbt

Select Star and dbt provide a powerful joint solution for data integration and data discovery. Users can easily share their dbt docs accompanied with Select Star’s auto-generated data context. Select star also allows you to trace data provenance and guide proper data usage, including setting owners, tags, and rich-text docs and metrics.
Learn more

Metabase

Select Star gives Metabase users the ability to quickly and reliably navigate to the most trusted and curated data sources, enabling better self-service for analytic teams. Select Star reduces the back-and-forth between analysts and engineers while increasing the data literacy of the entire organization. The platform provides full column-level data lineage from your source views down to your questions, dashboards, and cards.
Learn more

Looker

Select Star gives Looker and Looker Studio users the ability to quickly and reliably navigate to the most trusted and curated data sources, enabling better self-service for analytic teams. Select Star reduces the back-and-forth between analysts and engineers while increasing the data literacy of the entire organization. The platform provides full column-level data lineage from your source views down to your LookML/Looker views, explorers, and dashboards.
Learn more