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

Knowledge Drop

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.                

Comments
Om_Singh
Explorer

Power of Derived Tables in Looker: A Game Changer for Data Analysis
https://dataanalysisexperts.net/power-of-derived-tables-in-looker-a-game-changer-for-data-analysis/

Version history
Last update:
‎07-07-2021 01:13 PM
Updated by: