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
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.
Last updated
Was this helpful?