Please first read how to use the Discovery Application.
Discover a Snowflake database
To discover a Snowflake database with the Discovery Application, please choose the following source system type:
Then, fill in the following information:
The value examples below correspond to the source example explained in the Snowflake target environment.
- Name: discovery name
- Example: Snowflake_AW2017
- Account Identifier: the Snowflake account where the source database is located
- Example: org12345.eu-west-1
- Database: database name
- Example: SNOWFLAKE_461345104558_USER_01
- Authentication Type
- User: user who can connect to the database (only when you select Authentication Type = PasswordAuthentication)
- Example: TRAINING_461345104558_USER_01
- Password: password of the user
- Schema: schema name
- Example: AW2017
- Role (optional): if the user has a specific role to access the database
- Example: R_SNOWFLAKE_461345104558_USER_01
- Warehouse (optional): Warehouse
If your Snowflake user uses Multi-factor Authentication (MFA) with Duo, a notification to approve the connection will be sent when you click the “Discover Source System Data” button.
Please approve the request.
Once approved, the discovery process will display the available source objects in the database.
You can download an example discovery file here to start modeling, even if you don’t have access to this type of source system.