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

# Wildcard Table Input

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={["Google BigQuery"]} unsupportedWarehouses={["Snowflake", "Databricks", "Amazon Redshift"]} componentType="Transformation" connectionInputs="One" connectionOutputs="Unlimited" />

BigQuery allows the creation of wildcard tables that combine all tables found through a wildcard expression.

A wildcard expression can be any string followed by the wildcard character, `*`, that will then represent any other possible string. Thus, for example, using the wildcard expression `Flights_20*` might return Flights\_2014, Flights\_2015, Flights\_2016 and Flights\_20Temp as a single, united table.

For full information, see the Google Cloud Platform documentation [querying wildcard tables](https://docs.cloud.google.com/bigquery/docs/querying-wildcard-tables).

***

## Properties

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

{/* <!-- param-start:[gcpProjectId] | warehouses: [bigquery] --> */}

<ResponseField name="GCP project ID" type="drop-down" required>
  The Google Cloud project that owns the BigQuery dataset. The special value `[Environment Default]` uses the Google Cloud project defined in the environment. For more information, read [Creating projects](https://docs.cloud.google.com/resource-manager/docs/creating-managing-projects).
</ResponseField>

{/* <!-- param-start:[dataset] | warehouses: [bigquery] --> */}

<ResponseField name="Dataset" type="drop-down" required>
  The Google BigQuery dataset containing the table to query. The special value `[Environment Default]` uses the dataset defined in the environment.
</ResponseField>

{/* <!-- param-start:[tablePrefix] | warehouses: [bigquery] --> */}

<ResponseField name="Table prefix" type="string" required>
  A prefix that all united tables must have. The wildcard character is positioned exactly after this prefix.
</ResponseField>

{/* <!-- param-start:[includeTableSuffix] | warehouses: [bigquery] --> */}

<ResponseField name="Include table suffix" type="drop-down" required>
  * **Yes:** The remaining string after the table prefix is removed from each table name is to be given in a column, showing the origin table of each row.
  * **No:** Do not store suffixes in the wildcard table.
</ResponseField>

{/* <!-- param-start:[tableSuffixColumnName] | warehouses: [bigquery] --> */}

<ResponseField name="Table suffix column name" type="string" required>
  Name of the column where table suffixes are listed. Property only visible if **Include table suffix** is **Yes**.
</ResponseField>

{/* <!-- param-start:[whereClause] | warehouses: [bigquery] --> */}

<ResponseField name="Where clause" type="string" required>
  Adds a freeform SQL filter that is appended to the component's generated SELECT statement, enabling you to filter which tables are included in the union.
</ResponseField>