Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Fivetran Filtering & View Support Query

Answered
Neema Joby User

I have a requirement to load filtered data from Postgres (Amazon Aurora PostgreSQL) into Snowflake using the Fivetran Postgres connector "Amazon Aurora PostgreSQL" . To apply the filter logic, I need to join multiple tables with a master table.
1. Is it possible to implement such filtering logic directly in Fivetran?

Additionally, I want to understand the connector capabilities:
2. Does the Fivetran Postgres connector support loading data from database views, or does it only replicate physical tables?

 

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Valentin Kulichenko Fivetranner

    Hi Neema,

    Thanks for sharing the request. Currently we don't support neither advanced filtering such as you described, nor views, but that sounds like an interesting use case.

    Can you please share the motivation behind the requirement? An obvious solution here can be to replicate all data and create views in the destination; is this something that could work for you, and if not - why? Also, which destination do you use?

    Regards,
    Val Kulichenko, Fivetran Product Team