When using the Teradata initiator FOREIGN TABLE or EXPLAIN queries, QueryGrid creates tables under the temporary database. Users require CREATE TABLE and DROP TABLE access to the temporary database.
When using Presto with a standalone Hive Metastore (only supported with Presto on AWS CFT), you must define the location of the temporary tables. You can define the location for the temporary database using the following example:
CREATE DATABASE <database_name> LOCATION '<path_to_cloud_storage>'; Set the <database_name> as Temporary Schema Name NVP