| DOCUMENTATION | https://docs.snowflake.com |
| English | https://docs.snowflake.com/en/sql-reference/sql/create-external-table |
| Français | https://docs.snowflake.com/fr/sql-reference/sql/create-external-table |
| Deutsch | https://docs.snowflake.com/de/sql-reference/sql/create-external-table |
| 日本語 | https://docs.snowflake.com/ja/sql-reference/sql/create-external-table |
| 한국어 | https://docs.snowflake.com/ko/sql-reference/sql/create-external-table |
| Português | https://docs.snowflake.com/pt/sql-reference/sql/create-external-table |
| Get started | https://docs.snowflake.com/en/user-guide-getting-started |
| Guides | https://docs.snowflake.com/en/guides |
| Developer | https://docs.snowflake.com/en/developer |
| Reference | https://docs.snowflake.com/en/reference |
| Release notes | https://docs.snowflake.com/en/release-notes/overview |
| Tutorials | https://docs.snowflake.com/en/tutorials |
| Status | https://status.snowflake.com |
| Overview | https://docs.snowflake.com/en/reference |
| SQL data types reference | https://docs.snowflake.com/en/sql-reference-data-types |
| SQL command reference | https://docs.snowflake.com/en/sql-reference-commands |
| Query syntax | https://docs.snowflake.com/en/sql-reference/constructs |
| Query operators | https://docs.snowflake.com/en/sql-reference/operators |
| General DDL | https://docs.snowflake.com/en/sql-reference/sql-ddl-summary |
| General DML | https://docs.snowflake.com/en/sql-reference/sql-dml |
| All commands (alphabetical) | https://docs.snowflake.com/en/sql-reference/sql-all |
| Accounts | https://docs.snowflake.com/en/sql-reference/commands-account |
| Users, roles, & privileges | https://docs.snowflake.com/en/sql-reference/commands-user-role |
| Integrations | https://docs.snowflake.com/en/sql-reference/commands-integration |
| Business continuity & disaster recovery | https://docs.snowflake.com/en/sql-reference/commands-replication |
| Sessions | https://docs.snowflake.com/en/sql-reference/commands-session |
| Transactions | https://docs.snowflake.com/en/sql-reference/commands-transaction |
| Virtual warehouses & resource monitors | https://docs.snowflake.com/en/sql-reference/commands-warehouse |
| Databases, schemas, & shares | https://docs.snowflake.com/en/sql-reference/commands-database |
| Tables, views, sequences, and types | https://docs.snowflake.com/en/sql-reference/commands-table |
| SHOW OBJECTS | https://docs.snowflake.com/en/sql-reference/sql/show-objects |
| CREATE TABLE | https://docs.snowflake.com/en/sql-reference/sql/create-table |
| ALTER TABLE | https://docs.snowflake.com/en/sql-reference/sql/alter-table |
| DROP TABLE | https://docs.snowflake.com/en/sql-reference/sql/drop-table |
| UNDROP TABLE | https://docs.snowflake.com/en/sql-reference/sql/undrop-table |
| SHOW TABLES | https://docs.snowflake.com/en/sql-reference/sql/show-tables |
| SHOW COLUMNS | https://docs.snowflake.com/en/sql-reference/sql/show-columns |
| SHOW PRIMARY KEYS | https://docs.snowflake.com/en/sql-reference/sql/show-primary-keys |
| DESCRIBE TABLE | https://docs.snowflake.com/en/sql-reference/sql/desc-table |
| DESCRIBE SEARCH OPTIMIZATION | https://docs.snowflake.com/en/sql-reference/sql/desc-search-optimization |
| TRUNCATE TABLE | https://docs.snowflake.com/en/sql-reference/sql/truncate-table |
| CREATE DYNAMIC TABLE | https://docs.snowflake.com/en/sql-reference/sql/create-dynamic-table |
| ALTER DYNAMIC TABLE | https://docs.snowflake.com/en/sql-reference/sql/alter-dynamic-table |
| DESCRIBE DYNAMIC TABLE | https://docs.snowflake.com/en/sql-reference/sql/desc-dynamic-table |
| DROP DYNAMIC TABLE | https://docs.snowflake.com/en/sql-reference/sql/drop-dynamic-table |
| UNDROP DYNAMIC TABLE | https://docs.snowflake.com/en/sql-reference/sql/undrop-dynamic-table |
| SHOW DYNAMIC TABLES | https://docs.snowflake.com/en/sql-reference/sql/show-dynamic-tables |
| CREATE EVENT TABLE | https://docs.snowflake.com/en/sql-reference/sql/create-event-table |
| ALTER TABLE (Event Table) | https://docs.snowflake.com/en/sql-reference/sql/alter-table-event-table |
| SHOW EVENT TABLES | https://docs.snowflake.com/en/sql-reference/sql/show-event-tables |
| DESCRIBE EVENT TABLE | https://docs.snowflake.com/en/sql-reference/sql/desc-event-table |
| CREATE EXTERNAL TABLE | https://docs.snowflake.com/en/sql-reference/sql/create-external-table |
| ALTER EXTERNAL TABLE | https://docs.snowflake.com/en/sql-reference/sql/alter-external-table |
| DROP EXTERNAL TABLE | https://docs.snowflake.com/en/sql-reference/sql/drop-external-table |
| SHOW EXTERNAL TABLES | https://docs.snowflake.com/en/sql-reference/sql/show-external-tables |
| DESCRIBE EXTERNAL TABLE | https://docs.snowflake.com/en/sql-reference/sql/desc-external-table |
| CREATE HYBRID TABLE | https://docs.snowflake.com/en/sql-reference/sql/create-hybrid-table |
| CREATE INDEX | https://docs.snowflake.com/en/sql-reference/sql/create-index |
| DROP INDEX | https://docs.snowflake.com/en/sql-reference/sql/drop-index |
| SHOW HYBRID TABLES | https://docs.snowflake.com/en/sql-reference/sql/show-hybrid-tables |
| SHOW INDEXES | https://docs.snowflake.com/en/sql-reference/sql/show-indexes |
| CREATE ICEBERG TABLE | https://docs.snowflake.com/en/sql-reference/sql/create-iceberg-table |
| ALTER ICEBERG TABLE | https://docs.snowflake.com/en/sql-reference/sql/alter-iceberg-table |
| DROP ICEBERG TABLE | https://docs.snowflake.com/en/sql-reference/sql/drop-iceberg-table |
| UNDROP ICEBERG TABLE | https://docs.snowflake.com/en/sql-reference/sql/undrop-iceberg-table |
| SHOW ICEBERG TABLES | https://docs.snowflake.com/en/sql-reference/sql/show-iceberg-tables |
| DESCRIBE ICEBERG TABLE | https://docs.snowflake.com/en/sql-reference/sql/desc-iceberg-table |
| CREATE INTERACTIVE TABLE | https://docs.snowflake.com/en/sql-reference/sql/create-interactive-table |
| CREATE INTERACTIVE WAREHOUSE | https://docs.snowflake.com/en/sql-reference/sql/create-interactive-warehouse |
| SHOW INTERACTIVE TABLES | https://docs.snowflake.com/en/sql-reference/sql/show-interactive-tables |
| CREATE VIEW | https://docs.snowflake.com/en/sql-reference/sql/create-view |
| ALTER VIEW | https://docs.snowflake.com/en/sql-reference/sql/alter-view |
| DROP VIEW | https://docs.snowflake.com/en/sql-reference/sql/drop-view |
| SHOW VIEWS | https://docs.snowflake.com/en/sql-reference/sql/show-views |
| DESCRIBE VIEW | https://docs.snowflake.com/en/sql-reference/sql/desc-view |
| CREATE MATERIALIZED VIEW | https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view |
| ALTER MATERIALIZED VIEW | https://docs.snowflake.com/en/sql-reference/sql/alter-materialized-view |
| DROP MATERIALIZED VIEW | https://docs.snowflake.com/en/sql-reference/sql/drop-materialized-view |
| SHOW MATERIALIZED VIEWS | https://docs.snowflake.com/en/sql-reference/sql/show-materialized-views |
| DESCRIBE MATERIALIZED VIEW | https://docs.snowflake.com/en/sql-reference/sql/desc-materialized-view |
| TRUNCATE MATERIALIZED VIEW | https://docs.snowflake.com/en/sql-reference/sql/truncate-materialized-view |
| CREATE SEMANTIC VIEW | https://docs.snowflake.com/en/sql-reference/sql/create-semantic-view |
| ALTER SEMANTIC VIEW | https://docs.snowflake.com/en/sql-reference/sql/alter-semantic-view |
| DROP SEMANTIC VIEW | https://docs.snowflake.com/en/sql-reference/sql/drop-semantic-view |
| SHOW SEMANTIC VIEWS | https://docs.snowflake.com/en/sql-reference/sql/show-semantic-views |
| SHOW SEMANTIC DIMENSIONS | https://docs.snowflake.com/en/sql-reference/sql/show-semantic-dimensions |
| SHOW SEMANTIC DIMENSIONS FOR METRIC | https://docs.snowflake.com/en/sql-reference/sql/show-semantic-dimensions-for-metric |
| SHOW SEMANTIC FACTS | https://docs.snowflake.com/en/sql-reference/sql/show-semantic-facts |
| SHOW SEMANTIC METRICS | https://docs.snowflake.com/en/sql-reference/sql/show-semantic-metrics |
| DESCRIBE SEMANTIC VIEW | https://docs.snowflake.com/en/sql-reference/sql/desc-semantic-view |
| CREATE TYPE | https://docs.snowflake.com/en/sql-reference/sql/create-type |
| ALTER TYPE | https://docs.snowflake.com/en/sql-reference/sql/alter-type |
| DROP TYPE | https://docs.snowflake.com/en/sql-reference/sql/drop-type |
| UNDROP TYPE | https://docs.snowflake.com/en/sql-reference/sql/undrop-type |
| SHOW TYPES | https://docs.snowflake.com/en/sql-reference/sql/show-types |
| DESCRIBE TYPE | https://docs.snowflake.com/en/sql-reference/sql/desc-type |
| CREATE SEQUENCE | https://docs.snowflake.com/en/sql-reference/sql/create-sequence |
| ALTER SEQUENCE | https://docs.snowflake.com/en/sql-reference/sql/alter-sequence |
| DROP SEQUENCE | https://docs.snowflake.com/en/sql-reference/sql/drop-sequence |
| SHOW SEQUENCES | https://docs.snowflake.com/en/sql-reference/sql/show-sequences |
| DESCRIBE SEQUENCE | https://docs.snowflake.com/en/sql-reference/sql/desc-sequence |
| Functions, procedures, & scripting | https://docs.snowflake.com/en/sql-reference/commands-function |
| Streams & tasks | https://docs.snowflake.com/en/sql-reference/commands-stream |
| DCM Projects | https://docs.snowflake.com/en/sql-reference/commands-dcm-projects |
| dbt Projects on Snowflake | https://docs.snowflake.com/en/sql-reference/commands-dbt-projects-on-snowflake |
| Classes & instances | https://docs.snowflake.com/en/sql-reference/commands-class |
| Machine learning | https://docs.snowflake.com/en/sql-reference/commands-ml |
| Cortex | https://docs.snowflake.com/en/sql-reference/commands-cortex |
| Listings | https://docs.snowflake.com/en/sql-reference/commands-listings |
| Openflow data plane integration | https://docs.snowflake.com/en/sql-reference/commands-ofdata-plane |
| Organization profiles | https://docs.snowflake.com/en/sql-reference/commands-organization-profiles |
| Security | https://docs.snowflake.com/en/sql-reference/commands-security |
| Data Governance | https://docs.snowflake.com/en/sql-reference/commands-data-governance |
| Privacy | https://docs.snowflake.com/en/sql-reference/commands-privacy |
| Data loading & unloading | https://docs.snowflake.com/en/sql-reference/commands-data-loading |
| File staging | https://docs.snowflake.com/en/sql-reference/commands-file |
| Storage lifecycle policies | https://docs.snowflake.com/en/sql-reference/commands-storage-lifecycle-policies |
| Git | https://docs.snowflake.com/en/sql-reference/commands-git |
| Alerts | https://docs.snowflake.com/en/sql-reference/commands-alert |
| Native Apps Framework | https://docs.snowflake.com/en/sql-reference/commands-native-apps |
| Snowflake App Runtime | https://docs.snowflake.com/en/sql-reference/commands-snowflake-apps |
| Streamlit | https://docs.snowflake.com/en/sql-reference/commands-streamlit |
| Notebook | https://docs.snowflake.com/en/sql-reference/commands-notebook |
| Snowpark Container Services | https://docs.snowflake.com/en/sql-reference/commands-snowpark-container-services |
| Snowflake Postgres | https://docs.snowflake.com/en/user-guide/snowflake-postgres/about |
| Function and stored procedure reference | https://docs.snowflake.com/en/sql-reference-functions |
| Class reference | https://docs.snowflake.com/en/sql-reference-classes |
| Scripting reference | https://docs.snowflake.com/en/sql-reference-snowflake-scripting |
| General reference | https://docs.snowflake.com/en/sql-reference |
| API reference | https://docs.snowflake.com/en/api-reference |
| Reference | https://docs.snowflake.com/en/reference |
| SQL command reference | https://docs.snowflake.com/en/sql-reference-commands |
| Tables, views, sequences, and types | https://docs.snowflake.com/en/sql-reference/commands-table |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#create-external-table |
| external table | https://docs.snowflake.com/user-guide/tables-external-intro |
| ALTER EXTERNAL TABLE | https://docs.snowflake.com/sql-reference/sql/alter-external-table |
| DROP EXTERNAL TABLE | https://docs.snowflake.com/sql-reference/sql/drop-external-table |
| SHOW EXTERNAL TABLES | https://docs.snowflake.com/sql-reference/sql/show-external-tables |
| DESCRIBE EXTERNAL TABLE | https://docs.snowflake.com/sql-reference/sql/desc-external-table |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#syntax |
| CREATE | ALTER TABLE … CONSTRAINT | https://docs.snowflake.com/sql-reference/sql/create-table-constraint |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#variant-syntax |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#create-external-table-using-template |
| COPY GRANTS | https://docs.snowflake.com/sql-reference/sql/create-table#label-create-table-copy-grants |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#required-parameters |
| Identifier requirements | https://docs.snowflake.com/sql-reference/identifiers-syntax |
| Format Type Options | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#label-create-ext-table-formattypeoptions |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#optional-parameters |
| Identifier requirements | https://docs.snowflake.com/sql-reference/identifiers-syntax |
| SQL data types reference | https://docs.snowflake.com/sql-reference-data-types |
| Partitions Added Automatically From Partition Column Expressions | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#partitions-added-automatically-from-partition-column-expressions |
| CREATE | ALTER TABLE … CONSTRAINT | https://docs.snowflake.com/sql-reference/sql/create-table-constraint |
| Constraints | https://docs.snowflake.com/sql-reference/constraints |
| ALTER EXTERNAL TABLE | https://docs.snowflake.com/sql-reference/sql/alter-external-table |
| Work with Amazon S3-compatible storage | https://docs.snowflake.com/user-guide/data-load-s3-compatible-storage |
| ALTER EXTERNAL TABLE … REFRESH | https://docs.snowflake.com/sql-reference/sql/alter-external-table |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#you-must-configure-an-event-notification-for-your-storage-location-to-notify-snowflake-when-new-or-updated-data-is-availableto-read-into-the-external-table-metadata-for-more-information-see-the-instructions-for-your-cloud-storage-service |
| Refresh external tables automatically for Amazon S3 | https://docs.snowflake.com/user-guide/tables-external-s3 |
| Refresh external tables automatically for Google Cloud Storage | https://docs.snowflake.com/user-guide/tables-external-gcs |
| Refresh external tables automatically for Azure Blob Storage | https://docs.snowflake.com/user-guide/tables-external-azure |
| ALTER EXTERNAL TABLE | https://docs.snowflake.com/sql-reference/sql/alter-external-table |
| Refresh external tables automatically for Amazon S3 | https://docs.snowflake.com/user-guide/tables-external-s3 |
| Apache Iceberg™ table | https://docs.snowflake.com/user-guide/tables-iceberg |
| external volume | https://docs.snowflake.com/user-guide/tables-iceberg#label-tables-iceberg-external-volume-def |
| Iceberg tables | https://docs.snowflake.com/user-guide/tables-iceberg |
| CREATE ICEBERG TABLE (Delta files in object storage) | https://docs.snowflake.com/sql-reference/sql/create-iceberg-table-delta |
| Migrate a Delta external table to Apache Iceberg™ | https://docs.snowflake.com/user-guide/tables-external-intro#label-tables-external-intro-migrate-to-iceberg |
| preview feature | https://docs.snowflake.com/release-notes/preview-features |
| ALTER EXTERNAL TABLE … REFRESH | https://docs.snowflake.com/sql-reference/sql/alter-external-table |
| row access policy | https://docs.snowflake.com/user-guide/security-row-intro |
| data metric functions (DMFs) | https://docs.snowflake.com/user-guide/data-quality-intro |
| ALTER TABLE … ADD DATA METRIC FUNCTION | https://docs.snowflake.com/sql-reference/sql/alter-table#label-alter-table-data-metric-function-action |
| Data metric function actions | https://docs.snowflake.com/sql-reference/sql/alter-table#label-alter-table-data-metric-function-action |
| Attach DMFs at creation time | https://docs.snowflake.com/user-guide/data-quality-working#label-dmf-create-with |
| tag | https://docs.snowflake.com/user-guide/object-tagging/introduction |
| Tag quotas | https://docs.snowflake.com/user-guide/object-tagging/introduction#label-object-tagging-quota |
| contacts | https://docs.snowflake.com/user-guide/contacts-using |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#partitioning-parameters |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#cloud-provider-parameters-cloudproviderparams |
| Refresh external tables automatically for Google Cloud Storage | https://docs.snowflake.com/user-guide/tables-external-gcs |
| Refresh external tables automatically for Azure Blob Storage | https://docs.snowflake.com/user-guide/tables-external-azure |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#format-type-options-formattypeoptions |
| loading data into | https://docs.snowflake.com/guides-overview-loading-data |
| unloading data out of | https://docs.snowflake.com/user-guide/data-unload-overview |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#type-csv |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#type-json |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#type-avro |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#type-orc |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#type-parquet |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#access-control-requirements |
| role | https://docs.snowflake.com/user-guide/security-access-control-overview#label-access-control-overview-roles |
| privileges | https://docs.snowflake.com/user-guide/security-access-control-overview#label-access-control-overview-privileges |
| Creating custom roles | https://docs.snowflake.com/user-guide/security-access-control-configure#label-security-custom-role |
| securable objects | https://docs.snowflake.com/user-guide/security-access-control-overview#label-access-control-securable-objects |
| Overview of Access Control | https://docs.snowflake.com/user-guide/security-access-control-overview |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#usage-notes |
| Masking policies and external tables | https://docs.snowflake.com/user-guide/security-column-intro#label-security-column-intro-ext-table |
| Row access policies and external tables | https://docs.snowflake.com/user-guide/security-row-intro#label-security-row-intro-ext-table |
| DROP EXTERNAL TABLE | https://docs.snowflake.com/sql-reference/sql/drop-external-table |
| Metadata fields in Snowflake | https://docs.snowflake.com/sql-reference/metadata |
| POLICY_CONTEXT | https://docs.snowflake.com/sql-reference/functions/policy_context |
| SELECT | https://docs.snowflake.com/sql-reference/sql/select |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#examples |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#partitions-added-automatically-from-partition-column-expressions |
| CREATE STAGE | https://docs.snowflake.com/sql-reference/sql/create-stage |
| TO_DATE , DATE | https://docs.snowflake.com/sql-reference/functions/to_date |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#partitions-added-manually |
| GET_IGNORE_CASE | https://docs.snowflake.com/sql-reference/functions/get_ignore_case |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#materialized-view-on-an-external-table |
| Partitions Added Automatically From Partition Column Expressions | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#partitions-added-automatically-from-partition-column-expressions |
| CREATE MATERIALIZED VIEW | https://docs.snowflake.com/sql-reference/sql/create-materialized-view |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#external-table-created-with-detected-column-definitions |
| INFER_SCHEMA | https://docs.snowflake.com/sql-reference/functions/infer_schema |
| Visit Snowflake | https://www.snowflake.com |
| Join the conversation | https://community.snowflake.com/s/ |
| Develop with Snowflake | https://developers.snowflake.com |
| Share your feedback | https://docs.snowflake.com/feedback |
| Read the latest on our blog | https://www.snowflake.com/blog/ |
| Get your own certification | https://learn.snowflake.com |
| Privacy Notice | https://www.snowflake.com/privacy-policy/ |
| Site Terms | https://www.snowflake.com/legal/snowflake-site-terms/ |
| Snowflake Python APIs | https://docs.snowflake.com/developer-guide/snowflake-python-api/snowflake-python-overview |
| Snowflake REST APIs | https://docs.snowflake.com/developer-guide/snowflake-rest-api/snowflake-rest-api |
| Snowflake CLI | https://docs.snowflake.com/developer-guide/snowflake-cli/index |
| Syntax | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#syntax |
| Variant syntax | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#variant-syntax |
| Required parameters | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#required-parameters |
| Optional parameters | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#optional-parameters |
| You must configure an event notification for your storage location to notify Snowflake when new or updated data is availableto read into the external table metadata. For more information, see the instructions for your cloud storage service: | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#you-must-configure-an-event-notification-for-your-storage-location-to-notify-snowflake-when-new-or-updated-data-is-availableto-read-into-the-external-table-metadata-for-more-information-see-the-instructions-for-your-cloud-storage-service |
| Cloud provider parameters (cloudProviderParams) | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#cloud-provider-parameters-cloudproviderparams |
| Format type options (formatTypeOptions) | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#format-type-options-formattypeoptions |
| Access control requirements | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#access-control-requirements |
| Usage notes | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#usage-notes |
| Examples | https://docs.snowflake.com/en/sql-reference/sql/create-external-table#examples |
| Introduction to external tables | https://docs.snowflake.com/user-guide/tables-external-intro |
| SYSTEM$VALIDATE_STORAGE_INTEGRATION | https://docs.snowflake.com/sql-reference/functions/system_validate_storage_integration |