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 your connection settings and try again. |