Alter Table
Alter a Snowflake table with search optimization service.
A user can register one or more tables to the search optimization service. Search optimization applies to columns with supported data types, which include:
- Fixed-point numbers (INTEGER, NUMERIC).
- DATE, TIME, and TIMESTAMP.
- VARCHAR.
- BINARY.
Currently, the search optimization service does not support floating point data types, semi-structured data types, or other data types not listed above.
Additionally, the search optimization service does not support the following:
- Analytical expressions.
- Casts on table columns.
- Column concatenation.
- External tables.
- Materialized views.
For more information, read Using the Search Optimization Service.
:::info{title='Note'} Tables created in Snowflake can take up to five minutes to appear in the Matillion ETL UI. :::
Properties
Name = string
A human-readable name for the component.
Database = drop-down
The Snowflake database. The special value, [Environment Default], will use the database defined in the environment. Read Databases, Tables and Views - Overview to learn more.
Schema = drop-down
The Snowflake schema. The special value, [Environment Default], will use the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.
Target Table = drop-down
The table to alter. The tables available to select are determined by the defined Snowflake database and schema.
Search Optimization Service = drop-down
Turn on or off the search optimization service. For more information, read Using the Search Optimization Service.
| Snowflake | Delta Lake on Databricks | Amazon Redshift | Google BigQuery | Azure Synapse Analytics |
|---|---|---|---|---|
| ✅ | ❌ | ❌ | ❌ | ❌ |