We continue to roll-out connectors to support bi-directional connection with Snowflake, where user can catalog, audit rules and the cleanse data without need for any external data pipelines. User will be able to add Snowflake as a source in DvSum and make customer's data insightful by Cataloging, Profiling , Executing rules and cleansing it. Let's get started.
Note:
To add Snowflake as a source following are the required conditions to be fulfilled.
a) SAWS version should be 2.4.0 and above
b) Snowflake as a source type should be enabled (explained below)
Getting Started with Snowflake as a Source
Before starting the configuration process, ensure that query history is properly set up. Query history is essential for enabling seamless data lineage and effective data analysis within the application. For a detailed guide on enabling query history refer to the Enabling Query History for Data Sources article.
Step 1: Enabling Snowflake Source in DvSum
1 Open the Dvsum application, select Administration and click on Manage sources option, Click on Add Source and Select Snowflake source. Following error messages will be displayed if the Snowflake source is not enabled for users 'Owner' and 'Admin'.
Note: Only owner is authorized to add the source.
Owner:
Admin:
1.2 Owner will click the Manage account link and gets re-directed to this page from where the source can be enabled. On other hand, Admin will request the owner to get the source enabled for the account. Click the Saws tab, select the saws and click Enable source button;
1.3 From the list of available sources, select Snowflake and click Upgrade button as shown below;
1.4 On returning back in SAWS tab, it will take some time to process and after that Snowflake Icon will appear in enabled sources column which means that source got successfully enabled as shown below
Scenario 1 : SAWS Error
On upgrading if there's any issue with SAWS then an error message will be displayed "Please check if your SAWS is working correctly".
Scenario 2: Pending State
On upgrading if there's any job(s) running then it will go in pending state.
Step 2 : Adding Snowflake source in DvSum tool
2.1 Open the Dvsum application, select Administration and click on Manage sources option, Click on Add Source and Select Snowflake source as shown below;
2.2 Once landed on source detail page, you will be required to provide following info to add Snowflake as a source;
Host Information
- URL (will be used by user to access database. This link is given in the email that you will get on activating account for snowflake)
- Database
- Warehouse
Credentials (Same as which are use to login into Snowflake account)
- User
- Password
2.3 After that Success message will be displayed and now click the save button;
2.4 Now Snowflake is added as a source and user will be able to Catalog it, profile it, Execute Rules and cleanse it.
0 Comments