<!-- WARNING: This documentation is auto-generated from the confluentinc/cli repository and should not be manually edited. -->

<a id="confluent-flink-materialized-table-create"></a>

# confluent flink materialized-table create

## Description

Create a Flink materialized table.

```none
confluent flink materialized-table create <name> [flags]
```

## Flags

```none
    --database string                 REQUIRED: The ID of Kafka cluster hosting the Materialized Table's topic.
    --compute-pool string             REQUIRED: The ID associated with the compute pool in context.
    --principal string                REQUIRED: The ID of a principal this Materialized Table query runs as.
    --query string                    REQUIRED: The query section of the latest Materialized Table.
    --cloud string                    Specify the cloud provider as "aws", "azure", or "gcp".
    --region string                   Cloud region for Flink (use "confluent flink region list" to see all).
    --columns-physical string         Path to the columns data for type physical.
    --columns-metadata string         Path to the columns data for type metadata.
    --columns-computed string         Path to the columns data for type computed.
    --watermark-column string         The name of the watermark columns.
    --watermark-expression string     The watermark expression.
    --constraints string              Path to the constraints.
    --distribution-keys string        The names of the columns the table is distributed by.
    --distribution-bucket-count int   The number of buckets.
    --environment string              Environment ID.
    --context string                  CLI context name.
-o, --output string                   Specify the output format as "human", "json", or "yaml". (default "human")
```

## Global Flags

```none
-h, --help            Show help for this command.
    --unsafe-trace    Equivalent to -vvvv, but also log HTTP requests and responses which might contain plaintext secrets.
-v, --verbose count   Increase verbosity (-v for warn, -vv for info, -vvv for debug, -vvvv for trace).
```

## Examples

Create Flink materialized table “my-table” in AWS us-west-2.

```none
confluent flink materialized-table create my-table --cloud aws --region us-west-2 --database lkc01 --compute-pool pool1 --principal principal1 --query query1
```

## See Also

* [confluent flink materialized-table](index.md#confluent-flink-materialized-table) - Manage Flink materialized tables.