* The username used to connect to your Snowflake host.
* The private key.
* The passphrase. If you create an encrypted private key, then OpenSSL prompts for a passphrase used to encrypt the private key file.
| {" "} Property{" "} | {" "} Value{" "} | {" "} Default{" "} | {" "} Description{" "} |
|---|---|---|---|
| {" "} Name{" "} | {" "} JSMITH{" "} | {" "} null{" "} | {" "} Name{" "} |
| {" "} RSA\_PUBLIC\_KEY\_FP{" "} | {" "} SHA256:nvnONUsfiuycCLMXIEWG4eTp4FjhVUZQUQbNpbSHXiA={" "} | {" "} null{" "} | {" "} Fingerprint of user's RSA public key.{" "} |
| {" "} RSA\_PUBLIC\_KEY\_2\_FP{" "} | {" "} null{" "} | {" "} null{" "} | {" "} Fingerprint of user's second RSA public key.{" "} |
|
Field |
Description |
|---|---|
| {" "} Account Name{" "} | {" "} Enter the full name of your account (provided by Snowflake.) For US West Region account\_name and All other regions account\_name.region\_id |
| {" "} Username{" "} | {" "} Enter the username used to connect to your Snowflake host.{" "} |
| {" "} Private Key{" "} | {" "} Enter the private key.{" "} |
| {" "} Passphrase{" "} | {" "} If you create an encrypted private key, then OpenSSL prompts for a passphrase used to encrypt the private key file. Enter that passphrase here.{" "} |
| {" "} Role{" "} | {" "} Enter your role.{" "} |
|
Menu |
Description |
||||||||
|---|---|---|---|---|---|---|---|---|---|
|
Input DataSet ID |
{" "} Enter the DataSet ID (GUID) for the DataSet you want to copy to Snowflake. You can find the ID by opening the details view for the DataSet in the Data Center and looking at the portion of the URL following datasources/. For example, in the URL {" "} [https://mycompany.domo.com/datasources/845305d8-da3d-4107-a9d6-13ef3f86d4a4/details/overview\{](https://mycompany.domo.com/datasources/845305d8-da3d-4107-a9d6-13ef3f86d4a4/details/overview\{)" "} , the DataSet ID is 845305d8-da3d-4107-a9d6-13ef3f86d4a4.{" "} |
||||||||
|
Select Table Name |
{" "}
Select how you want to name the table where data will be copied.
|
||||||||
|
Enter Table Name |
{" "} Enter the name of the Snowflake table you want your data copied to (spaces and special characters will be replaced with underscores).{" "} |
||||||||
|
Warehouses |
Select the warehouse. |
||||||||
|
Databases |
Select the database. |
||||||||
|
Database Schema |
Select the schema. |
||||||||
| {" "} Use All Caps for Column Names and Table Name{" "} | {" "} Write back your column names and table name in ALL CAPS, so the names are case insensitive within Snowflake.{" "} | ||||||||
| {" "} How do you want to update your data in snowflake?{" "} |
|
||||||||
| {" "} Choose the Escape character{" "} | {" "} Select the escape character for the input dataset.{" "} |