SQLdep.com integration for Redshift transformations

All Redshift transformations can now be easily integrated into SQLdep. A single click uploads your current transformation (and all dependecies) to SQLdep and shows you a big picture of what’s happening in the transformation. You can look at it from the table, column or query perspective. 

Note: this is only available for Redshift transformations. For more information about our Redshift backend please contact support@keboola.com.

User Filters configuration change in GoodData Writer

We have deployed improvements to Mandatory User Filters which need a change in writers configuration. Your configurations will be migrated automatically but here is a list of changes:

Table filters contained columns name, attribute, element, operator, uri and now contains only name, attribute, operator, value (element has been renamed to value and uri moved tofilters_projects table)

Table filters_projects contained columns filterName, pid and now contains uri, filter, pid

Table filters_users contained columns filterName, userEmail and now contains id, filter, email (id is generated by Writer and is unique for each combination of filter name and email)

RestBox CSV plugins

 The RestBox tool has been updated with two new plugins you can find on the File modifications tab. 

Filename will add a column to your StorageAPI table, which contains the source filename/URL

DownloadTime adds a column with the date/time when the file has been processed by RestBox.

    Share your sandbox

    On the new sandbox credentials page you can now share your sandbox database to another user in the same project. The user, you’re sharing your sandbox with, needs to have active sandbox credentials, and your sandbox database will show up in the databases list in his MySQL client.

    GoodData Writer UI - small update

    Reset Project - you can discard existing GoodData project and automatically recreate new one. Existing Writer’s configuration will be reused. 

    Turn Maintenance On - if you turn it on, all communication with GoodData API will be paused. 

    Reset Table - by pressing this button, GoodData dataset will be removed and your table configuration will be ready to create fresh dataset.