Skip to content

Instantly share code, notes, and snippets.

@monimiller

monimiller/snapshot.md

Created August 4, 2022 00:28
Show Gist options
  • Save monimiller/8dd285f911c32eb574c5ccc5cb18c6aa to your computer and use it in GitHub Desktop.
Save monimiller/8dd285f911c32eb574c5ccc5cb18c6aa to your computer and use it in GitHub Desktop.
Download ZIP
Raw
snapshot.md 
ALTER TABLE <GALAXY_DESTINATION_TABLE_NAME>
   EXECUTE expire_snapshots(retention_threshold => '7d');

-- Daily Example:
ALTER TABLE test_table
   EXECUTE expire_snapshots(retention_threshold => '7d');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment