Temp derived_table creation failed: Unknown database 'looker_tmp'

[Vitali]

Hello,

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?