1. MIDSERVER
2. SNOWFLAKE CREDENTIALS WITH BASIC AUTHENTICATION
Below are the steps to integrate with Snowflake.
Step1: Download the latest JAR file from maven repository with extension JAR and download the highlighted file.
Link:https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/
Link to Download the file : https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/3.13.6/
Step2: Attach the Downloaded files to ServiceNow below are the steps mentioned.
Navigate -> Mid server ->JAR Files
Attach the downloaded file and fill out the respective field values.
And then "Submit" the form. Incase you are getting the below error ignore it.
This file will be uploaded to MIDSERVER in the Agent -> lib -> extlib folder.
Note: When uploading the JAR file from ServiceNow Instance it will be uploaded to all the "Mid Server" running on the ServiceNow Instance and automatically all the midserver will be restarted once the JAR file is uploaded. Make sure to do this exercise in non business hours for production Instance.
Step3:
Configuring the DATA SOURCE
Navigate -> System Import sets -> Data Sources
Create a New Data Source
Select the Type as "JDBC" 
Label: Snowflake
Value : net.snowflake.client.jdbc.SnowflakeDriver
This can also be referenced in this website : https://docs.snowflake.com/en/user-guide/jdbc-configure.html#other-parameters
Sample Datasource Form:
MIDSERVER: Use any of your MID Server (Because the JAR will be Loaded onto all MIDSERVERS on your Instance)
DATABASENAME : SNOWFLAKE DATABASE NAME from which you're retrieving the data.
USERNAME: SNOWFLAKE USERNAME
PASSWORD: SNOWFLAKE PASSWORD
Step:4
Setting up Connection URL to communicate with SNOWFLAKE
Create a "Before Insert BR" on the Data source table to dynamically construct the Connection URL with conditions.
Script:
SAMPLE CONNECTION URL:
current.connection_url = "jdbc:snowflake://YOUR ACCOUNT NAME.YOUR REGION.snowflakecomputing.com/?user=" + current.jdbc_user_name + "&password=" + current.jdbc_password + "&warehouse=YOUR WAREHOUSE NAME &db=" + current.database_name + "&schema= YOUR SCHEMA NAME FROM SNOWFLAKE &role= YOUR SNOWFLAKE ROLE NAME";
YOUR ACCOUNT NAME : SNOWFLAKE ACCOUNT NAME
YOUR REGION : This differs based on the region (E.g for US starts with (us.east..) for EUROPE -> (eu.central )
USER: It will be retrieved from Datasource "Username" field.
PASSWORD: It will be retrieved from Datasource "Password" field.
WAREHOUSE : YOUR SNOWFLAKE WAREHOUSE NAME
DATABASE (db) : It will be retrieved from Datasource "Database" field.
SCHEMA : YOUR SCHEMA NAME FROM SNOWFLAKE
ROLE: YOUR SNOWFLAKE ROLE NAME
NOTE: Ask SNOWFLAKE team to create a local account with Basic Authentication method for the Servicenow user inorder to communicate with SNOWFLAKE.
After setting all this you should be able to Test load 20 records from SNOWFLAKE.
Referal Liks and Docs:
https://docs.snowflake.com/en/user-guide/jdbc-configure.html#other-parameters
https://docs.snowflake.com/en/user-guide/admin-account-identifier.html
https://docs.snowflake.com/en/user-guide/jdbc-configure.html#jdbc-driver-class
https://docs.snowflake.com/en/user-guide/jdbc-configure.html#jdbc-driver-connection-string
