Setting up a Virtual Warehouse for ETL
You learn how to set up a Unified Analytics Virtual Warehouse for extract, transform, and load (ETL) jobs. You learn how to enable query isolation mode.
- Required role: DW Admin
- Create a Virtual Warehouse, selecting Hive as the type of SQL engine.
- Configure the Hive Virtual Warehouse as instructed above for the Impala Virtual Warehouse: Set the Name, Type (Hive), Database Catalog, User Groups, and Size.
Turn on ETL Isolation.
This action sets the internal configuration property hive.etl.execution.engine to Tez for query isolation.
- Click Create.