Free Preparation Discussions
MENU
Snowflake SOL-C01 Exam - Topic 3 Question 7 Discussion
Topic #: 3
Where is unstructured data stored in Snowflake?
Unstructured data such as PDF files, images, and other binary documents is stored in stages in Snowflake. These stages may be internal stages, which Snowflake manages directly, or external stages, which reference external cloud storage such as Amazon S3, Azure Blob Storage, or Google Cloud Storage. Stages are the designed mechanism for storing and accessing unstructured files so that they can be processed with functions like PARSE_DOCUMENT or accessed via directory tables.
External tables are used to query structured or semi-structured data (for example, Parquet or JSON) stored in external locations, not to store raw unstructured binary content. The Cloud Services layer coordinates metadata, security, and query services; it does not store user data. Tables with a single VARCHAR column might be used as an improvised approach for small text blobs, but this is not the native or recommended method for managing unstructured data at scale.
==================
Darnell
1 day agoStanton
6 days agoTori
11 days agoIrving
17 days agoDiane
22 days agoMelissa
27 days agoAnnamae
1 month agoBernardine
1 month agoRyan
1 month agoRosendo
2 months agoJovita
2 months agoJoesph
2 months agoKayleigh
2 months agoReita
4 months agoJohnetta
4 months agoNada
4 months agoAlaine
4 months agoLorrine
4 months agoBonita
4 months agoMiesha
5 months agoRocco
5 months agoTarra
5 months agoAdell
5 months agoTula
5 months agoMarsha
6 months ago