Zingg0.4.0
Ask or search…
K

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.
Last modified 1mo ago