| DOCUMENTATION | https://docs.snowflake.com |
| English | https://docs.snowflake.com/en/sql-reference/sql/alter-external-table |
| Français | https://docs.snowflake.com/fr/sql-reference/sql/alter-external-table |
| Deutsch | https://docs.snowflake.com/de/sql-reference/sql/alter-external-table |
| 日本語 | https://docs.snowflake.com/ja/sql-reference/sql/alter-external-table |
| 한국어 | https://docs.snowflake.com/ko/sql-reference/sql/alter-external-table |
| Português | https://docs.snowflake.com/pt/sql-reference/sql/alter-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/sql-reference/sql/alter-external-table#alter-external-table |
| CREATE EXTERNAL TABLE | https://docs.snowflake.com/sql-reference/sql/create-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/sql-reference/sql/alter-external-table#syntax |
| ¶ | https://docs.snowflake.com/sql-reference/sql/alter-external-table#parameters |
| CREATE EXTERNAL TABLE | https://docs.snowflake.com/sql-reference/sql/create-external-table |
| CREATE EXTERNAL TABLE | https://docs.snowflake.com/sql-reference/sql/create-external-table |
| ¶ | https://docs.snowflake.com/sql-reference/sql/alter-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 |
| S3-compatible external stage | https://docs.snowflake.com/user-guide/data-load-s3-compatible-storage |
| ALTER EXTERNAL TABLE | https://docs.snowflake.com/sql-reference/sql/alter-external-table |
| ¶ | https://docs.snowflake.com/sql-reference/sql/alter-external-table#partitions-added-and-removed-manually |
| ¶ | https://docs.snowflake.com/sql-reference/sql/alter-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 |
| GRANT OWNERSHIP | https://docs.snowflake.com/sql-reference/sql/grant-ownership |
| 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/sql-reference/sql/alter-external-table#usage-notes |
| BEGIN | https://docs.snowflake.com/sql-reference/sql/begin |
| COMMIT | https://docs.snowflake.com/sql-reference/sql/commit |
| ALTER TABLE | https://docs.snowflake.com/sql-reference/sql/alter-table |
| ALTER TABLE | https://docs.snowflake.com/sql-reference/sql/alter-table |
| CREATE EXTERNAL TABLE | https://docs.snowflake.com/sql-reference/sql/create-external-table |
| ALTER TABLE | https://docs.snowflake.com/sql-reference/sql/alter-table |
| Use SQL to set up data metric functions | https://docs.snowflake.com/user-guide/data-quality-working |
| Metadata fields in Snowflake | https://docs.snowflake.com/sql-reference/metadata |
| ¶ | https://docs.snowflake.com/sql-reference/sql/alter-external-table#examples |
| ¶ | https://docs.snowflake.com/sql-reference/sql/alter-external-table#refresh-metadata-manually |
| ¶ | https://docs.snowflake.com/sql-reference/sql/alter-external-table#add-or-remove-files-manually |
| ¶ | https://docs.snowflake.com/sql-reference/sql/alter-external-table#add-or-remove-partitions-manually |
| 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/sql-reference/sql/alter-external-table#syntax |
| Parameters | https://docs.snowflake.com/sql-reference/sql/alter-external-table#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/sql-reference/sql/alter-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 |
| Access control requirements | https://docs.snowflake.com/sql-reference/sql/alter-external-table#access-control-requirements |
| Usage notes | https://docs.snowflake.com/sql-reference/sql/alter-external-table#usage-notes |
| Examples | https://docs.snowflake.com/sql-reference/sql/alter-external-table#examples |