Comment on page
Snowflake

Identity Resolution on Snowflake
Check a step-by-step tutorial at Towards Data Science.
The config value for the data and output attributes of the JSON is:
 "data" : [ {
			"name":"test", 
			"format":"net.snowflake.spark.snowflake", 
			"props": {
				"sfUrl": "rfa59271.snowflakecomputing.com",
				"sfUser": "sonalgoyal",
				"sfPassword":"ZZ",					
				"sfDatabase":"TEST",				
				"sfSchema":"PUBLIC",					
				"sfWarehouse":"COMPUTE_WH",
				"dbtable": "FEBRL",
				"application":"zingg_zingg"				
			}
		} ]
One must include Snowflake JDBC driver and Spark dependency on the classpath. The jars can be downloaded from the maven repository (1, 2).
spark.jars=snowflake-jdbc-3.13.18.jar,spark-snowflake_2.12-2.10.0-spark_3.1.jar
For Zingg to discover the Snowflake jars, please add the property spark.jars in Zingg's runtime properties.​
If you are looking for a native-run on Snowflake without using Spark, check Zingg Enterprise Snowflake. 
Databricks
JDBC
Last modified 5mo ago