We are using MySQL as our DB and was happy with the way dbt was working for us. The DB team recently upgraded the DB and has enforced PRIMARY KEY for all tables. This is now breaking our run, since our “CREATE TABLE AS” run by the dbt, creates TEMPORARY tables internally, which is no longer allowed by the Database config.
The new PRIMARY KEY enforcing on ‘ALL’ tables, is causing our dbt to fail due to the CTAS statements that we have, which internally created TEMPORARY TABLES, but without any PRIMARY KEYS
The Database team WILL NOT roll back the PRIMARY KEY enforcement and we have to live with it.
Any tips on what we can do to get dbt working under such scenarios?