July 2020

---

REST API Improvements

New Public API Endpoints

We have implemented new Destination Management API endpoints for our REST API. You can now take advantage of the following new features:

• Retrieve Destination Details

---

New connectors

Google Analytics (MCF)

Google Analytics MCF shows user interactions with various traffic sources over multiple sessions prior to converting.

Read our Google Analytics (MCF) connector documentation.

YouTube Analytics

YouTube Analytics contains a comprehensive set of YouTube Analytics data for a channel or content owner.

Read our YouTube Analytics connector documentation.

---

Schema changes

Eloqua

We now store custom timestamp fields in the TIMESTAMP WITH TIME ZONE format (for example, 2020-06-28T16:02:25.987Z).

Front

We have added a warning to your Fivetran dashboard that informs you that we will deprecate the custom_field_name and custom_field_job_title columns from the CONTACT table, on July 13, 2020.

We will sync the custom_fields from the Contacts API endpoint as custom_{field_name} columns. Update your queries with the new column names to sync data into these columns.

QuickBooks

We have added two new columns, vendor_credit_id and bill_id, to the DEPOSIT_LINE table.

Shopify

We have deprecated the featured field from the COLLECT table because the Shopify API no longer supports it. See Shopify's documentation for more information.

Stripe

We have added a new column, is_deleted, to the PERSON table.

---

Improvements

BigQuery

For partitioned tables, we ignore the partition and scan the whole table in the following scenarios:

• If you have selected a column that is not a primary key column
• If you have created an ingestion partitioned table

For example, we ignore the partition if the column is _fivetran_synced or ingestion time partitioned and scan the whole table while executing merge or delete queries to ensure data integrity.

Note: If there is no DATE or INSTANT column that is part of the primary key in your partitioned table, we scan the whole table in every sync in order to remove duplicate records.

We recommend you to select a partition column that is part of the primary key so we can scan only the corresponding partition.

Google Ad Manager

• We have upgraded our Google Ad Manager connector from version 201911 to 202005 of the Ad Manager API and handled deprecations and updates.

• Read more about the deprecations and changes in Google's Ad Manager API documentation.

  • New dimensions:

    • custom_spot_id
    • custom_spot_name
    • nielsen_device_id
    • nielsen_device_name

  • New columns:

    • ad_server_cpm_and_cpc_revenue_gross
    • ad_server_all_revenue_gross
    • ad_exchange_video_auto_play
    • ad_exchange_video_click_to_play
    • ad_exchange_video_start
    • ad_exchange_video_midpoint
    • ad_exchange_video_complete
    • ad_exchange_video_completion_rate
    • ad_exchange_video_collapse
    • ad_exchange_video_expand
    • ad_exchange_video_full_screen
    • ad_exchange_video_mute
    • ad_exchange_video_pause
    • ad_exchange_video_resume
    • ad_exchange_video_rewind
    • ad_exchange_video_skipped
    • ad_exchange_video_unmute
    • ad_exchange_video_vast2_error_count
    • ad_exchange_video_vast_error_100_count
    • ad_exchange_video_vast_error_101_count
    • ad_exchange_video_vast_error_102_count
    • ad_exchange_video_vast_error_200_count
    • ad_exchange_video_vast_error_201_count
    • ad_exchange_video_vast_error_202_count
    • ad_exchange_video_vast_error_203_count
    • ad_exchange_video_vast_error_300_count
    • ad_exchange_video_vast_error_301_count
    • ad_exchange_video_vast_error_302_count
    • ad_exchange_video_vast_error_303_count
    • ad_exchange_video_vast_error_400_count
    • ad_exchange_video_vast_error_401_count
    • ad_exchange_video_vast_error_402_count
    • ad_exchange_video_vast_error_403_count
    • ad_exchange_video_vast_error_405_count
    • ad_exchange_video_vast_error_500_count
    • ad_exchange_video_vast_error_501_count
    • ad_exchange_video_vast_error_502_count
    • ad_exchange_video_vast_error_503_count
    • ad_exchange_video_vast_error_600_count
    • ad_exchange_video_vast_error_601_count
    • ad_exchange_video_vast_error_602_count
    • ad_exchange_video_vast_error_603_count
    • ad_exchange_video_vast_error_604_count
    • ad_exchange_video_vast_error_900_count
    • ad_exchange_video_vast_error_901_count
    • ad_exchange_video_total_vast_error_count
    • ad_exchange_video_total_error_rate
    • total_video_opportunities
    • total_video_capped_opportunities
    • dp_ecpm

HubSpot

We have added a warning to your Fivetran dashboard that asks you to increase your sync frequency if your COMPANY and COMPANY_PROPERTY_HISTORY tables have huge recurring updates. Previously, if these tables had more than 9900 updates, we initiated a complete re-sync to prevent data integrity issues. The re-sync caused high MAR (monthly active rows) consumption.

You can prevent these re-syncs and avoid impact on your MAR by increasing your sync frequency.

Oracle

We have fixed a bug with very high precision NUMBER values from Oracle. Previously, we either truncated these values or did not sync them to the destination. Now, we sync these values to the destination without truncating them, but we change the column type to STRING to accomodate high precision values. Re-sync any tables where you have previously synced high precision NUMBER values to ensure data integrity.

PostgreSQL

We now support logical replication on Aurora PostgreSQL versions 10.6 or later.

Snowplow

You can now configure your Snowplow connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.

Stripe

We now capture deletes for the INVOICE, INVOICE_ITEM, and PERSON tables. Deletes from these tables are captured in the is_deleted column.

You can now select the PAYMENT_METHOD and CUSTOMER_BALANCE_TRANSACTION tables to sync from the Schema tab on your connector details page.

Webhooks

You can now configure your Webhooks connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.