At 9:30am CEST the worker instance was terminated and all unfinished jobs started processing on other instances.
We're sorry for this inconvenience.
At 9:30am CEST the worker instance was terminated and all unfinished jobs started processing on other instances.
We're sorry for this inconvenience.
SQL Server Extractor now supports incremental fetching on DateTime and Identity columns
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.
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.
Jobs related to Python/R sandboxes now show the proper link to a configuration:
Improved description of components in events
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.
There are components in KBC which you can setup in just a few clicks with only basic knowledge. But there are also components which require you to have deep knowledge about how it works. For this reason we have introduced Complexity Badges to be able distinguish between these types of components even before you start setting them up.
Not all components have assigned Complexity Badges yet, but we are continuously working on updating the components catalog.
We would like to remind you that the Restbox component was deprecated in July 2018 and will be completely shut down on November 1, 2018.
If you still have some Restbox configurations in your projects, please migrate them to one of following replacements:
We have identified a bug in the primary key implementation in Storage which could lead to improper data deduplication. Only a very limited number of tables is affected by this bug – 7 tables in all KBC projects in all stacks. We'll be contacting owners of the affected projects soon to help fixing the affected tables.
The deduplication stopped working when a column used in a compound primary key was deleted.
During this operation, the information about the whole primary key was unknowingly dropped in the Snowflake backend and this was not propagated correctly to our Storage metadata that still contained the primary key (minus the deleted column). In Snowflake, commands such as ALTER TABLE ... DROP COLUMN ...
immediately drop the whole primary key if it’s dropping a column of a compound primary key. The deduplication process retrieves primary key information from the DESCRIBE TABLE ...
Snowflake command which shows no primary key in the affected tables, but our metadata still incorrectly shows that a primary key is set.
We are implementing a fix that will store and retrieve primary keys from a single source.