Microsoft SQL Server Output
The Microsoft SQL Server Output component outputs the contents of a table (or view) from your cloud data warehouse (CDW) to your Microsoft SQL Server database. With this component, you can push their data to an on-premesis server from the cloud if you so wish.
Properties
Name = string
A human-readable name for the component.
Endpoint = string
The Microsoft SQL Server endpoint. For example, <hostname>:<port>.
Database Name = string
Your Microsoft SQL Server database name.
Username = string
Your Microsoft SQL Server username.
Password = drop-down
The secret definition containing the password for your Microsoft SQL Server account. Your password should be saved as a secret definition before using this component.
JDBC Options = column editor
- Parameter: A JDBC parameter supported by the database driver. For more information read Connection options.
- Value: A value for the given parameter.
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.
Source Table = drop-down
The table (or view) on your cluster to copy to SQL Server.
Target Table = string
A name for the new table.
Target Schema = string
The schema for the target table.
Load Columns = dual listbox
Use the arrow buttons to select which columns to load. Move columns to the right to include them in the load. By default, all columns will be selected for the load.
Table Maintenance = drop-down
- 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.
Primary Key = dual listbox
A column or a group of columns used to identify a row uniquely in a table. Use the arrow buttons to select which columns to use.
Truncate Target Table = boolean
Whether or not to truncate the target table before loading data.
On Warnings = boolean
Choose whether to continue with the load if an error is raised, or to fail the run.
Additional Copy Options = column editor
Any additional options that you want to apply to the copy operation. For more information, read SQL Server Bulk Copy Options.
Batch Size = integer
The number of rows to load to the target between each COMMIT. The default is 5000.
| Snowflake | Databricks | Amazon Redshift |
|---|---|---|
| ✅ | ❌ | ❌ |