UP10020 COMPUTE_CLUSTER is missing

Possible Causes

  • You tried to create one of JOB, MATERIALIZED VIEW, or Table but no COMPUTE_CLUSTER was provided. When an organization has multiple clusters one must be provided when defining a new JOB, MATERIALIZED VIEW, or Table.

Possible Solutions

  • Provide a compute cluster value using the COMPUTE_CLUSTER option

To find the available clusters click 'Clusters' on the left navigation bar.

Code example:

CREATE SYNC JOB load_orders_raw_data_from_s3
    CONTENT_TYPE = JSON
    COMPUTE_CLUSTER = "Production"
    AS COPY FROM S3 upsolver_s3_samples LOCATION = 's3://upsolver-samples/orders/' 
    INTO default_glue_catalog.upsolver_samples.orders_raw_data;

The COMPUTE_CLUSTER can be altered at any time.

ALTER JOB load_orders_raw_data_from_s3 
    SET COMPUTE_CLUSTER = "Another cluster name";

Last updated