Hey, wondering the best way to block access to spe...
# replication-ask-ai
l
Hey, wondering the best way to block access to specific columns for security purposes. We have a Postgres database and we don't want to give Airbyte access to some specific columns, to avoid the risk of human error of accidentally syncing these to our Snowflake warehouse. Does anyone have some advice on the best way to do this? We tried creating a view, but this means the XMIN column is missing and Airbyte cannot use that method to replicate. We're looking at revoking column level access to specific columns for the role in Postgres, but I believe this will throw an error as Airbyte tries to select * on the table schema. Any other suggestions for how to do this?
k
New message text here