Snowflake Data Asset Properties

Create a data asset to extract data from a Snowflake data source.

The Snowflake Connector enables you to store and analyze data using cloud-based hardware and software.

To create a data asset that connects to a Snowflake source, complete the following properties and connection details.

Field Description
Properties
Name Enter a name for the data asset.
Identifier The identifier is a system-generated value based on the name. You can change the identifier value, but after you create and save, you cannot update the identifier.
Description (Optional) Add a description.
Type The field shows the data source type that you selected in the Select data asset type panel (as described in Creating a Data Asset). Data Integration displays the data asset property fields and default connection fields based on this type.
Host

Enter the IP address of the host.

Port

Enter 443, the default port for HTTPS-enabled endpoints.

Database name

Enter the name of a database.

Account name

Enter the name of an account.

Schema

Enter the schema in the account.

Warehouse

Enter the warehouse in the account.

Default connection information
Name Enter a name for the default connection.
Identifier The identifier is a system-generated value based on the name. You can change the identifier value, but after you create and save, you cannot update the identifier.
Description (Optional) Add a description.
Username

Enter the username.

Vault secret OCID for database password

Copy and paste the OCID of the secret for the database password associated with the user from OCI Vault.

(Optional) Test connection
Test connection After you complete all the required fields, click Test connection to ensure that the data asset details have been entered correctly and the connection can be established. A success message appears if the test is successful. If the test fails with an error message, review the connection settings and try again.