From around 21:10 CET today, Snowflake began having availability issues in the EU region.
https://community.snowflake.com/s/group/0F90Z000000U8dJ/alerts-awseu-frankfurt
[Update 21:33 CET -- They have discovered the cause and are working on a remedy]
[Update 21:42 CET -- Service is now fully restored in the EU region]
The orchestration section is one of the last parts of Keboola Connection which does not yet have a unified user interface. We believe that users should feel comfortable using the different parts of our UI, so unifying the interface elements is very important to us.
We have launched the new Orchestration Detail page
What has changed?
- There is no longer a sidebar on the left side with a list of orchestrations
- Tasks, Schedule and Notifications now have their own place in the detail page - they're no longer combined in that table
- We added new sidebar on the right side that you should feel familiar with because it is the same as other components
- Orchestration Action buttons (Run, Enable/Disable and Delete) have been moved to the right sidebar
- Also, information about creation date and updates now also have their own place in the right sidebar
This is the beginning of the Orchestration Interface tuning and there are more things to come.
---
Just for completeness, this is the previous version:
During deployment of Keboola Connection in the EU region at around 13:30 CET today there was a timing issue that resulted in some failed storage jobs.
The problem occurred because of the asynchronous timing between the rollover of a worker and the API server. A small number of jobs that were created with the previous version then failed when executed against the new API. These jobs failed with one of the following error messages "`Invalid source type" or "Workspace not found".
There was no corruption of data by these failures as no jobs that were in progress were affected.
At 9:30am CEST the worker instance was terminated and all unfinished jobs started processing on other instances.
We're sorry for this inconvenience.
New Features
Updated Components
SQL Server Extractor now supports incremental fetching on DateTime and Identity columns
Unexpected Events
Many of you have noticed that we added validation of SQL queries to the Transformation Detail page last week.
Due to some problems in availability of this feature we decided to revert this change.
For now you can still use the "standard" validation button on the right.
We love this feature too and the plan is to bring it back after an additional round of improvements.
Today between 10 and 11 a.m. (UTC) SQL validations and SQLdep functionality in Transformations were returning errors.
The errors were caused by temporary outage of external SQLdep service (https://status.sqldep.com/779807590). Transformation jobs were not affected.
We're experiencing a high number of errors in Storage Jobs in the US region. The errors are caused by invalid SSL connection to Snowflake and we're investigating the issue.
Update 01:02 am CET: Snowflake issues an official statement.
Update 07:00 am CET: Snowflake updated an issue. We are working on a workaround.
Update 07:56 am CET: Issue is resolved. Snowflake moved the Keboola account to a new certificate provider. Now we are processing backlog of jobs.
Update 09:20 am CET: Backlog is cleared. All systems are operating normally.
Revised Project Invitations
Inviting users to KBC projects has been reworked. Previously, users were directly added to the project via Users & Settings -> Users menu. Now, when adding a new user to the project, an invitation email is sent to the user.
The invited user can accept or decline the pending invitations in the Account Settings.
See the docs for more details.
New Features
- We have added some predefined searches to the job list. See the docs for a more detailed description of the search queries.
Minor Improvements
Jobs related to Python/R sandboxes now show the proper link to a configuration:
Improved description of components in events
- Configurations in trash are now sorted by the date of deletion:
- Component configuration state is reset on copy:
UI Improvements and fixes
- Dialog for adding a new task to orchestration now contains configuration description
- Every job detail events log now contains component info
- Improved orchestration notifications ui
- Improved brief summary of orchestration tasks
- Unified view of data mappings in the job detail page with respect to the running component as follows:
- Input - represents all the data flowing from the storage into the component - typically this would apply for transformation or writer component type.
-
Output - represents all the data flowing from the component into the storage, typically this would apply for extractor component type.
- Code editor support for JSON editing of component setup in Developer portal
- When creating a new extractor in Developer portal the default bucket is automatically turned on
- Improved naming of new phase and phase names capitalisation
November 2, between 2:43am CET and 3:14 CET we experienced Snowflake service degradation in EU region that led to slow down of the orchestrations. The issue has been resolved. We apologize for the inconvenience caused.