Snowflake issues

Some Snowflake transformations fail with such error: odbc_exec(): SQL error: [unixODBC]SQL execution internal error: Processing aborted due to error 300010:1087106694; incident 5370475., SQL state XX000 in SQLExecDirect. It seems that there is some issue in the Snowflake warehouse. We will keep you informed.

Update 19:30 UTC: The problem should be fixed in the US region. (Last occurrence in our infrastructure is from 12:08 UTC.) It seems there was an issue specific to some CREATE TABLE AS SELECT and INSERTs that use window functions.

Security enhancements to GoodData projects access

Direct single sign-on access to GoodData projects from Keboola Connection has been improved and its security enhanced. Due to it, access has been disabled to all existing users and you have to enable it again in Writer's configuration. 

Also, you are no longer able to switch between projects, once you are in GoodData. You have to return back to Connection and access the other project from there. Although it can be a little less comfortable, it brings improved security and we believe it is a better solution for you.

New version of AdWords Extractor

We have just released a new version of AdWords Extractor. It works with AdWords API v201809 (see the Release notes).

The previous version of the extractor is deprecated and you can use our migration tool which will migrate your AWQL queries. As usual, you have to reauthorize the extractor and give it access to your AdWords data again. The previous version uses AdWords API v201802 which will be switched off on 30 January 2019.

Week in Review -- February 19, 2018

New components

Bug fixes and smaller improvements

  • Bug fix in Currency extractor - exchange rates for Danish Krone (DKK) and Icelandic Krona (ISK) were not updated for some time because of a bug in its configuration.
  • Snowflake extractor now offers views in the tables list too.

New version of AdWords Extractor

We have just released a new version of AdWords Extractor. It works with AdWords API v201710 (see the Release notes) and you no longer need your own developer token to use it.

The previous version of the extractor is deprecated and you can use our migration tool which will migrate your AWQL queries. However, you have to reauthorize the extractor and give it access to your AdWords data again. The previous version uses AdWords API v201705 which will be switched off on 28 March 2018.

Week in Review -- November 21, 2017

New Features

  • There is a new extractor for what3words service (https://what3words.com/)

Improvements

  • Configuration of MySQL Extractor allows parameter database to be optional
  • Loading data to Storage Workspace allows renaming of columns
  • Configuration errors from DarkSky Extractor are properly marked as user errors
  • Unified incremental load settings for all database writers

Week in Review -- September 5, 2017

We've spent a lot of time on squashing bugs in GoodData Writer, Google Drive Writer, Docker Sandbox and Gelf logger and on several new features which are not yet ready. Besides, there are two nice things we can tell you about.

UI of the KBC is being revised for a few weeks now and you can see the first results in the unification of buttons for creating new resources. 

Database Writers now allow triggering `nullable` values for all columns at once.

New version of AdWords Extractor

We released a new AdWords Extractor updated to use the latest version of AdWords API v201705. The previous Extractor is marked as deprecated. It uses API v201607 which will be switched off by June 27. You are encouraged to migrate soon during the June. 

Configuration migration is automatic but you need to rewrite fetching of deprecated values yourself according to the migration guide (https://developers.google.com/adwords/api/docs/guides/migration/v201705). AdWords developer token must be entered to the configuration again because it will be encrypted for this app only. You also have to reauthorize OAuth access to your data.

Week in Review -- May 30, 2017

New version of Dropbox extractor

Our third-party partner Radek Tomášek published the new version of Dropbox extractor which uses Dropbox API v2. Old extractor uses API v1 which will be deprecated soon so you are recommended to migrate to the new extractor soon. See http://status.keboola.com/dropbox-extractor-v2

Pipedrive extractor

An extractor to Pipedrive: Sales CRM & Pipeline Management Software was published to all users.

Transformations

Detail of transformation job was slightly improved for better intelligibility.

Connection

We fixed email validation of invitation form which prevented you from inviting users with emails with e.g. geographic top-level domains like '.london'.

Intermittent data load errors in GoodData Writer

Some data loads may end with similar error message: {"upload_status.json":"SLI CSV \"dataset.outcmaincalled_numbers.csv\" does not contain header line"}. It is caused by an error in GoodData WebDav and GoodData support is working on a fix. The occurence is rather sporadic and appears in one or two client projects a day and usually vanishes after few hours.