A human-readable name for the component.
The Snowflake warehouse used to run the queries. The special value [Environment Default] uses the warehouse defined in the environment. Read Overview of Warehouses to learn more. The Snowflake schema. The special value [Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more. Select the output table. The available tables depend on the selected environment.
Select whether to cast types in the event of data type mismatches.
- Yes: If the source column type does not match the target table type, attempt to CAST the value to the required target type.
- No: Do not cast types (do not fix data type mismatches).
In each Source column drop-down, select a column in your dataset that you want to write to your existing table. Click the + icon to add another row, or before adding any rows, click Add all to add all input columns to the Source column. If you click Add all, the Target column fields will automatically be completed if there is a column in the selected target table that matches the name of the source column.In each Target column drop-down, select the existing column in the selected target table to populate with the selected Source column data. You can add source columns multiple times to populate different target columns with the same data.
- Column: Select the output column(s) to sort by.
- Sort Order: Set the corresponding column to be ordered ascending (default) or descending.
- Append: Adds the records to the end of the table.
- Truncate: Empty existing rows in the target table before loading the incoming input rows. This operation may use either a TRUNCATE or DELETE FROM query, depending on whether the current flow is in a transaction or not. TRUNCATE is faster, and therefore preferred, but is not transaction-safe and is not used if a transaction is in progress.
A human-readable name for the component.
Select a Databricks Unity Catalog. The special value [Environment Default] uses the catalog defined in the environment. Selecting a catalog determines which databases are available in the next parameter. The Databricks schema. The special value [Environment Default] uses the schema defined in the environment. Read Create and manage schemas to learn more. Select the output table. The available tables depend on the selected environment.
Select whether to cast types in the event of data type mismatches.
- Yes: If the source column type does not match the target table type, attempt to CAST the value to the required target type.
- No: Do not cast types (do not fix data type mismatches).
In each Source column drop-down, select a column in your dataset that you want to write to your existing table. Click the + icon to add another row, or before adding any rows, click Add all to add all input columns to the Source column. If you click Add all, the Target column fields will automatically be completed if there is a column in the selected target table that matches the name of the source column.In each Target column drop-down, select the existing column in the selected target table to populate with the selected Source column data. You can add source columns multiple times to populate different target columns with the same data.
- Append: Adds the records to the end of the table.
- Truncate: Empty existing rows in the target table before loading the incoming input rows. This operation may use either a TRUNCATE or DELETE FROM query, depending on whether the current flow is in a transaction or not. TRUNCATE is faster, and therefore preferred, but is not transaction-safe and is not used if a transaction is in progress.
A human-readable name for the component.
Select the table schema. The special value [Environment Default] uses the schema defined in the environment. For more information on using multiple schemas, read Schemas. Select the output table. The available tables depend on the selected environment.
Select whether to cast types in the event of data type mismatches.
- Yes: If the source column type does not match the target table type, attempt to CAST the value to the required target type.
- No: Do not cast types (do not fix data type mismatches).
In each Source column drop-down, select a column in your dataset that you want to write to your existing table. Click the + icon to add another row, or before adding any rows, click Add all to add all input columns to the Source column. If you click Add all, the Target column fields will automatically be completed if there is a column in the selected target table that matches the name of the source column.In each Target column drop-down, select the existing column in the selected target table to populate with the selected Source column data. You can add source columns multiple times to populate different target columns with the same data.
- Append: Adds the records to the end of the table.
- Truncate: Empty existing rows in the target table before loading the incoming input rows. This operation may use either a TRUNCATE or DELETE FROM query, depending on whether the current flow is in a transaction or not. TRUNCATE is faster, and therefore preferred, but is not transaction-safe and is not used if a transaction is in progress.
A human-readable name for the component.
The Google Cloud project. The special value [Environment Default] uses the project defined in the environment. Read Creating and managing projects to learn more. The Google BigQuery dataset. The special value [Environment Default] uses the dataset defined in the environment. Read Introduction to datasets to learn more. Select the output table. The available tables depend on the selected environment.
Select whether to cast types in the event of data type mismatches.
- Yes: If the source column type does not match the target table type, attempt to CAST the value to the required target type.
- No: Do not cast types (do not fix data type mismatches).
Click the gear icon to open the Column mapping dialog and configure the following:
- Source column: The source field from the input flow.
- Target column: The target table’s output column to insert data into.
Click Add all to automatically populate the Target column with all the columns in the table selected in the Target table property. The Source column matches what is in the Target column, unless there is no column in the source table that matches that column name in the output table, in which case it is blank. You can then selectively edit the list if required, but if you click Add all again it will return the list to the default fully populated state, removing any changes you have made.To add a mapping row manually, click +. To remove a selected row, click -.Click the Text mode toggle at the bottom of the dialog to open a multi-line editor that lets you add items in a single block. For more information, read Text mode.To use grid variables, toggle Use Grid Variable on at the bottom of the dialog. For more information, read Grid variables.
- Append: Adds the records to the end of the table.
- Truncate: Empty existing rows in the target table before loading the incoming input rows. This operation uses a TRUNCATE TABLE or DELETE statement.
