# Jan 2018 Release Note

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

* [Input: Facebook Page Insights](/release-notes/archive/2018/jan-2018-release-note#h2_252352680)
* [Input: Instagram User and Media Insights](/release-notes/archive/2018/jan-2018-release-note#h2_356364503)
* [Input: Twitter Audience Insights](/release-notes/archive/2018/jan-2018-release-note#h2_1812124432)
* [Input: Salesforce Marketing Cloud (ExactTarget) Data Extensions](/release-notes/archive/2018/jan-2018-release-note#h2_1360612141)
* [Input: SFTP/FTP and Amazon S3 Zip Decoder Support](/release-notes/archive/2018/jan-2018-release-note#h2__1557101581)
* [Input: PostgreSQL Array Type Support](/release-notes/archive/2018/jan-2018-release-note#h2_1903331958)
* [Hive: Approximate Aggregation UDFs](/release-notes/archive/2018/jan-2018-release-note#h2__484223480)
* [Console: Usability Improvements](/release-notes/archive/2018/jan-2018-release-note#h2_1289033938)
* [Workflow UI (Private Access): Create Workflow Template](/release-notes/archive/2018/jan-2018-release-note#h2__828218304)
* [Output: S3 supports Server-Side Encryption](/release-notes/archive/2018/jan-2018-release-note#h2__399043663)
* [Output: ElasticCloud supports Null Values](/release-notes/archive/2018/jan-2018-release-note#h2_1070390046)


## Input: Facebook Page Insights

The Data Connector for Facebook Page Insights enables users to import page and post metrics, such as demographics, video-views, and impressions.

Facebook Page Insights Import Integration

## Input: Instagram User and Media Insights

The Data Connector for Instagram User and Media Insights enables users to import user and media metrics such as impressions and engagement.

Instagram User and Media Insights Import Integration

## Input: Twitter Audience Insights

The Data Connector for Twitter Audience Insights enables users to import demographic metrics for Twitter Audiences.

Twitter Audience Insights Import Integration (Deprecated)

## Input: Salesforce Marketing Cloud (ExactTarget) Data Extensions

The Data Connector for Salesforce Marketing Cloud (ExactTarget) now enables users to import Data Extension data.

Salesforce Marketing Cloud ExactTarget Export Integration

## Input: SFTP/FTP and Amazon S3 Zip Decoder Support

The Data Connector for SFTP/FTP and Amazon S3 now supports a decoder for single zip files. When you configure your SFTP/FTP or Amazon S3 connector from the CLI (td toolbelt), add two lines in the configuration file:


```yaml
    decoders:
      - type: single_file_in_zip
```

[Contact us](https://www.treasuredata.com/contact_us/) for details.

## Input: PostgreSQL Array Type Support

The Data Connector for PostgreSQL now enables users to import array type data as string type.

PostgreSQL Import Integration

## Hive: Approximate Aggregation UDFs

Two approximate aggregation UDFs (`approx_count_distinct()` and `approx_distinct()`) were added via Hivemall library update. See Treasure Machine Learning for details.

* approx *count* distinct()
* approx_distinct()


## Console: Usability Improvements

We've completed the following Usability Improvements for Console this month:

* Deep Linking has been added, to allow linking to configuration and saved connection modal steps. These types of links are helpful when collaborating with others on a configuration.
* For the new Workflow UI (Private Access), we now provide links to the Query Job for failed tasks. Previously, we provided this link only for successful tasks.
* We updated the project revision history list for workflow. The terminology used and the list view are easier to understand.


## Workflow UI (Private Access): Create Workflow Template

We've updated the create experience for enhanced usability, providing templates and a visual picture of the workflow you're about to create, a drop down list of current projects that you can add the workflow to, along with an improved navigational flow.

![](/assets/jan-2018-release-note-01.b878edff845095b682443a77cefa32ed102b7bc1395102d213e82728b34ea3ca.803b7489.png)

Create a Workflow in Console

![](/assets/jan-2018-release-note-02.244a0d916541191cb56c8203252668e996b23105dbb3f4bc2871ce729d5dde63.803b7489.png)

Edit an Existing Workflow in Console

We'll be adding additional workflow templates to the set provided in January.

## Output: S3 supports Server-Side Encryption

S3 output now supports AES-256 Server-Side Encryption.

Amazon S3 Export Integration

## Output: ElasticCloud supports Null Values

ElasticCloud now supports exporting null values.

Elastic Cloud Export Integration