October 2019link
New connectorslink
Zendesk Sunshine Connectorlink
Zendesk Sunshine is an open and flexible CRM platform. It lets you seamlessly connect and understand all your customer data. It is fast, powerful and gives you the freedom to build whatever you want.
Read our Zendesk Sunshine connector documentation.
Schema changeslink
Greenhouselink
We have added a new field, name
, to the OFFICE
table.
Leverlink
We have added a new field, to_stage_index
, to the CANDIDATE_STAGE_HISTORY
table.
Pinterest Adslink
We have made a number of schema changes to support Pinterest Ads API version 3.
The new
objective_type
field has replaced theoptimization_goal
field in theCAMPAIGN_HISTORY
table. We will support theoptimization_goal
field for the next three months, and then it will be deprecated.The deprecated
bid_type
field has been reformatted and renamed tobillable_event
in theAD_GROUP_HISTORY
table.We have added the following fields to the tables below:
billable_event
to theAD_GROUP_HISTORY
tablecreative_type
to thePIN_PROMOTION_HISTORY
table
Pinterest has deprecated the following fields, so we have removed them from the tables below:
bid_type
from theAD_GROUP_HISTORY
tablecampaign_type
,bid_type
,is_one_tap
, andupgrade_status
from theCAMPAIGN_HISTORY
tableupgrade_status
from thePIN_PROMOTION_HISTORY
table
Salesforce Marketing Cloudlink
We have started syncing email data from the Content Builder API into the EMAIL
table. This lets us fetch data that is not available through the SOAP API.
This change adds the new column asset_type_id
to the EMAIL
table.
Shopifylink
We have added the following columns to the TRANSACTION
table to support currency exchange rate adjustments:
processed_at
currency_exchange_id
currency_exchange_adjustment
currency_exchange_original_amount
currency_exchange_final_amount
currency_exchange_currency
We have added a new table, PRODUCT_IMAGE
, which contains the following fields:
id
: A unique numeric identifier for the product image. (primary key)product_id
: The ID of the product associated with the image. (foreign key, references thePRODUCT
table)position
: The order of the product image in the list. The first product image is at position 1 and is the "main" image for the product.width
: Width dimension of the image which is determined on upload.height
: Height dimension of the image which is determined on upload.created_at
: The date and time when the product image was created.updated_at
: The date and time when the product image was last modified.src
: Specifies the location of the product image.alt
: Alternative source if the main image does not exist.variant_ids
: IDs of the variations of the product associated with the image.
You can read more about product images in Shopify's API documentation.
Stripelink
For version 2 of the Stripe connector, we have added a new column, invoice_id
, to the CHARGE
table to support mapping between the CHARGE
and INVOICE
tables.
Improvementslink
Apple App Storelink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time
Apple Search Adslink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time
Campaign Managerlink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time
Criteolink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time
Facebook Ad Insightslink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months (default)
- 12 months
- 24 months
- All time
Google Ad Managerlink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time
Google Adslink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time
Google Analyticslink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time
Google Search Consolelink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time
Kustomerlink
You can now create Kustomer connectors through the Fivetran API.
Leverlink
We now sync the REQUISITION
table during every data sync. Previously, we synced this table every 24 hours.
In the REQUISITION
table, we have converted the target_hire_date
column's data type from TIMESTAMP
to INSTANT
.
LinkedIn Ad Analyticslink
Fivetran now requests the following read-only permissions to support changes that LinkedIn recently made to their API permissions:
r_ads
: Retrieve member’s advertising accountsr_ads_reporting
: Retrieve reporting for member’s advertising accounts
Note: You must re-authorize your LinkedIn Ad Analytics connectors in the Fivetran setup form to grant us these permissions. Re-authorizing with the new permissions will ensure your Linked In Ad Analytics connector continues to sync.
Microsoft Advertisinglink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months (default)
- 12 months
- 24 months
- All time
MySQLlink
We are now rolling out support for BLOB, TINYBLOB, MEDIUMBLOB, LONGBLOB, and YEAR data types in version 4 of our MySQL connector.
We are now rolling out the ability to sync MySQL DATETIME columns to the destination as TIMESTAMP_NTZ columns for version 4 of our MySQL connector.
We have a fixed a bug that caused zeroed DATE and DATETIME values to sync incorrectly. MySQL allows
0000-00-00
and0000-00-00 00:00:00
as values for DATE and DATETIME primary key columns respectively. Previously, we converted these values to1970-01-01
and1970-01-01 00:00:00
. Therefore, zeroed times and the real values of1970-01-01
and1970-01-01 00:00:00
were mapped to the same value in the destination. Fivetran now converts these values as follows:- DATE: from
1970-01-01
to-999999999-01-01
- DATETIME: from
1970-01-01 00:00:00
to-999999999-01-01 00:00:00
- DATE: from
Oraclelink
The two-hour limit on importing tables has been removed resulting in fewer syncs appearing as "Rescheduled" in the dashboard.
Syncs that fail due to falling behind processing archive logs during the incremental update phase will appear as "Rescheduled" in the dashboard and are attempted again immediately. Previously, there was no indication of a problem.
These changes will be rolled out over the next month.
Outbrainlink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time
Pinterest Adslink
We have upgraded the Pinterest Ads API to version 3, since versions 1 and 2 of the API have been deprecated. For more details, see Pinterest Ads' API documentation.
PostgreSQLlink
- We can now sync single- and multidimensional JSON, JSONB, and HSTORE arrays.
- We now require that the postgres database configuration parameter 'wal_sender_timeout' is set to 0 or greater than 10 minutes. The value is validated during the setup test.
Snapchat Adslink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- Three months
- Six months
- 12 months (default)
- 24 months
- All time
Snowflakelink
Snowflake does not allow the following ANSI reserved keywords to be column names when they are capitalized:
CONSTRAINT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
LOCALTIME
LOCALTIMESTAMP
To ensure a valid column name, Fivetran converts the keyword to lowercase and encases it in double quotes (for example, LOCALTIME
becomes "localtime"
). When you query these columns, be sure to use the converted column name.
Taboolalink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time
Yahoo Geminilink
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time