Handling ETL jobs

Unified Analytics provides DML support for extract, transform, and load tasks. ETL jobs, identified by their size, run in query isolation mode if enabled.

Unified Analytics supports insert, update, merge, and delete statements for performing ETL tasks.
  1. Log in to the Data Warehouse service as DWAdmin.
  2. Create a Unified Analytics Virtual Warehouse (Hive), selecting the Enable Query Isolation option.
    Query isolation is available as a technical preview and requires an entitlement.
  3. Click Create Virtual Warehouse.
Insert, update, and delete data as described in subsequent topics.