CODEWITHSUNDEEP
snowflake-cloud-data-platform
Rajib Deb
Rajib Deb

Reputation: 1774

Snowflake External function with Lamdba

When we create an external function to call lambda to fetch let's say an encryption key to decrypt a particular column in a snowflake table, does the LAMBDA get triggered for each row in the table? Or once the encryption key is retrieved, it is available for the entire session

Thanks

Upvotes: 1

Views: 90

Answers (1)

Srinath Menon
Srinath Menon

Reputation: 1642

It would trigger one call to get the encryption key per batch (of up to 4000 rows) and use that for each row in the batch.

Upvotes: 1

Related Questions