Configure Egress Cost Optimizer¶
If you’re a provider, you can use Cross-Cloud Auto-Fulfillment (auto-fulfillment) for a listing to automatically replicate your data product to other Snowflake regions without having to manually replicate data.
This section describes how to authorize multi-region sharing and enable and disable Egress Cost Optimizer (ECO) for your organization.
Enabling Egress Cost Optimizer¶
You can enable or disable ECO at the account level. Where an auto-fulfillment schedule is set, ECO will be enabled on all the listings in a database that follow the account schedule.
Enable or disable ECO for an entire account¶
After ECO is authorized at the organization level, enable or disable ECO for an account by doing the following:
In the navigation menu, select Data Products » Provider Studio.
Select the Settings tab.
In the Cross-Cloud Auto-Fulfillment pane, click the toggle next to Egress Cost Optimizer to enable or disable ECO.
You can enable egress cost optimization by executing the ALTER ACCOUNT command to set the ENABLE_EGRESS_COST_OPTIMIZER parameter to TRUE:
ALTER ACCOUNT SET ENABLE_EGRESS_COST_OPTIMIZER=TRUE;
To disable egress cost optimization, set the ENABLE_EGRESS_COST_OPTIMIZER parameter to FALSE:
ALTER ACCOUNT SET ENABLE_EGRESS_COST_OPTIMIZER=FALSE;
For more information see ALTER ACCOUNT.
Limitations of ECO¶
Incremental data ingestion is required for the cloud cache to be fully used by the egress cost optimizer.
The cloud cache is only used by the egress cost optimizer for refreshes made by auto-fulfillment.
Egress cost optimizer will only use the cloud cache if the overall egress costs for all listings on the same database are getting optimized. The optimizer algorithm measures the size of the listings at a database level and not at a table level.