An external stage is a named database object that specifies the location and connection details for data files stored in external cloud storage (Amazon S3, Google Cloud Storage, or Microsoft Azure). It can reference a storage integration object, which securely stores credentials and permissions, allowing Snowflake to access the external location without exposing sensitive information directly in the stage definition. This makes the external stage the primary object for establishing a secure connection.

A. A directory table is a feature built upon a stage; the stage itself provides the connection.

B. An external table reads from files located in an external stage, but the stage defines the connection.

D. A named file format describes the structure of data within files, not the connection to the storage location.

1. Snowflake Documentation. (n.d.). CREATE STAGE. Retrieved from https://docs.snowflake.com/en/sql-reference/sql/create-stage. "Creates a new stage for uploading files... An external stage references data files stored in a location outside of Snowflake (i.e. in a cloud storage bucket)."

2. Snowflake Documentation. (n.d.). Introduction to Data Loading. Retrieved from https://docs.snowflake.com/en/user-guide/data-load-overview. "A stage specifies where data files are stored... External stages store files in an external location (i.e. S3 bucket, GCS bucket, or Azure container)."

3. Snowflake Documentation. (n.d.). Overview of Data Loading. Retrieved from https://docs.snowflake.com/en/user-guide/data-load-considerations-overview. "Snowflake allows you to load data from files that have been staged in an internal (i.e. Snowflake) stage or an external (i.e. S3, GCS, or Azure) stage."