Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Snowflake

Identity Resolution on Snowflake

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.19.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.

Last updated

Was this helpful?