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.
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 |
|---|---|---|---|---|
| ✅ | ❌ | ❌ | ❌ | ❌ |