The new Crunchy Bridge for Analytics offering allows users to query data lakes with state-of-the-art analytic performance using PostgreSQL. Users can set up tables directly pointing to Parquet, CSV, or JSON files in object storage without specifying columns, and run fast analytical queries. Data import and export capabilities are also included, making it easy to move data between data lakes and PostgreSQL tables. Crunchy Bridge for Analytics combines the power of PostgreSQL with extensions to enhance querying capabilities. Performance benefits are seen when using Parquet due to its columnar format. Overall, Bridge for Analytics offers a versatile and powerful solution for interacting with data lakes using PostgreSQL.
https://www.crunchydata.com/blog/crunchy-bridge-for-analytics-your-data-lake-in-postgresql