Computing on Data Snowflake Can't Read: Homomorphic Encryption in Plain Python UDFs
·2214 words·11 mins
Sums, averages, net pay, variance, correlation, regression, ML scores and running totals, computed by Snowflake on encrypted columns, with no secret key and not even a public key in the platform. Ordinary Python UDFs on a standard warehouse, 185 results verified against plaintext, and an honest look at the cost and the limits.