On March 23, 2018 we released a new version of Google Sheets Writer to remove workaround which resized sheet's grid. Unfortunately this version caused a significant performance degradation for tables with larger number of rows.
We decided to revert this version to bring back original performance.
We are working on proper fix and it'll be released soon.
There was an update to the orchestrator this week that had an unfortunate side-effect. If you updated your orchestrations' notifications it would delete the orchestration's tasks.
Thankfully, the orchestrations are versioned, so if this happened to you, we will restore the tasks from the last version.
If you have any concerns about this please contact us at support@keboola.com.
For what it's worth, updating notifications will no longer delete orchestration tasks, please accept our humble apologies if you were affected.
We continue with removing so called "static state" from components. Few weeks ago we removed static state from Transformations, and there was a time for additional components. JSON configurations are also editable straight away. This includes configurations from templates (e.g. Youtube Extractor) and configurations for Custom Science Apps (e.g. Custom Science Python).
We are deprecating direct import from URL into Storage. Please use the new Http Extractor instead which gives you much more flexibility.
Since Friday April 8, 2018, the SQLdep functionality in Transformations was returning an error. This was fixed today.
We're sorry for this inconvenience.
3:45pm CEST: We're investigating the issue.
3:55pm CEST: Not only starting, existing sandboxes do not seem to respond.
4:10pm CEST: We're shutting down existing sandbox instances and spinning up new ones. This will take a couple of minutes before the sandboxes will be available again. All existing sandboxes will be unfortunately deleted.
4:20pm CEST: Sandboxes are starting again. All previous sandboxes are deleted. We're sorry for this inconvenience.
Another one joins the band.
In our effort to replace Restbox with modern components, the next logical step was the HTTP(s) extractor. It allows you to download a single CSV file or a compressed, publicly available file and import them into a single table in Storage. In case you have more public files to download from a single domain, the UI allows you to reuse the same base URL for more files.
The UI of the new extractor supports many features out of the box, but the extractor is not limited by its UI: it's another component that supports processors. So your CSV file can be invalid, in a weird charset, pivoted or mutilated in some other way, and there's tooling to get that fixed.
The list of available processors will be kept and updated in the Developer Portal list of components. A full description of the extractor is available in our documentation.
We are happy to announce the immediate availability of Guide Mode. In Guide mode, the Keboola Connection user interface will switch to an interactive tutorial which will guide you through the basics of using Keboola Connection.
Guide mode is designed for new users and works best on empty projects. Therefore, when you invite a new person to Keboola Connection, they will receive a special link in their invitation email:
The link leads to the try.keboola.com page. By following the link, they will receive a 15day demo project with the Guide mode activated.
The Guide Mode is the very first step in creating a replacement the old Academy. We are gradually going to fill it with more advanced content, but in the mean time try it out and let us know what you think.
We have just released a new version of AdWords Extractor. It works with AdWords API v201802 (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. However, you have to reauthorize the extractor and give it access to your AdWords data again. The previous version uses AdWords API v201710 which will be switched off on 11 July 2018.
We’re happy to welcome the Asana Extractor to our family. It can extract your projects and tasks from the Asana application which is designed to help teams track their work. This component was developed by Leo Chan.
We're likewise delighted to announce a new writer to Thoughtspot that is now available for public use.
Thoughtspot is a "search and AI-driven analytics platform".
The project API Tokens section now shows when a token was refreshed:
Artificial limits were removed from CSV file import. Previously the upload had to go through in 10 minutes. Now it's left to the decission of your web browser. Please note that it still holds that large files should be uploaded through the API.
Further improvements to Output mapping. The destination bucket is now prefilled from the transformation name.
The MSSQL extractor was updated to correctly handle databases with case-sensitive collations.
The Email Attachments extractor now supports incremental and addresses in angle brackets, ex: `Joe <email@example.com>`
Developer portal vendors can now approve requests to join via the request email.