> ## Documentation Index
> Fetch the complete documentation index at: https://docs.maia.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Alter Warehouse

export const designer = "Designer";

export const ComponentMetadata = ({warehouses, unsupportedWarehouses = [], componentType, connectionInputs, connectionOutputs}) => {
  const allWarehouses = [...warehouses.map(w => ({
    name: w,
    supported: true
  })), ...unsupportedWarehouses.map(w => ({
    name: w,
    supported: false
  }))];
  return <div style={{
    background: 'var(--colors-background-light, #f9fafb)',
    border: '1px solid var(--colors-border-default, #e5e7eb)',
    borderRadius: '12px',
    padding: '20px 28px',
    marginBottom: '28px',
    boxShadow: '0 1px 4px rgba(0,0,0,0.10)'
  }}>
      <table style={{
    width: '100%',
    borderCollapse: 'collapse'
  }}>
        <tbody>
          <tr>
            <td style={{
    fontWeight: '600',
    paddingRight: '32px',
    paddingBottom: '14px',
    whiteSpace: 'nowrap',
    verticalAlign: 'middle',
    width: '180px'
  }}>Project Availability</td>
            <td style={{
    paddingBottom: '14px',
    verticalAlign: 'middle'
  }}>
              <div style={{
    display: 'flex',
    flexWrap: 'wrap',
    gap: '8px'
  }}>
                {allWarehouses.map((w, i) => <span key={i} style={{
    background: w.supported ? '#dcfce7' : '#fee2e2',
    color: w.supported ? '#15803d' : '#b91c1c',
    border: `1px solid ${w.supported ? '#bbf7d0' : '#fca5a5'}`,
    borderRadius: '9999px',
    padding: '3px 12px',
    fontSize: '0.85rem',
    fontWeight: '500',
    whiteSpace: 'nowrap'
  }}>
                    {w.name} {w.supported ? '✅' : '❌'}
                  </span>)}
              </div>
            </td>
          </tr>
          <tr>
            <td style={{
    fontWeight: '600',
    paddingRight: '32px',
    paddingBottom: '14px',
    whiteSpace: 'nowrap',
    verticalAlign: 'middle'
  }}>Component Type</td>
            <td style={{
    paddingBottom: '14px',
    verticalAlign: 'middle'
  }}>{componentType}</td>
          </tr>
          <tr>
            <td style={{
    fontWeight: '600',
    paddingRight: '32px',
    paddingBottom: '14px',
    whiteSpace: 'nowrap',
    verticalAlign: 'middle'
  }}>Connection Inputs</td>
            <td style={{
    paddingBottom: '14px',
    verticalAlign: 'middle'
  }}>{connectionInputs}</td>
          </tr>
          <tr>
            <td style={{
    fontWeight: '600',
    paddingRight: '32px',
    whiteSpace: 'nowrap',
    verticalAlign: 'middle'
  }}>Connection Outputs</td>
            <td style={{
    verticalAlign: 'middle'
  }}>{connectionOutputs}</td>
          </tr>
        </tbody>
      </table>
    </div>;
};

<ComponentMetadata warehouses={["Snowflake"]} unsupportedWarehouses={["Databricks", "Amazon Redshift", "BigQuery"]} componentType="Orchestration" connectionInputs="One" connectionOutputs="Unlimited" />

The Alter Warehouse component allows users to edit a warehouse from within {designer}. This component makes use of [Snowflake's Alter Warehouse functionality](https://docs.snowflake.net/manuals/sql-reference/sql/alter-warehouse.html).

***

## Properties

<ResponseField name="Name" type="string" required>
  A human-readable name for the component.
</ResponseField>

{/* <!-- param-start:[warehouse] | warehouses: [snowflake] --> */}

<ResponseField name="Warehouse" type="drop-down" required>
  The Snowflake warehouse. The special value `[Environment Default]` uses the warehouse defined in the environment. Read [Snowflake's Virtual Warehouses documentation](https://docs.snowflake.com/en/user-guide/warehouses.html) to learn more.
</ResponseField>

{/* <!-- param-start:[commandType] | warehouses: [snowflake] --> */}

<ResponseField name="Command Type" type="drop-down" required>
  Select the operation to perform on the Snowflake warehouse:

  * **Abort All Queries:** Aborts all the queries currently running or scheduled on a warehouse.
  * **Rename To:** Rename this warehouse.
  * **Resume:** Choose to bring back a suspended warehouse to a usable state by provisioning compute resources.
  * **Set:** Alters the properties of a warehouse.
  * **Suspend:** Choose to remove all compute nodes from a warehouse. Additionally, puts the warehouse into a SUSPENDED state.
  * **Unset:** Resets the current value of a warehouse property back to its default value.
</ResponseField>

{/* <!-- param-start:[newName] | warehouses: [snowflake] --> */}

<ResponseField name="New Name" type="string" required>
  The new name for the Snowflake warehouse. This property is only relevant when **Command type** is set to **Rename To**.
</ResponseField>

{/* <!-- param-start:[properties, properties1] | warehouses: [snowflake] --> */}

<ResponseField name="Properties" type="dual listbox" required>
  Choose one or more properties to change. This property is only relevant when **Command type** is set to **Set**. The available properties are as follows:

  * **MAX\_CONCURRENCY\_LEVEL:** Specifies the maximum number of SQL statements (queries, DDL, DML, etc.) a warehouse cluster can execute concurrently. The maximum concurrency is 8 times the number of processors on your cloud instance. For example: An instance with 2 processors has a maximum concurrency of 16.
  * **STATEMENT\_QUEUED\_TIMEOUT\_IN\_SECONDS:** Specifies the time, in seconds, an SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.
  * **STATEMENT\_TIMEOUT\_IN\_SECONDS:** Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
  * **COMMENT:** Adds a comment or overwrites the existing comment for the warehouse.
  * **WAREHOUSE\_SIZE:** Choose a [warehouse size](https://docs.snowflake.net/manuals/user-guide/warehouses-overview.html#warehouse-size).
  * **MAX\_CLUSTER\_COUNT:** The number of available clusters (1, 2, 3, 4 or 5).
  * **MIN\_CLUSTER\_COUNT:** Optionally set to a value greater than 1.
  * **AUTO\_SUSPEND:** If auto-suspend is enabled (set to **TRUE**), the warehouse is automatically suspended if the warehouse is inactive for the specified period of time.
  * **AUTO\_RESUME:** If auto-resume is enabled (set to **TRUE**), the warehouse is automatically resumed when any statement that requires a warehouse is submitted to the current warehouse for the session.
  * **RESOURCE\_MONITOR:** Sets the warehouse to use a resource monitor.
  * **SCALING\_POLICY:** Specifies the policy for automatically starting and shutting down clusters in a multi-cluster warehouse running in auto-scale mode. Set to **STANDARD** or **ECONOMY**.
</ResponseField>