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.