Espresso AI: Savings Estimate
Espresso AI uses Generative AI to save up to 70% on Snowflake.
We're excited to find out what your Snowflake bill will look like with Espresso!
How do I get an estimate?
We need a few things to generate the estimate: query logs, warehouse metadata, and Snowflake usage history.
The fastest way to share those is to set up a Snowflake account for Espresso. You can do that with our onboarding instructions.
If you'd prefer to send over the logs without setting up an account, please run each of the following commands as an admin user in a Snowflake SQL worksheet and share the output with us. You can email the logs to savings@espresso.ai.
If the logs are too large to email, you can also use a Snowflake data share. Please click here for instructions.
Query Logs:
SELECT *
FROM snowflake.account_usage.query_history
WHERE start_time > dateadd(
'day', -90, current_timestamp())
ORDER BY start_time;
Warehouse Info:
SHOW WAREHOUSES;
Warehouse Event History:
SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_EVENTS_HISTORY
ORDER BY TIMESTAMP;
Warehouse Usage History:
SELECT * FROM TABLE(INFORMATION_SCHEMA.WAREHOUSE_METERING_HISTORY(
DATEADD('days', -90, CURRENT_DATE())));
If you have any questions, please don't hesitate to contact us.