Skip to content

Alter Table

The Alter Table component allows users to enable or disable the Snowflake Search Optimization Service on any table provided it uses the supported data types of Integer, Numeric, Date, Time, Timestamp, Varchar or Binary.

For more information, read Using the Search Optimization Service in Snowflake's documentation.


Properties

Name = string

A human-readable name for the component.


Target Table = drop-down

Select the table to alter. The tables available to select are determined by the selected Snowflake database and schema.


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.


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.


Search Optimization Service = drop-down

Turn on or off the search optimization service. For more information, read Using the Search Optimization Service in Snowflake's documentation.


Snowflake Databricks Amazon Redshift (preview)