Skip to content

Rewrite Table

Write the input data flow out to a new table. Runtime errors may occur, for example, if a data value overflows the maximum allowed size of a field.

The output table is overwritten each time the component is executed; therefore, don't use this component to output permanent data that you do not want to overwrite.


Properties

Name = string

A human-readable name for the component.


Warehouse = drop-down

The Snowflake warehouse used to run the queries. The special value, [Environment Default], will use the warehouse defined in the environment. Read Overview of Warehouses 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.


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 = string

A name for the new table.


Order By = column editor

Select the columns to order by. Set the corresponding column to be ordered ascending (default) or descending.