I’m trying to create a temporary derived table and get the following error: “temp derived_table XX creation failed: SQL Error in CREATE TABLE as SELECT: (conn=XX) Unknown database 'looker_tmp'”.
DB dialect: MySQL
DB is read-only.
I don’t need it to be persistent, I need a temp table.
Any ideas why I’m getting this error?