page168
254
•
There are three costs:
•
Initial build costs of 10.8 credits.
•
Storage costs of 0.14TB/month, which will vary according to DML
operations.
•
Monthly maintenance costs, which will vary according to DML
operations.
•
Estimates were derived from approximately the past seven days of
activity; in this example, zero activity occurred.
As you can see from this information, recent historical DML operations against
our target table will affect estimated numbers. Furthermore, the activity period may be
affected by the Time Travel setting.
the generated costs are for the table.
I recommend search optimization costs are derived from real-world usage and not
from local testing.
after initially enabling SOS, monitor the costs closely.
For every SOS-enabled table and attribute, costs should be monitored on a periodic
basis to ensure costs remain within budget appetite.
Enabling Table Search Optimization
Assuming the estimated costs are within the budget appetite and the role is entitled, to
enable SOS for an individual table, do this:
ALTER TABLE tpc.tpc_owner.lineitem_baseline ADD SEARCH OPTIMIZATION;
Enabling search optimization does not imply the Snowflake SOS background service
is immediately invoked; you are likely to experience a delay before search optimization is
available. To determine whether the Snowflake SOS background service has completed,
you must rerun this query:
Chapter 7
SearCh OptimizatiOn ServiCe