Keboola Status

Today we have launched a brand new user interface Keboola Connection. Some of you have been already working with it and giving us feedback for a while.

Now it is available for everyone, so you can start exploring it right now. There are no big or conceptual changes so we hope everything will be familiar to you. And you'll have your work done faster.

Just a few highlights:

• Consistent behaviour, every action provides feedback.
• Interface doesn't lie like the old one, and pending indicators are shown for all actions so you can be sure that everything is saved when your action is complete.
• It should be more descriptive and should guide you, we know there is still lot of work ahead of us.
• All extractors, writers and orchestrations can be renamed
• Faster navigation and linked relations like jobs and component configurations

Finally it is a solid base for upcoming enhancements and features. Important areas are collaboration, project overview and monitoring, better understanding and organization of data, project changelog.

We’d also love to hear your feedback, you can reach us on support@keboola.com or if you want to be closer to development on our Github project page.

In case something went wrong you can still switch to the previous version by the link trick: just change the project url https://connection.keboola.com/admin/projects/YOUR_PROJECT_ID to https://connection.keboola.com/admin/projects-new/YOUR_PROJECT_ID yes, this one is old :) 

Enjoy!

According to our previous notice, AdWords Extractor has been updated to use new version v201506 of AdWords API. You can start using new metrics.

Listing of users (GET /users), projects (GET /projects) and project users (GET /project-users) has been limited to 10000 results. To this moment listing of much more results didn't work anyway, Writer returned error instead of the listing. So if your writer contains more results and you have a script which process them, you will need to update it to support pagination. It works using parameters offset and limit (see docs for more information)

Amazon Simple Queue Service is reporting increased error rate in our main region. This affects majority of our applications and APIs. We hope for a quick fix, please bear with us, we'll post any updates here.

UPDATE 11:41pm PST / 08:41 CEST: We've migrated Storage API to SQS in a different region, so it's fully functional now. We're working on migrating all other APIs and apps to a different region as well.

UPDATE 00:05am PST / 09:05 CEST: All components should be working now, we're migrating process terminating queues (this bit is not working yet). You can restart your failed jobs. 

UPDATE 00:52am PST / 09:52 CEST: Everything is back up and working normally. We're sorry for any inconvenience, you can now restart failed orchestrations and terminate all stuck or waiting processes.

MySQL Sandbox server is unreachable at the moment. Problem is caused by connectivity issues of our provider.

We are working on fix.

On Wednesday at 9.15am PST We incorrectly configured sql_mode on the MySQL transformation server to value STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION. 

This has caused many errors in you transformations and orchestrations - mostly with messages like

• Invalid datetime format: 1292 Truncated incorrect datetime value: ...
• String data, right truncated: 1406 Data too long for column ...
  
• Incorrect decimal value: '' for column ...
  
• Incorrect integer value: '' for column ...

We identified the error and fixed it on Thursday at 12.20am PST. 

We are sorry for this inconvenience, we're working on setting up the environment so this error can't happen again. We tried to rerun all failed orchestrations, but if there's anything left, please restart the orchestration, everything should run correctly now.

New version v201506 of AdWords API has been released yesterday and our extractor will update in the beginning of August. Please be sure to update your configuration to not use unsupported metric names till the end of July. Also do not use new metrics until the update, we will let you know about it.

The API version (2.2) our Facebook Ads Extractor uses will be deprecated on 8.7.2015. We will therefore update the extractor to current 2.3 version. This change shouldn't affect the extraction according to the changelog: https://developers.facebook.com/docs/marketing-api/changelog

If your extractor fails, or delivers wrong data after 6.7., please let us know and we'll investigate what caused the problem.

In the past few days we encountered problems with imports from Google Drive.

These problems were caused by Google's auto-migration to "New Sheets".

If you have problem with your Google Drive Extractor, removing and re-adding the problematic sheet will fix the issue. 

Be aware of your previous sheet configuration like "output mapping to SAPI table" or "transposition". 

Contact support@keboola.com if you are not sure how to do it.

Oracle driver is now available in Database Writer.

Not all data types are supported yet, but this will change soon.