Knowledge Drop

Does Looker require access to the scratch schema to write ephemeral derived tables?

  • 7 July 2021
  • 1 reply
  • 222 views

Userlevel 5
Badge
  • Looker Staff
  • 173 replies

Last tested: Nov 5, 2019
 

For most dialects a scratch schema is not needed in order to use non-persistent derived tables.

For the MySQL family (Clustrix, MemSQL, MariaDB) you do need to do some additional setup to allow ephemeral derived tables. According to docs, you can just grant the proper permissions to a schema that doesn't necessarily exist.

GRANT

SELECT,

INDEX,

INSERT,

DROP,

CREATE TEMPORARY TABLES

ON looker_tmp.*;

-- Note that the looker_tmp schema does not need to actually exist,

-- even though these permission grants are still needed

```

 

 

This content is subject to limited support.                

 

 


Reply