# Changelog

## Coming Soon - Summer Release

####

#### New Integrations

**Snowflake** - Import Snowflake database tables into Phiona, and export datasets to Snowflake database tables.

**Redshift** - Import Redshift database tables into Phiona, and export datasets to Redshift database tables.

**Custom REST API** - Connect to Basic Auth, Access Key, and OAuth2.0 REST APIs and import data.

####

#### New Transforms

#### JSON Unwrapper Transform

You can now expand JSON arrays and objects to columns or rows.

#### Pivot/Unpivot Transform

You can now pivot and unpivot your data columns and rows

#### New API Endpoints

Added the new API endpoints to query and transform your data from an external source. See [API Documentation](https://docs.phiona.com/the-basics/api-documentation) for additional details.

#### Miscellaneous Fixes and Improvements

**Currency Column Type Support** - now Phiona can recognize dollar, pound, euro and yen/yuan symbols

**Search and Group by Range** - you can now create categories from ranges of numerical values in your datasets

**Improved JSON Handling** - better support for JSON files, especially with multiple nested tables

**New Existing Blueprint Support** - support included for currency, JSON unwrapper, pivot/unpivot and search and group by range functions

## Wednesday, January 6th, 2021

####

#### New Integrations

**MongoDB** - Import MongoDB database clusters and tables into Phiona, and export datasets to MongoDB database tables.

####

#### New Transforms

#### Share and Reuse Existing Blueprints as Transform

You can now share your blueprints to be utilized as a transform in new datasets. These shared blueprints can be used in a few ways.

The first way is using the same exact steps for datasets that update on a regular basis. For example, if you previously created a blueprint to transform your January sales data, you can reuse those same blueprint steps for your February data, saving you a ton of time.

The second way is to create micro blueprints as a set of transforms that you use fairly often on a number of different datasets, similar to an Excel macro.

The third way is to share these blueprints with others in your organization- if others want to perform similar analyses on a dataset that you've also worked with in Phiona, you can share your blueprint and the other person can use it as a template to begin their analysis.

####

#### Miscellaneous Fixes and Improvements

Updated overall performance for file uploads

Improved behavior when setting options for transforms - fewer error messages, blank tables, etc.