Table Input
Table Input reads chosen columns from an input table or view into the transformation pipeline. This component will also work with external tables.
Properties
Name = string
A human-readable name for the component.
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 = drop-down
The name of the input table or view. The tables and views found in the currently selected environment are provided to choose from.
Column Names = dual listbox
The columns to include in the input. If you wish to rename the column names, consider using the Rename component to change them.
Time Offset = integer
Offsets the table contents by the number of specified seconds. This is a function of Snowflake's Time Travel feature, allowing you to see a table as it was X seconds ago.
Name = string
A human-readable name for the component.
Catalog = drop-down
Select a Databricks Unity Catalog. The special value, [Environment Default], will use the catalog specified in the environment setup. Selecting a catalog will determine which databases are available in the next parameter.
Schema = drop-down
The Delta Lake on Databricks schema. The special value, [Environment Default], will use the schema defined in the environment. Read Create and manage schemas to learn more.
Target Table = drop-down
The name of the input table or view. The tables and views found in the currently selected environment are provided to choose from.
Column Names = dual listbox
The columns to include in the input. If you wish to rename the column names, consider using the Rename component to change them.
Offset Type = drop-down
Select how the table contents will be offset. Options are:
- None: No offset.
- Timestamp: Unlocks the Timestamp Offset property.
- Version: Unlocks the Version Offset property.
Timestamp Offset = integer
Enter a number of seconds to offset the table by. This is a function of Delta Lake's Time Travel feature, allowing you to see a table as it was X seconds ago.
Version Offset = string
Enter the table version to offset to. This is a function of Delta Lake's Time Travel feature, allowing you to see a table as it was at a defined version.
Name = string
A human-readable name for the component.
Schema = drop-down
Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on using multiple schemas, read Schemas.
Target Table = drop-down
The name of the input table or view. The tables and views found in the currently selected environment are provided to choose from.
Column Names = dual listbox
The columns to include in the input. If you wish to rename the column names, consider using the Rename component to change them.
Trim Columns = drop-down
Wraps the column names in a BTRIM function, which will strip out all the leading and trailing spaces. Read the Redshift documentation for details.
| Snowflake | Databricks (preview) | Amazon Redshift (preview) |
|---|---|---|
| ✅ | ✅ | ✅ |