Exam SnowPro Core topic 1 question 664 discussion

SNowflake_full for client and snowflake_sse for server side

This is a bit obscure and buried in documentation. https://docs.snowflake.com/en/sql-reference/sql/create-stage#internal-stage-parameters-internalstageparams SNOWFLAKE_FULL: Client-side and server-side encryption. The files are encrypted by a client when it uploads them to the internal stage using PUT. Snowflake uses a 128-bit encryption key by default. You can configure a 256-bit key by setting the CLIENT_ENCRYPTION_KEY_SIZE parameter. All files are also automatically encrypted using AES-256 strong encryption on the server side. SNOWFLAKE_SSE: Server-side encryption only. The files are encrypted when they arrive on the stage by the cloud service where your Snowflake account is hosted. Specify server-side encryption if you plan to query pre-signed URLs for your staged files. For more information, see Types of URLs Available to Access Files.

SNOWFLAKE_FULL: Client-side encryption. The files are encrypted by a client when it uploads them to the internal stage using PUT. SNOWFLAKE_SSE: Server-side encryption. The files are encrypted when they arrive in the stage.

SNOWFLAKE_FULL: Client-side encryption. The files are encrypted by a client when it uploads them to the internal stage using PUT. https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage

https://suya-huang.medium.com/snowflakes-client-side-encryption-and-server-side-encryption-4c7a83427010