If you use any custom solution built upon our Writer, you need to migrate it to the new POST login, i.e. take property encryptedClaims from our resource and call this GoodData API call: https://help.gooddata.com/display/doc/API+Reference#/reference/authentication/sso-pgp-login which will login your user. SSO links to GoodData in our Connection UI are already migrated to the new method.
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.
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.
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.
- Leo Chan developed another component allowing users to download details and reviews of places from Google Maps. See more information in our Developer Portal.
- Revolt BI developed an extractor downloading data from Fingera - access control and attendance management system.
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.
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.
- There is a new extractor for what3words service (https://what3words.com/)
- 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
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.
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.
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
An extractor to Pipedrive: Sales CRM & Pipeline Management Software was published to all users.
Detail of transformation job was slightly improved for better intelligibility.
We fixed email validation of invitation form which prevented you from inviting users with emails with e.g. geographic top-level domains like '.london'.