We're launching new AWS S3 Extractor. It allows you to download a single or multiple CSV files from S3 to a single table in Storage.
Read more in the documentation and try it out in your project, available now!
If you have feature requests, please let us know at wishlist@keboola.com.
Between Feb 02 22:40 UTC and Feb 03 17:25 UTC all Snowflake Writer jobs ended with the following error:
SQL compilation error: conflicting values file format parameter 'ESCAPE_UNENCLOSED_FIELD', SQL state 42601 in SQLPrepare.
We have identified the root cause of this issue and fixed it. All Snowflake writers should be fully operational now.
Please accept our sincere apologies for this inconvenience.
We have been working on RStudio and Jupyter Notebook sandboxes (these are the missing sandboxes for R and Python transformations) for some time and we now feel that it is time to move to the next phase.
We can now enable these on a per-user basis for early adopters. If you are interested in playing with these Sandboxes please contact us at support@keboola.com (don't forget to tell us your KBC email).
Limitations:
Otherwise, it's like RStudio connected to your KBC project:
The CSV file locations are the same as in transformations (/data/in/tables/). In the meantime, we will work on:
We have introduced garbage collection for MySQL sandboxes. All sandboxes will be automatically discarded after 14 days. Redshift and Snowflake sandboxes will follow soon.
The Extractor allows you run query with BigQuery legacy SQL or standard SQL dialect.
Empty values are now converted to NULL when the column is set to nullable.
Old version of GoodData extractor has been deprecated in December and will be switched off in upcoming days. Please migrate to the new version if you haven't done it yet. More information here.
Now you can require that visiting support administrators will have their access request approved by an existing project member in order to temporarily join your project. See this article for more information.
In an effort to increase account sovereignty we've introduced a new feature that will give you more control over who can access your projects and for what purposes. It is now possible to require that visiting support administrators have their access request approved by an existing project member in order to temporarily join a project.
The setting can be found in your Account settings at the organization level. This setting will apply to all projects within the organization.
When the support user completes the request form, an email describing the access request is sent to each project member.
The requested access will be listed in the project settings Users section and can be approved or rejected by any active project member.
There were few job failures between 20:55 and 21:15 CEST, due to problems on one of our workers.
We're sorry for this inconvenience, we have restarted the affected orchestrations.
Snowflake backend is experiencing service stability issues which may manifest itself as failed queries or service unavailability. Snowflake engineers are working on fix.
Read more on Snowflake status page.
Update (11:34 PM PST) - Snowflake is still in a recovery process and don't have a defined ETA.
Update (12:38 AM PST) - Service is back online
A few months ago we released a new generation of database writers.
If you are still using the old, deprecated, database writers in your KBC projects, it's time to migrate!
To help with this, we have just released a migration tool for old MySQL, Oracle and Redshift database writers.
If you have any questions or need assistance please contact support@keboola.com.
Our last week was filled with some bug fixes, performance improvements and old infrastructure deprecation.
Shared bucket loading was tweaked to load data directly on Snowflake backend. (available to everyone)
Loading data to sandboxes (mainly used by Transformations and Sandboxes themselves) has been improved, which means multiple tables can be loaded at once.
You should notice speed improvement when using more tables in input mapping and loading larger amount of data. (testing phase, available on request)
Also we would like to mention:
Detail of a job with enabled "Multi Load"
There were few problems with MySQL sandboxes between 12:40 and 13:20 CEST.
Affected server has been deactivated and all operations should run normally right now.
We're sorry for inconvenience.