Tableau 8.2 MySQL error with extracts - CREATE TABLE ... SELECT is forbidden when GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.

tableaucommunity@tableau.com — Thu, 19 Jun 2014 18:00:05 GMT

Hi, I've created a data connection using MySQL. After creating the connection, I've created an extract.

After creating the extract, when I try to do any action on the extract (Edit connection, Remove extract, etc.) I get the following error:

[MySQL][ODBC 5.3(w) Driver][mysqld-5.6.17-65.0-56-log]CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.

I didn't get this error when using Tableau 8.1 (same server, data connection, same tables, same query).

Any ideas? - this is a blocker for upgrading to 8.2.

Regards,

Francisco

Content in Tableau Community Forums