Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Snowflake supports loading data from external stages that are located on Amazon S3, Google Cloud Storage, and Microsoft Azure blob storage. A Google Cloud storage bucket is a valid source for an external stage when the Snowflake account is located on Microsoft Azure.
Correct answer is C. Snowflake supports loading data from files staged in any of the following locations, regardless of the cloud platform for your Snowflake account: • Internal (i.e. Snowflake) stages • Amazon S3 • Google Cloud Storage • Microsoft Azure blob storage
C is correct
It cannot be C. All resources must be in the same cloud environment.
https://docs.snowflake.com/en/user-guide/data-load-overview#external-stages Loading data from any of the following cloud storage services is supported regardless of the cloud platform that hosts your Snowflake account: Amazon S3 Google Cloud Storage Microsoft Azure
as it is MS based environment
The correct answer is D
changing the voting to C this is correct
MS Azure
Its not D. Snowflake does not support Auzre Windows Share. It only supports BLOB
To my earlier question. The reason its Google storage being correct is, AZURE file share is not supported with Snowflake staging. Snowflake currently supports loading from blob storage only. Snowflake supports the following types of storage accounts. It does not contain the windows share in the list. Blob storage Data Lake Storage Gen2 General-purpose v1 General-purpose v2
C is correct
You can hosted SF at one provide but access data via ext. stage from all three (S3 Bucket, Azure Blob, GCP as well).
correct
I dont understand why some of them say C. Though Snowflake sits on the Azure from the questions, the external stage is anything out of snowflake. It could be Azure File share or it could be Google bucket. can someone clarify?
correct
Snowflake currently supports loading from blob storage only. Snowflake supports the following types of storage accounts: Blob storage Data Lake Storage Gen2 General-purpose v1 General-purpose v2
https://docs.snowflake.com/en/sql-reference/sql/create-stage External stage References data files stored in a location outside of Snowflake. Currently, the following cloud storage services are supported: Amazon S3 buckets Google Cloud Storage buckets Microsoft Azure containers
Google storage is correct as AZURE file share is not supported with Snowflake staging.
In Snowflake, when the account is located on Microsoft Azure, a valid source for an external stage can be an Azure container or a folder path within an Azure container. This includes Azure Blob storage which is accessible via the azure:// endpoint. A Windows server file share on Azure, if configured properly, can be a valid source for staging data files for Snowflake. Options A, B, and C are not supported as direct sources for an external stage in Snowflake on Azure12.