Alter a Snowflake table with search optimization service.
Tables created in Snowflake can take up to five minutes to appear in the Matillion ETL UI.
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
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.
|Name||String||A human-readable name for the component.|
|Target Table||Select||Select the table to alter. The tables available to select are determined by the defined Snowflake database and schema.|
|Schema||Select||Select the Snowflake schema. The special value, [Environment Default], will use the schema defined in the Matillion ETL environment. For more information, read Database, Schema, & Share DDL.|
|Database||Select||Select the Snowflake database. The special value, [Environment Default], will use the database defined in the Matillion ETL environment. For more information, read Databases, Tables, & Views.|
|Search Optimization Service||Select||Turn on or off the search optimization service. For more information, read Using the Search Optimization Service.|