Week in Review — December 12, 2019

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.

    Slow jobs in EU region

    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.

    Gooddata Writer/Extractor failures in US region

    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).

    Job termination issue

    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.

    AWS performance issues in EU region

    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.

    UPDATE Nov 12, 9:10 AM (UTC) Amazon has restored most of the network connectivity to impacted instances and is completing recovery for the remaining connectivity errors. However the performance of Keboola Connection remains impacted.

    UPDATE Nov 12, 9:36 AM (UTC) Keboola Connection is back to operational state, however some jobs might not start immediately due to queuing with the many recently triggered jobs.

    Component failures

    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. 


    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.

    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.

    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.