Skip to main content
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 your data to an on-premises server from the cloud if you so wish.

​
Properties

​
Name
string
required
A human-readable name for the component.
​
Endpoint
string
required
The Microsoft SQL Server endpoint. For example, <hostname>:<port>.
​
Database Name
string
required
Your Microsoft SQL Server database name.
​
Username
string
required
Your Microsoft SQL Server username.
​
Password
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.
​
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
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.
​
Schema
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.
​
Source Table
drop-down
required
The table (or view) on your cluster to copy to SQL Server.
​
Target Table
string
required
A name for the new table.
​
Target Schema
string
required
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
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.
​
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
required
Whether or not to truncate the target table before loading data.
​
On Warnings
boolean
required
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.