SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ122

Data Ingestion and Data Preparation

PDF files are being ingested into a Snowflake environment. The files will be staged and later processed into tables. The data will be shared directly through software links to the PDF files, with server-side encryption enabled.

How should these PDF files be ingested while creating a catalog of staged files and using server-side encryption?

Explanation

An internal stage using SNOWFLAKE_SSE supports server-side encryption required for direct access to staged unstructured files. Setting DIRECTORY = (ENABLE = TRUE) creates a directory table, which catalogs the files stored on the stage.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!