Keboola Status

New Components

TimeDoctor extractor 

• Time Doctor is a time tracking software which allows employees to track time per project and task. Team managers are then able to monitor their computer activity and evaluate effectiveness.
• The Time Doctor extractor for Keboola Connection allows you to download Time Doctor data about users and their activity. 
• This component was developed by KDS Team.

Snapchat Marketing extractor

• The Snapchat marketing extractor allows users to download data about marketing campaigns and statistics via the Snapchat Marketing API.
• It allows to download statistics for campaigns, adsquads, and ads with all supported metrics from Snapchat with either hourly or daily granularity.
  
• This component was developed by KDS Team.

Updated Components

• All database extractors now retry on all the SQL queries they perform.
• Firebird and Impala extractors now support simple table & column select mode and incremental fetching.

New Features

New type of sharing buckets

• From now on, you can share buckets to specified users. Any listed project users in the organization can use the shared data bucket.

  

Minor Improvements

• Increased speed of name, description and metadata editing in components.

• Latest Activity shown on the Dashboard also for configurations. We also added grouping by events.

  

• Added button for creating a bucket and file in the Storage console.

  
• Tables can no longer be created as direct text input. 

  
• Redesigned error display for jobs; now errors have their own box and details can be shown in the modal window.

  
• Orchestration detail now shows the trendline for previous jobs.

  
• Already seen last time was added to Dashboard Latest Activity.

  

We are experiencing snowflake jobs being processed too slow in EU region. We keep on investigating the issue.

UPDATE Dec 11, 10:57 AM (UTC) - We increased computing power of our Snowflake warehouse and there should be no slow jobs for now, furthermore we keep on monitoring the jobs and investigating the root cause.

We are experiencing failures of GoodData writer and extractor configurations that use Keboola provisioned projects in US region. We have identified the root cause and are working on fix it asap.

UPDATE Dec 11, 10:30 AM (UTC): We have fixed the problem and everything is now working properly. Moreover we found out that regarding GoodData writer, the failure happened only for the Keboola provisioned projects created between Dec 10, 20:00 and Dec 11, 10:15 (UTC).

New Components

AppsFlyer Extractor

• We’re happy to welcome the AppsFlyer Extractor to the family!

• AppsFlyer is the market leader in mobile advertising attribution and analytics, helping marketers to pinpoint their targeting, optimize their ad spend, and boost ROI.

• This component was developed by KDS Team.

DynamoDB Writer

• Another great addition to our component collection is DynamoDB Writer!

• This component lets you write data from our Storage into AWS' DynamoDB, which is a key-value, document-based database. It's fully managed, multiregion, multimaster, durable with built-in security, backup and restore, and in-memory caching for internet-scale applications.
  

  

• This component was developed by KDS Team.
  

CSV to XLSX Processor

• Highly demanded utility to convert data in CSV format to XLSX is here!

• This component was also developed by KDS Team.
  

Updated Components

AWS S3 Extractor

• Uses parallel download and it's more than 20 times faster!

Snowflake Extractor

• Supports incremental load.
  

• Supports config rows.
  

Oracle Extractor

• Supports incremental load.
  

• Supports configuration rows.

• Implemented retry mechanism for all types of queries

Redshift Extractor

• Supports incremental load.

MySQL Extractor

• Implemented retry mechanism for all types of queries

PostgreSQL Extractor

• Added support for PostgreSQL Server v12
  

• Transformations are collapsed by default.
  

  

Data Catalog

• Improved "empty" page
  
  
• Type of sharing is now shown and will be improved further. 
  
  
• Improved “initial" modal
  
  
• Bucket description is shown where applicable. 
  

  

Storage

• When creating an alias table, you can now filter data by the EMPTY_STRING or SPACE characters.
  

  

Fixes

• Fixed a bug in the Darksky extractor date conversion. The bug caused dates in the date column for places in UTC+ timezones to be one day less than the actual forecast date.
  

Developers

• php-csv-options - A library for setting CSV options
  

• php-db-import-export - A library for loading/unloading data between Snowflake and Azure Blob Storage

We have encountered a small number of failed jobs in US region between 4:46 AM - 9:17 AM UTC.

Affected jobs finished with Application Error caused by invalid SSL connection to GoodData and we're investigating the issue.

UPDATE Nov 24, 1:42 PM (UTC) - Only projects having custom GoodData domains was affected by this issue. Problem was with validation of a renewed SSL certificate. The fix is deploying right now.

We are investigating job termination issues for some components. After termination request is accepted jobs remain in terminating state until finished. 

UPDATE Nov 22, 9:28 AM (UTC) - We have identified the root cause and prepared the fix which should be released in few hours. Only minority of jobs termination was affected by this issue.

UPDATE Nov 22, 10:49 AM (UTC) - The fix was deployed and job termination is fully functional again for all jobs.

Amazon Elastic Compute Cloud is facing increased network connectivity errors to instances, hence the performance of Keboola Connection in EU region is impacted. As a consequence connection to Snowflake and creation of Jupyter/R sanboxes fails, most of the jobs are slow or stalled.

UPDATE Nov 12, 8:39 AM (UTC) Amazon have identified the root cause and are working to resolve the issue.

We are experiencing failures of few components e.g. Salesforce Extractor. It is caused by recent infrastructure changes that were deployed on November 8th.

We are rolling back these changes and we'll update this status with new information.

UPDATE Nov 11, 8:37 AM (UTC) - Changes was rolled back and affected components should be working again without issues.

UPDATE Nov 11, 8:50 AM (UTC) - We're investigating further issues with Salesforce Extractor. 

UPDATE Nov 11, 9:00 AM (UTC) - Salesforce Extractor is working again. 

We're sorry for the inconvenience. 

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.

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!