Alex Thornbury

  • Total activity 13
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 1
  • Subscriptions 6

Activity overview

Latest activity by Alex Thornbury
  • Alex Thornbury created a post,

    Improve Managing Fivetran related metadata

    Which connector?: At a minimum this pertains to fivetran_metadata and Salesforce related connections Additional details: These two connections (and possibly others) create multiple metadata related...

  • Alex Thornbury commented,

    This is especially true for the tables that Fivetran adds for replication from Salesforce. Tables like fivetran_api_call and fivetran_query get large. Deletion is a hassle while partition managemen...

  • Alex Thornbury created a post,

    Destination Improvement: Bulk Change Sync Mode

    Answered

    Currently, the sync mode is set in an individual by table by schema fashion. This is fine when there is a small number of tables or schemas, but becomes frustrating when the number of schemas and t...

  • Alex Thornbury created a post,

    Destination Improvement: Set a default sync mode for new tables

    Planned

    The soft delete option is the default and will be applied to all tables added to a destination initially or in the future. We are defaulting to History Mode in our destinations and it is a pain to ...

  • Alex Thornbury created a post,

    Other: built-in fivetran system and log table management

    Fivetran- Your product creates a number of system and logging tables that grow large but there is no retention management of these tables in your product. As far as I can tell, this currently falls...

  • Alex Thornbury created a post,

    Destination Improvement: fivetran_meta automatic data retention

    Answered

    The fivetran_meta schema contains at least one logging table that can grow VERY large. There does not appear to be a current way to manage this size from within Fivetran via a retention policy. It ...