Properties
string
required
A human-readable name for the component.
string
required
The Microsoft SQL Server endpoint. For example,
<hostname>:<port>.string
required
Your Microsoft SQL Server database name.
string
required
Your Microsoft SQL Server username.
drop-down
required
Choose the secret definition that represents your credentials for this connector.If you have not already saved your credentials for this connector as a secret definition, click Add secret to create a secret definition representing these credentials. Read Secrets and secret definitions for details about creating a secret definition.
column editor
- Parameter: A JDBC parameter supported by the database driver. For more information read Connection options.
- Value: A value for the given parameter.
drop-down
required
The Snowflake database. The special value
[Environment Default] uses the database defined in the environment. Read Databases, Tables and Views - Overview to learn more.drop-down
required
The Snowflake schema. The special value
[Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.drop-down
required
The table (or view) on your cluster to copy to SQL Server.
string
required
A name for the new table.
string
required
The schema for the target table.
object selector
Select the columns to load. Leave this blank to load all columns.
drop-down
required
- None: Assume the SQL Server database already has the table defined with the correct structure.
- Create if not exists: If the named target table does not yet exist, it will be created.
- Replace: If the named target table already exists, it will be dropped and replaced by a newly created table. Use this setting with care.
object selector
Select one or more columns to use as the table’s primary key. The component uses the primary key to identify matching rows in the target table when determining the update strategy.If you select multiple columns, the component creates a composite primary key using the combination of the selected columns.Leave this blank to load all rows without duplicate checking.
boolean
required
Whether or not to truncate the target table before loading data.
boolean
required
Choose whether to continue with the load if an error is raised, or to fail the run.
column editor
Any additional options that you want to apply to the copy operation. For more information, read SQL Server Bulk Copy Options.
integer
The number of rows to load to the target between each COMMIT. The default is 5000.