Automatisiertes Aktualisieren der Metadaten von Verzeichnistabellen¶

The metadata for a directory table can be refreshed automatically using the following event notification service for each cloud storage service:

• Amazon S3: Amazon SQS (Simple Queue Service)

• Google Cloud Storage: Google Cloud Pub/Sub

• Microsoft Azure: Microsoft Azure Event Grid

The refresh operation synchronizes the metadata with the latest set of associated files in the external stage and path, i.e.:

• Neue Dateien im Pfad werden zu den Tabellenmetadaten hinzugefügt.

• Changes to files in the path are updated in the table metadata.

• Dateien, die sich nicht mehr im Pfad befinden, werden aus den Tabellenmetadaten entfernt.

For setup instructions, see the topic for the cloud storage service where your files are located.

The following table indicates which cloud storage services are supported for automatically refreshing directory table metadata to your Snowflake account, based on the cloud platform that hosts your account:

As the table indicates, cross-cloud support is currently only available to accounts hosted on Amazon Web Services.

Nächste Themen: