Discovering PostgreSQL source table or materialized view with subset of columns

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Airbyte not listing PostgreSQL view with subset of columns when configuring a new connection


Question

Hello. Can Airbyte discover a PostgreSQL source table or materialized view with only a subset of columns https://www.postgresql.org/docs/current/sql-grant.html|granted for SELECT? I don’t see the view listed on the “Select streams” page when configuring a new connection.


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["airbyte", "postgresql-connector", "select-streams", "materialized-view", "subset-of-columns"]
2

USAGE is granted on the public schema. And I can see other tables with full SELECT privileges