Set all external Snowflake tables explicitly to auto_refresh = true.

[j3-signalroom]

AUTO_REFRESH = TRUE | FALSE
Specifies whether Snowflake should enable triggering automatic refreshes of the external table metadata when new or updated data files are available in the named external stage specified in the [ WITH ] LOCATION = setting.

Note

Setting this parameter to TRUE is not supported by partitioned external tables when partitions are added manually by the object owner (i.e. when PARTITION_TYPE = USER_SPECIFIED).

Setting this parameter to TRUE is not supported for external tables that reference data files stored on an S3-compatible external stage. You must manually refresh the metadata by executing an ALTER EXTERNAL TABLE … REFRESH command.

You must configure an event notification for your storage location to notify Snowflake when new or updated data is available to read into the external table metadata. For more information, see the instructions for your cloud storage service:

Amazon S3
Refreshing external tables automatically for Amazon S3

Google Cloud Storage
Refreshing external tables automatically for Google Cloud Storage

Microsoft Azure
Refreshing external tables automatically for Azure Blob Storage

When an external table is created, its metadata is refreshed automatically once unless REFRESH_ON_CREATE = FALSE.

TRUE
Snowflake enables triggering automatic refreshes of the external table metadata.

FALSE
Snowflake does not enable triggering automatic refreshes of the external table metadata. You must manually refresh the external table metadata periodically using ALTER EXTERNAL TABLE … REFRESH to synchronize the metadata with the current list of files in the stage path.

Default: TRUE