Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Bolo.

Table of Contents

Search

  1. Introducing Mass Ingestion
  2. Getting Started with Mass Ingestion
  3. Connectors and Connections
  4. Mass Ingestion Applications
  5. Mass Ingestion Databases
  6. Mass Ingestion Files
  7. Mass Ingestion Streaming
  8. Monitoring Mass Ingestion Jobs
  9. Asset Management
  10. Troubleshooting

Mass Ingestion

Mass Ingestion

Key pair authentication

Key pair authentication

The following table describes the Snowflake Data Cloud connection properties for the KeyPair authentication type connection:
Connection property
Description
Runtime Environment
The name of the runtime environment where you want to run the tasks.
You cannot run application ingestion tasks and database ingestion tasks on a Hosted Agent or serverless runtime environment.
Authentication
The authentication method to log in to Snowflake.
Select
KeyPair
.
Username
The user name to connect to the Snowflake account.
Account
The name of the Snowflake account.
For example, if the Snowflake URL is
https://123abc.us-east-2.aws.snowflakecomputing.com/console/login#/
, your account name is the first segment in the URL.
Here,
123abc.us-east-2
is your account name.
For the Snowsight URL, for example,
https://app.snowflake.com/us-east-2.aws/123abc/dashboard
, your account name is
123abc.us-east-2
.
Ensure that the account name does not contain underscores. To use an alias name, contact Snowflake Customer Support.
Warehouse
The Snowflake warehouse name.
Additional JDBC URL Parameters
Optional. The additional JDBC connection parameters.
Enter one or more JDBC connection parameters in the following format:
<param1>=<value>&<param2>=<value>&<param3>=<value>....
For example:
user=jon&warehouse=mywh&db=mydb&schema=public
Ensure that there is no space before and after
=
when you add the parameters.
Private Key File
Path to the private key file, including the private key file name, that the Secure Agent uses to access Snowflake.
Verify that the keystore is FIPS-certified.
Private Key Password
Password for the private key file.

0 COMMENTS

We’d like to hear from you!