You learn how to set up a Unified Analytics Virtual Warehouse for Business
Intelligence (BI), or ad-hoc querying. An Impala Virtual Warehouse can read full ACID tables
in the Hive metastore, and can write insert-only ACID tables because you select the Impala
engine type.
First you create a VW of SQL engine type Impala, and then you enable Unified
Analytics.
-
Create a Virtual Warehouse as described in Adding a new Virtual Warehouse,
selecting the Impala engine type.
-
Select a database catalog, or accept the default.
-
Set User Groups that can access endpoints, keys and values for Tagging the
Virtual Warehouse.
-
Select a size for the Virtual Warehouse.
-
Click Enable Unified Analytics.
Customize other options as necessary.
-
Click Create.