Connector Improvement: Including tables with different sync frequencies in the same connector
Use case: migrating hundreds of schemas from legacy databases into Snowflake via Fivetran. Tables are organized within schemas by either originating source or by function the end users perform with the data contained in these tables. But tables in the same database, the same schemas are having different refresh schedules. Some are refreshed every 5 minutes, some - every week, some every hour, some every day.
Fivetran requires to create separate schemas for each sync frequency. In this use case it will increase a number of schemas fivefold or more.
There is a need to add a refresh frequency on a table level within the same schema. Values don't need to be continues, there can be a drop down with discrete options in the Schema tab next to the table name.
Please sign in to leave a comment.
Comments
0 comments