New UI Release Webinar

Come check out our new UI along with our new feature releases, including our new Dashboard overview, Data Catalog, and Scaffolds. Webinar will be held Nov 11, 2019 15:00 UTC and also recorded available upon request.

You can register here.

New UI for Keboola Connection

We started redesigning Keboola Connection in June, 2019. The first pages we changed were the pages related to authentication, followed by moving and redesigning the navigation. Today, we're happy to announce that the 3rd part of Keboola Connection redesign is ready and deployed. The content itself hasn't changed that much, but we invested a lot of time and effort into making all parts look similar to bring you better user experience.

Let's summarize the biggest changes:

  • New project dashboard - shows what's happening in the project.
  • Scaffolds - predefined blocks of configurations for specific use cases
  • Data Catalog - a new way of sharing data in the organization
  • Option to share buckets for a specific project in the organization
  • Option to share individual tables from different buckets (buckets are created automatically)

Brand New Dashboard

The new dashboard is the entry point to your project and you should find the most important information on the project there. You can learn what users are active in your project, who created a configuration recently, which jobs are currently running, etc.

Extractors, Writers and Applications are Components

We grouped all components together in the main navigation.

Each section has two parts:

  • Directory - list of all components available for the selected type (extractor, writer, and application)
  • My components - list of all components you have configured (also for the selected type)

Scaffolds (New in Keboola Connection)

Scaffolds allow you to use a group of prepared configurations for a specific use case by filling in only a few details (e.g., credentials). No additional configuration is required.

Data Catalog (New in Keboola Connection)

This is a new way you can now see the data shared from/to your project:

  • Data which you can use in your project (the section Shared with you)
  • Data you shared from your project (the section Shared from this project)

Bucket Sharing

You can share a bucket directly from the Data Catalog section:

Simple sharing - when you already have a prepared bucket you want to share.

Advanced sharing - when you want to create a new bucket with specific tables.

Also, a new type of sharing has been added. From now on, you can share a bucket to a specific project in your organization.

Storage, Transformations, Orchestrations

These sections have been slightly redesigned, but you should be able to find everything in the same place.

There are a few things we want to mention:

  • In the orchestration detail, the configured token is more visible.
  • Jobs in the orchestration detail can be filtered by their status (successful vs. failed).
  • In the transformation detail, you can find the information about the backend you used and the phase on the right side.

Jobs

The Job detail page has also been redesigned.

Again, as with Transformations or Orchestrations, the content stays the same. We only reorganized it a bit. The event detail is shown in modal. Job parameters and Mapping (information about input/output tables) are shown in modal as well. Just click "Show all" in the particular section.

User and Project menus

These menus haven't changed much either. They were moved to the same line (as was Trash).

Anyway, we're going to continue to improve Keboola Connection for you, there are definitely more things to come. We hope you like our new UI and would love to hear your feedback!

GoodData issues in US region

GoodData was experiencing issues that were preventing users of GoodData system to access the platform and the projects located on this datacenter. The issue started on 10/30 at 23:43 (UTC) and was resolved on 10/31 02:18 (UTC).

Affected jobs in Keboola Connection ended up in error Running 147946154733.dkr.ecr.us-east-1.amazonaws.com/developer-portal-v2/keboola.gooddata-writer:1.4.4 container exceeded the timeout of 18000 seconds.

Read the original GoodData service status.

Snowflake's Behavior Change Pending: Changes to String-to-Date Conversion

On Dec 1st, 2019, Snowflake will turn on strict string-to-date conversion for all Keboola Connection projects.

By introducing this change, Snowflake wants to address issues such as invalid date strings rolling over. For example, 07-32 (July 32nd) has been interpreted as August 1st. Rollover will no longer be supported for dates, times, or timestamps.

A full description of affected cases and tips on what to do are provided in the Snowflake 3.45 Release Notes.

We have a list of affected queries in the Keboola Connection projects ready and will be contacting all users that may be affected by this change. You'll have plenty of time to check everything and fix any potential issue. 

Thanks a lot for your cooperation. 


Week in Review — October 23, 2019

Feature Sunsetting

  • Oauth-v2 and the old GoodData writer were completely shut down after the deprecation period.

Updated Components

Facebook Extraction

  • Data can be extracted from each account in a separate API call. That should prevent issues with the API refusing to reply due to too much data in the response.
    image

GoodData Writer

  • There is now a warning that running a single row will reset the state for all rows. It is a feature that was unexpected for some of our customers.

Changes in Keboola Connection

  • Good Data writer is no longer shown in the Storage Console graph and the Transformation overview.

New components

KDS team created two components. Application for refreshing dashboards and datasets in PowerBI and Pardot extractor.


Service disruption of Keboola Connection in EU region

  • 12:24:13 UTC: Keboola Connection in EU region is currently experiencing service disruption. We're investingating and will keep you posted. 
  • 12:34:04 UTC: EU region is currently up, but not stable yet. 
  • 12:42:21 UTC: Keboola Connection in EU region is now up and stable. 

We're very sorry for any problems this have caused. A post mortem post will follow when we examine the logs and find the root cause. 

Dockerhub service disruption

Since October 15, 2019 5:16PM UTC the Docker Hub container registry is experiencing a complete service disruption. Some of Keboola Connection 3rd party components' images are historically hosted on Docker Hub. Such components' jobs will fail during the outage. You can subscribe to the outage mitigation progress on Docker Hub status page. 

All the new components and Keboola-maintained components are using AWS ECR as a registry, so they are not affected by the outage. 

We're very sorry about any problems this may cause. 

Transformation Overview and Table Graph errors

Since October 11, 2:00 PM UTC we are experiencing failures on the Transformation Overview page and on the Storage Table Graph page in all regions with the following error message:

Cannot load GoodData Writer: Client error response [status code] 410 [reason phrase] Gone

We're investigating the issue and will update this post with our findings.

We apologize for the inconvenience.

UPDATE October 15, 5:15 PM UTC: a new version was released and the bug was fixed.

Week in Review — October 11, 2019

New Components

  • Smartsupp extractor by Revolt BI downloads data from the live chat platform.

Updates

  • Input mapping filter can be set on an ignored column.
  • Sandboxes with duration longer than 5 days display the expiration date correctly.

Updated Components

  • Oracle and PostgreSQL extractors use optimized tables and columns loading.
  • R transformation and sandbox updated to version 3.6.1.
  • R transformation supports R Markdown.
  • GoodData Writer fixes the link to the GoodData project in the EU region.

Deprecations

Increased "Obsolete output mapping" transformation user errors

Since October 10, 3:00 am UTC we are experiencing higher rate of "Obsolete output mapping" user errors in transformation jobs. This issue is caused by a recent update of the transformation component. We'll be rolling back the release as soon as possible and keep you updated on further events.

UPDATE 8:45 am UTC: We have successfully deployed a previous version and all affected configurations should be working now. 

UPDATE October 13, 6:11 PM UTC: A new version with a fix has been released and deployed.

We apologize for the inconvenience.