> ## 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.

# Show to Grid

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" />

Show to Grid is an orchestration component that lets you save the results of a [SHOW](https://docs.snowflake.com/en/sql-reference/sql/show) command into a [grid variable](/docs/guides/grid-variables).

***

## Properties

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

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

<ResponseField name="Mode" type="drop-down" required>
  Select **Basic** or **Advanced**. Basic is a low-code methodology for configuring this component. Advanced mode requires you to write the SQL manually.

  Depending on the mode selected, different properties will be available for configuration.
</ResponseField>

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

<ResponseField name="Object Type" type="drop-down" required>
  Select from a list of object types that you want to run [SHOW](https://docs.snowflake.com/en/sql-reference/sql/show) against.

  This property is only available when `Mode` is set to **Basic**.
</ResponseField>

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

<ResponseField name="In Location" type="drop-down" required>
  Choose from **Account**, **Database**, or **Schema** to define the scope of the `Object Type`.

  Depending on your selection, you may need to specify a database or schema in the properties below.
</ResponseField>

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

<ResponseField name="Database" type="drop-down">
  The Snowflake database. The special value `[Environment Default]` uses the database defined in the environment. Read [Databases, Tables and Views - Overview](https://docs.snowflake.com/en/guides-overview-db) to learn more.

  Depending on the value selected in the `In Location` property, this property may be required.
</ResponseField>

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

<ResponseField name="Schema" type="drop-down">
  The Snowflake schema. The special value `[Environment Default]` uses the schema defined in the environment. Read [Database, Schema, and Share DDL](https://docs.snowflake.com/en/sql-reference/ddl-database.html) to learn more.

  Depending on the value selected in the `In Location` property, this property may be required.
</ResponseField>

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

<ResponseField name="Like" type="string">
  A pattern for case-sensitive matching of strings. For more information, read [LIKE](https://docs.snowflake.com/en/sql-reference/functions/like).
</ResponseField>

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

<ResponseField name="Starts with" type="string">
  A Snowflake [STARTSWITH](https://docs.snowflake.com/en/sql-reference/functions/startswith) function.

  Depending on the `Object Type` selected, this property may not be applicable.
</ResponseField>

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

<ResponseField name="Limit" type="integer">
  The row limit to return. Maximum is 5000.

  Depending on the `Object Type` selected, this property may not be applicable.
</ResponseField>

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

<ResponseField name="Query" type="code editor">
  Input a `SHOW` command. For more information, read [SHOW](https://docs.snowflake.com/en/sql-reference/sql/show).

  Use [Maia](/docs/guides/maia-ai-agents-overview) to build your query.

  This property is only available when `Mode` is set to **Advanced**.
</ResponseField>

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

<ResponseField name="Grid Variable" type="drop-down" required>
  Select a grid variable item from the list. For more information, read [Grid variables](/docs/guides/grid-variables).
</ResponseField>

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

<ResponseField name="Grid Variable Mapping" type="column editor" required>
  Map columns from the `SHOW` query to the columns of the grid variable. For more information, read [SHOW](https://docs.snowflake.com/en/sql-reference/sql/show).
</ResponseField>