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

Standard authentication

Standard authentication

When you set up a Snowflake Data Cloud connection, configure the connection properties.
The following table describes the Snowflake Data Cloud connection properties for the Standard authentication mode:
Connection property
Description
Connection Name
Name of the connection.
The name is not case sensitive. It must be unique within the domain. You can change this property after you create the connection. The name cannot exceed 128 characters, contain spaces, or contain the following special characters:
~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
Description
Optional. Description that you use to identity the connection.
The description cannot exceed 765 characters.
Type
The Snowflake Data Cloud connection type.
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
Select the authentication method that the connector must use to log in to Snowflake.
Select
Standard
. Default is
Standard
.
Username
The user name to connect to the Snowflake account.
Password
The password 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. You must specify the warehouse name.
Role
The Snowflake role assigned to the user.
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.

0 COMMENTS

We’d like to hear from you!