Contents x
    Alter Table
      • Dark
        Light
      Contents

      Alter Table

        • Dark
          Light
        Article Summary

        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

        PropertySettingDescription
        NameStringA human-readable name for the component.
        Target TableSelectSelect the table to alter. The tables available to select are determined by the defined Snowflake database and schema.
        SchemaSelectSelect 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.
        DatabaseSelectSelect 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 ServiceSelectTurn on or off the search optimization service. For more information, read Using the Search Optimization Service.
        What's Next