# 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](/the-basics/api-documentation.md) 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.phiona.com/changelog.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.