# Aug 2019 Release Notes

This is a summary of new Treasure Data features and improvements introduced in the August 1st, 2019 release. If you have any product feature requests, submit them to [feedback.treasuredata.com](http://feedback.treasuredata.com/).

* [Audience Studio Users Get Custom Scripting for Workflow](/release-notes/archive/2019/aug-2019-release-notes#h1__1106125680)
* [Data Connector: Export to Microsoft OneDrive](/release-notes/archive/2019/aug-2019-release-notes#h1__526894398)
* [Data Connector: Zendesk Input Improvement - Support End Time for Incremental Loading](/release-notes/archive/2019/aug-2019-release-notes#h1__34951994)
* [Data Connector: Intercom Input Improvement - Support Incremental Loading for Users and Conversations](/release-notes/archive/2019/aug-2019-release-notes#h1_203070726)
* [Data Connector: Tableau Server Export Improvement - Support New Tableau Server Version](/release-notes/archive/2019/aug-2019-release-notes#h1__1455413271)
* [Required Migration: Salesforce Data Connector](/release-notes/archive/2019/aug-2019-release-notes#h1_1976351489)
* [TD Global ID Cookie Update for Chrome 76: Action Required for Limited Customers](/release-notes/archive/2019/aug-2019-release-notes#h1_1817119578)
* [Continued Improvement: Profiles in Audience Studio](/release-notes/archive/2019/aug-2019-release-notes#h1__1984036452)
* [Control Panel: TD Console Change](/release-notes/archive/2019/aug-2019-release-notes#h1_842205130)
* [Presto: Limit Query Execution Time](/release-notes/archive/2019/aug-2019-release-notes#h1__1711149203)
* [Hive: TD Hive 2019.1 Generally Available](/release-notes/archive/2019/aug-2019-release-notes#h1__1570834127)


# Audience Studio Users Get Custom Scripting for Workflow

Treasure Data is offering TD Workflow's [Custom Scripting](/products/customer-data-platform/data-workbench/workflows/customscript) feature to all users of Audience Studio. With Custom Scripting you can run containerized Python scripts from within Treasure Workflows to enrich your data through custom integration with different data sources, improved ETL, and use of machine learning algorithms. Check out our [Custom Scripting overview video](https://youtu.be/I0hWQaxxHeg).

Accounts that include Audience Studio will be enabled with Custom Scripting for Workflow by August 15, 2019. To learn more about the capabilities offered, contact your Customer Success representative.

# Data Connector: Export to Microsoft OneDrive

Last month we announced OneDrive Import into Treasure Data. Now you can also export your data to this cloud storage for further processing. For more information, see [Writing Job Result to OneDrive](https://docs.treasuredata.com/smart/project-integrations/onedrive-export-integration).

# Data Connector: Zendesk Input Improvement - Support End Time for Incremental Loading

Reduce the time of the first ingesting of your Zendesk data by specifying a smaller Start Time - End Time period. For more information, see [Zendesk Import Integration](http://docs.treasuredata.com/display/PD/Zendesk+Import+Integration).

# Data Connector: Intercom Input Improvement - Support Incremental Loading for Users and Conversations

Reduce the first ingestion load of Conversations and Users by specifying incremental loading. For more information, see [Intercom Import Integration](https://docs.treasuredata.com/smart/project-integrations/intercom-import-integration).

# Data Connector: Tableau Server Export Improvement - Support New Tableau Server Version

You can add a new option for latest Tableau Server version to support the new version of Tableau Server 2019.2. For using Tableau Server Export Connector, see [Tableau Server Export Integration](https://docs.treasuredata.com/smart/project-integrations/tableau-server-export-integration).

# Required Migration: Salesforce Data Connector

The deadline to migrate to the Salesforce V2 data connector has been extended. The legacy SFDC connector will be available until September 30, 2019.

The Salesforce V2 data connector is capable of asynchronous data transfer - with minimal impact on current users.

The Salesforce V2 data connector replaces the current Salesforce data connector. In TD Console, the existing SFDC connector is now labeled "Salesforce Legacy" and the V2 data connector is labeled "Salesforce."

![](/assets/image-20191022-142454.0fda00a3e3558d18eeeba2ca31d80cd6504bacee15a5bb0a96bcc22219b58ac1.fcd320e6.png)

If you are currently using the Salesforce data connector, you [must complete migration steps](https://docs.treasuredata.com/smart/project-integrations/migrating-salesforce-integrations) to ensure that your integration continues to work. You must move from the legacy Salesforce data connector to the Salesforce V2 data connector.

New users of the Salesforce data connector can start using the [Salesforce V2 data connector](https://docs.treasuredata.com/smart/project-integrations/salesforce-import-integration) immediately.

Contact your Technical Support at [support@treasuredata.com](mailto:support@treasuredata.com) to learn more.

# TD Global ID Cookie Update for Chrome 76: Action Required for Limited Customers

We've made a compatibility update to our third-party cookie in order to continue operating under new preferences introduced in Chrome 76. The update appends 2 new attributes to the TD Global ID: SameSite=none and Secure.

When Treasure Data's td_global_id is set in a Chrome browser, the following changes are in effect:

* If you are using the Treasure Data Javascript SDK v1.8.5 or earlier, td_global_id is reset when an end-user accesses your website through an unsecured request (HTTP).
* If you are using the Treasure Data Javascript SDK v 1.8.6 or later, td_global_id is set with the SameSite = None property and continues to collect data across domains.


If you are using the Treasure Data Javascript SDK v1.8.2 or earlier, you must make the following changes:

* Add “https://” to your endpoint parameter in the Javascript SDK configuration
* Upgrade your Javascript SDK to the latest version on your website
* Allow secure (HTTPS) access to your website


If you are using Treasure Data Javascript SDK v 1.8.6 or later, then no action is required.

# Continued Improvement: Profiles in Audience Studio

We've made improvements in the Profiles view that include:

* New table layout with column filtering
* New column to show campaigns associated with profile
* New charts for Page Views and Duration in Minutes


![](/assets/image-20191022-142725.bfadb98cf0178bc30d605f78bdb9c2f588571ced5aca99d8b32bd5d5b2cac9c0.fcd320e6.png)

Also, Profile avatars and social links are removed. These changes to Profiles will be implemented in your account this month.

# Control Panel: TD Console Change

The control panel groups administrator-level account maintenance features together in the Treasure Data Console. We are continuing to implement this improved navigation on all Treasure Data systems.

![](/assets/image-20191022-142734.70da325b832bb399b9b0b289a79d738bd39935f9d590b13920e8ff40ab2fe7de.fcd320e6.png)

Some task steps in the administrative area and user profile area are impacted by this user interface change. You can [review a summary of changes](/release-notes/archive/2019/summary-of-updates-to-the-td-console-2019).

# Presto: Limit Query Execution Time

Presto now allows customers to configure limits on Presto query execution time.

TD limits all Presto queries to 48 hours. You can request shorter limits for the following groups of queries:

* All Presto queries from your account
* Queries from the TD Console and ODBC/JDBC clients
* Scheduled queries and workflow queries
* Queries in any named resource pool


Also, you can set a limit for an individual query, [using a query hint](https://docs.treasuredata.com/articles/project-product-documentation/presto-query-runtime-limits-and-query-hint-override).

Because configuring query runtime limits can break your existing jobs, only technical support can configure account-level and query group-level limits for you. Contact [support@treasuredata.com](mailto:support@treasuredata.com) to request assistance with query execution limits.

# Hive: TD Hive 2019.1 Generally Available

Hive 2019.1 is fully available. TD recommends its use for all workloads going forward, including new workloads and migration of existing jobs as soon as your business requirements will allow.

TD Hive 2019.1 is a major update to Hive-on-TD functionality. It brings syntax compatibility with Apache Hive 2.3 to the Treasure Data platform and fixes all known outstanding bugs in our Hive 0.13 service for greater reliability.

Hive 2019.1 generates MapReduce jobs, that execute on the same cluster and use the same execution resources as current Hive 0.13 jobs. Performance is generally similar, and in some cases faster. Report any performance regressions to our support team.

Future TD Hive releases will build on TD Hive 2019.1 with a focus on modernization for performance enhancements.

Hive 0.13 will continue to be available for an extended period (to be determined, but at least through 2020). Updates to Hive 0.13 are expected only as necessary to address critical bugs related to security or system stability.

The version selector in the TD Console shows Hive 0.13 and Hive 2019.1 releases as follows:

![](/assets/image-20191022-142823.3300ca0015f3c2437a54c177a4925e0537ad8672c22223bf5a44db1e5fb5c8cd.fcd320e6.png)

Hive 2019.1 is initially marked as "experimental" in the UI and CLI to indicate that it is a major release for which customers may want to retest complex workloads. "Experimental" does not indicate that the software is not production-ready. When the rollout is complete, Hive 2019.1 will be labeled "stable" and become the default for new queries for all customers. If you wish to keep Hive 0.13 as your default after this date, contact your account representative or support.

Hive 2019.1 uses ANSI-compliant SQL syntax. The syntax is generally similar and most queries run unchanged, but there are new reserved words and some data types requiring casts. The documentation includes a guide to query rewriting.

If you are not ready to rewrite a query, you can explicitly select Hive 0.13 to run that query, from the command line, API, workflow or the TD Console, for as long as Hive 0.13 is available.

For more details on the roadmap for TD Hive, contact your account representative or support.