Knowledge DropLast tested: Mar 9, 2021 At the time the code for the MySQL dialect was written, it did not support WITH, so we had to write derived tables a bit differently. Instead of WITH we use CREATE temp TABLE, which requires database permissions...

The content of this article has been updated and migrated to a Looker Help Center article. But, the information in the comments is useful, so the article will remain here for discussion. For the actual contents, please visit the Help Center.