Contents x
Alter Table
  • Dark
    Light
Contents

Alter Table

  • Dark
    Light
This article is specific to the following platforms - Snowflake.

Alter Table

Alter a Snowflake table with search optimization service.

Note

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
  • 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.

Properties

Snowflake Properties

Property Setting Description
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.
What's Next

Cookie consent

We use our own and third-party cookies to understand how you interact with our knowledge base. This helps us show you more relevant content based on your browsing and navigation history.