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 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.