DataStation 0.1.0 Release Notes
Check out this video walking through using DataStation to find top referring domains out of this site's nginx access logs. Or, read on to learn more about the new features in this release.
Query Snowflake, Clickhouse, and Oracle databases
In addition to existig support for SQLite, PostgreSQL, MS SQL Server, and MySQL compatible databases; you can now also query Oracle, Snowflake, and Clickhouse databases.
Filter, group, sort, and limit without code using the new Visual Transform panel
Having code panels to facilitate all kinds of data transformations is awesome. But for the simple tasks, setting up the code is a hasle. The Visual Transform panel allows you to click to filter, group, sort, and limit against another panel. This makes it even faster to get basic projects set up.
Since Visual Transform panels are panels like any other, you can stack Visual Transform panels or read them from Code panels and so on.
This release now automatically generates a signing key on install. It is unique to your computer. It is used to encrypt and decrypt database and SSH passwords as needed. Under the hood DataStation uses the TweetNaCL library.
Server mode with openid-connect authentication
One of the most exciting things happening in DataStation right now is the option to run it on a server. Not only does this make it easier to share code and data with other people, it also makes it possible for DataStation to support recurring, scheduled runs and exports of projects.
DataStation 0.1.0 is released! Major new features include (no code) transformation of data, 3 new databases (@OracleDatabase, @SnowflakeDB , and @ClickHouseDB ), server mode with openid-connect auth, credential encryption, and more!— DataStation (@multiprocessio) September 21, 2021
Read more here 👇https://t.co/zVie1kdZoQ pic.twitter.com/s78JtIBznS