what can i do if destination mysql database has a GTID constraint on

The problem I’m having

The destination Mysql replication has GTID on and ‘create table as select …’ not work for me.

The context of why I’m trying to do this

I try to write data to cloud data base with dbt.