Tableau Writer

For those who love Tableau, we're officially launching "Tableau Writer". At this time, it's able to provision MySQL database or push data to your own MySQL server.

Our Tableau Writer allows you to rename tables, it's columns and define data types for better handling on Tableau side (which configuration is pretty straight forward too - just let Tableau connect to MySQL server with using proper credentials). 

If you're "Tableau Desktop Personal Edition" user, you can enjoy TDE files very soon! (delivered to your Google Drive account automatically). 

SSL issues

We're experiencing some issues in our internal infrastructure. 

You can see following errors on affected orchestrations:

  • Error response from component
  • [curl] (#35)

We're working on a fix and restarting all failed orchestrations. We're sorry for this inconvenience.

Google Analytics Extractor: Metrics and dimensions will be renamed

A few months ago Google Analytics renames several metrics and dimensions (Release 2014-04-16)

https://developers.google.com/analytics/devguides/reporting/core/v3/changelog

Our GA extractor was still using the old names, but according to Googles Data Deprecation Policy, the old metric and dimension names stops working on November 1st.

The Extractor will be using the new names, hence the old ones still remains in the data input buckets. So in the input table will be two columns - old one with old name and old data and new one.

We will be helpful with the transition, but it is on KBC users to solve this by them selfs. For example by merging the old column with the new one in transformation, or move data from the old column to the new one and make respectful changes in transformations working with that input bucket.

Don't hesitate to contact us, if you need any assistance.


Transformation MySQL server down

Our MySQL transformation server TAPI-A is down. We're offloading all work to the backup server, rerunning all failed orchestrations and restarting the TAPI-A server. 

We're sorry for this inconvenience, all operations should be back to normal soon and your transformations will switch to the restarted server automatically.

Provisioning API Update

We'll be updating Provisioning API today at 1:15 pm PST. This shouldn't take longer than 15 minutes. Transformations will be resumed, your credentials will still be valid, only creating of new sandboxes in the Transformation UI will be disabled during this period. 

1:30 pm PST: Migration completed. Thanks for your patience.

Randomly Failing Orchestrations

We're experiencing an AWS-wide DNS problem. Every 01 minute of each hour the DNS does not respond, which can cause failing attempts to connect between components in Keboola Connection. This will cause the running orchestration to fail.

It is reported all across AWS:

https://forums.aws.amazon.com/thread.jspa?threadID=161837&tstart=0

If your orchestration fails with an application error around 01 minute of an hour (it can propagate to the job a bit later, eg. at XX:02), you're most likely affected by this issue. Just re-running the orchestration will solve the problem. 

Please bear with us while we're trying to solve this issue with AWS Support. Here are some examples of failed orchestrations that might help you identify this issue.


Redshift Transformations: Input Mapping Enhancements

These options were turned off for VIEWs (input mappings from Redshift Storage to Redshift Transformation created as a VIEW):

  • Data Types (will inherit Storage data types in the future)
  • Sort Key
  • Dist Key

These options are still present for TABLE input mappings and for MySQL Storage or Transformation.

And on the other hand we turned on Days filter for all Input mapping (was previously turned off for all Redshift transformations).