John

  • Total activity 73
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 2
  • Subscriptions 39

Activity overview

Latest activity by John
  • John created an article,

    Example of Working with Fivetran REST API via Python

    Use Case You want to get started writing programmatic scripts in Python that interact with the Fivetran REST API. A common use case for this is to automate processes around creating, updating, or r...

  • John created an article,

    Marketo: Increasing BULK API Quota

    Use Case You are setting up the Marketo connector and want to ensure you have enough Marketo API resources available to ensure a timely historical sync and successful incremental syncs. Environmen...

  • John created an article,

    How to use the dbt deployment.yml file

    Use Case   You would like to use the deployment.yml file to do advanced orchestration with your dbt git repository. Some things you might be considering: Running specific models Running separate t...

  • John created an article,

    Tracking Schema Changes

    Use Case You are looking for a detailed log of all of the schema changes that Fivetran is making in your destination. Recommendation Fivetran captures all of the changes we make to your schemas and...

  • John created an article,

    Example of Transforming JSON Data in Snowflake

    Use Case You have nested JSON data Snowflake that you need to parse out so that the data may be used for analytics. You are looking for an example of how this works to help you get started before m...

  • John created an article,

    Limiting Data Access Using Views

    Use Case You need to implement row-based filtering to limit the amount of data that users can access from certain tables in your database. Recommendation Fivetran syncs all rows from tables from so...

  • John created an article,

    Re-creating Database Views in Your Destination

    Use Case You would like to replicate data from a view in your source database in your destination.   Recommendation Fivetran does not sync views directly from the source database because of how cha...

  • John created an article,

    Google Analytics MAR Management

    Understanding how Google Analytics affects MAR Google Analytics Connector MAR Overview File connector data sources like the Google reporting connectors do not provide change-tracking data to he...

  • John created an article,

    Salesforce MAR Management

      Understanding how Salesforce affects MAR   Salesforce Connector Overview The Salesforce connector syncs data via the Bulk and REST APIs. The initial historical sync leverages the Bulk API and...

  • John created an article,

    Mailchimp MAR Management

    Understanding how the Mailchimp Support connector affects MAR   Mailchimp Connector Overview The sync strategy ensures that every table has the most recent data, and that your historical email ac...