Knowledge DropLast tested: Oct 31, 2018 If you have difficulty linking to an image hosted on gdrive with html, you'll want to add the image ID to the URL in this form:From this doc:https://gist.github.com/evansims/f23e2f49e3d4be793038This is also hel...

Knowledge DropLast tested: May 10, 2019If your instance is hosted by Looker, the .tmp directory is cleared on startup.If you host your own instance, and this directory gets too large, you can safely delete certain files in .tmp when the instance is s...

Knowledge DropLast tested: Dec 5, 2019Looker doesn't support PDTs in Infobright.If you want to have DTs (ephemeral, not persistent), you will need to use a workaround where the SQL query is written in the sql_table_name parameter:view: derived_table ...

Knowledge DropLast tested: Dec 3, 2017 ... are tables that hold data about the database itself; tables, processes etc. DCLers commonly use these concurrently to troubleshoot hanging PDT queries or long running ones, etc. stv_inflight & stv_recents st...

Knowledge DropLast tested: Oct 24, 2018A weird quirk that happens specifically with Redshift is that when using a schema that isn't the Public one and tables are being updated with full table drops, every time a table is dropped and re-created it doe...