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.

Network errors in GoodData Writer

GoodData Writer experiences occurring network errors during download of csv files from storage and that cause failures of some load data jobs. We are working on fix. Thanks for patience. 

Update: It seems that the network errors ceased. In addition we published a fix which should properly deal with such errors in the future. We apologize for any inconvenience.

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.