What exactly is a scratch schema?

  • 22 July 2020
  • 1 reply

I saw this term “scratch schema” when learning about PDTs. I guess it would mean database schema design or something similar to that, but could anyone give the exact definition of “Scratch Schema”?

Thank you.

1 reply

The scratch schema is a schema in your database that Looker uses for PDTs. It’s used to store the results of PDT queries as tables on that schema and will drop/rebuild those PDT’s from there when necessary.