page159
142
•
Deleting an external stage does not remove files contained within
the external stage.
•
Incorrectly setting object data retention periods leads to excessive
storage retention.
•
Using permanent tables where transient or temporary tables are
more cost effective.
•
Database and object explosion where new environments are cloned
for regression testing but never deleted.
•
Cloning and Time Travel:
•
These make object retention too easy, leading to bad practices.
•
Reduced storage requirements when judiciously used for creating
development and test environments.
Where the cost is zero, the demand is infinite. My observation is that controlling
costs are typically focused on credit consumption and not on managing storage
costs. Universally CSP storage is cheap, roughly $23/TB at the time of writing, though
this figure is CSP and region specific. For small data footprints, the costs are almost
insignificant, but at petabyte scale, the costs quickly escalate.
As your Snowflake usage increases and environment matures, I suggest the
following:
•
Implementing central storage monitoring
•
Adopting guidelines for “acceptable use” of cloning and Time Travel
•
Periodically reviewing environments to mitigate against
increasing storage
•
In multi-tenant environments, cross-charging each tenant for their
storage in addition to their runtime consumption
ChaPTer 4
MiCro-ParTiTionS