| create_temp_table | If true, a unique temporary table name will be generated in the sys_temp schema and used in place of input parameter projection_name. If persist is false (or unspecified), then this is always allowed even if the caller does not have permission to create tables. The generated name is returned in qualified_projection_name. The default value is false. The supported values are: |
| collection_name | [DEPRECATED--please specify the containing schema for the projection as part of input parameter projection_name and use
Create Schema
to create the schema if non-existent] Name of a schema for the projection. If the schema is non-existent, it will be automatically created. The default value is ''. |
| expression | An optional filter expression to be applied to the source table prior to the projection. The default value is ''. |
| is_replicated | If true then the projection will be replicated even if the source table is not. The default value is false. The supported values are: |
| offset | The number of initial results to skip (this can be useful for paging through the results). The default value is '0'. |
| limit | The number of records to keep. The default value is '-9999'. |
| order_by | Comma-separated list of the columns to be sorted by; e.g. 'timestamp asc, x desc'. The columns specified must be present in input parameter column_names. If any alias is given for any column name, the alias must be used, rather than the original column name. The default value is ''. |
| chunk_size | Indicates the number of records per chunk to be used for this projection. |
| chunk_column_max_memory | Indicates the target maximum data size for each column in a chunk to be used for this projection. |
| chunk_max_memory | Indicates the target maximum data size for all columns in a chunk to be used for this projection. |
| create_indexes | Comma-separated list of columns on which to create indexes on the projection. The columns specified must be present in input parameter column_names. If any alias is given for any column name, the alias must be used, rather than the original column name. |
| ttl | Sets the TTL of the projection specified in input parameter projection_name. |
| shard_key | Comma-separated list of the columns to be sharded on; e.g. 'column1, column2'. The columns specified must be present in input parameter column_names. If any alias is given for any column name, the alias must be used, rather than the original column name. The default value is ''. |
| persist | If true, then the projection specified in input parameter projection_name will be persisted and will not expire unless a ttl is specified. If false, then the projection will be an in-memory table and will expire unless a ttl is specified otherwise. The default value is false. The supported values are: |
| preserve_dict_encoding | If true, then columns that were dict encoded in the source table will be dict encoded in the projection. The default value is true. The supported values are: |
| retain_partitions | Determines whether the created projection will retain the partitioning scheme from the source table. The default value is false. The supported values are: |
| partition_type | Partitioning scheme to use. |
| partition_keys | Comma-separated list of partition keys, which are the columns or column expressions by which records will be assigned to partitions defined by partition_definitions. |
| partition_definitions | Comma-separated list of partition definitions, whose format depends on the choice of partition_type. See range partitioning, interval partitioning, list partitioning, hash partitioning, or series partitioning for example formats. |
| is_automatic_partition | If true, a new partition will be created for values which don't fall into an existing partition. Currently only supported for list partitions. The default value is false. The supported values are: |
| view_id | ID of view of which this projection is a member. The default value is ''. |
| strategy_definition | The tier strategy for the table and its columns. |
| join_window_functions | If set, window functions which require a reshard will be computed separately and joined back together, if the width of the projection is greater than the join_window_functions_threshold. The default value is 'true'. |
| join_window_functions_threshold | If the projection is greater than this width (in bytes), then window functions which require a reshard will be computed separately and joined back together. The default value is ''. |
