page194
280
Figure 8-9.
Warehouse scaling options
For the affected data load, you should first look at the latest run query profile. You are
looking for spills to disk and OOM errors, both covered in Chapter 3. If either is evident,
you should consider either scaling up the ingest warehouse size to the next size or
reducing warehouse concurrency.
The following query repeated from Chapter 3 identifies spills to disk and OOM
errors. Replace
warehouse_name
with your chosen value:
SET tpc_owner_role = 'tpc_owner_role';
SET tpc_warehouse_XS = 'tpc_wh_xsmall';
SET tpc_warehouse_XL = 'tpc_wh_xlarge';
SET tpc_database = 'tpc';
SET tpc_owner_schema = 'tpc.tpc_owner';
USE ROLE IDENTIFIER ( $tpc_owner_role );
USE DATABASE IDENTIFIER ( $tpc_database );
USE SCHEMA IDENTIFIER ( $tpc_owner_schema );
USE WAREHOUSE IDENTIFIER ( $tpc_warehouse_xs );
Chapter 8
parallelization