Observe Lake usage.
Look for repeated scans, joins, and aggregations.
Coming later
Do the heavy work once. Make every report lighter.
Schedule jobs on FastBI Lake. AI analyzes Lake usage and recommends intermediate tables so repeated reports can scan less data and return answers sooner.
LET USAGE INFORM THE NEXT TABLEIllustrative optimization workflow
OBSERVE USAGE
Find the repeated calculation.
Several reports group raw orders by day and customer. AI identifies that repeated work in Lake usage.
lake.orders → group by day + customer01Find repeated work
Your query history points to the next improvement.
When reports repeatedly scan the same raw data, AI can identify shared calculations and recommend an intermediate table worth building.
Recommend a table.
Capture useful intermediate results in a reusable Lake table.
Reuse the work.
Let recurring reports query the prepared data.
02Keep tables fresh
A useful table needs a useful schedule.
Run jobs to create, replace, or append tables. Balance freshness with the cost of rebuilding the data your reports depend on.
Create
Build a new intermediate dataset from a query.
Replace
Rebuild a table for a fresh view of the source data.
Append
Add new results with logic that handles the right time window.
03Understand the savings
Scan less. Leave less work for the report.
A smaller prepared table can lower query costs and report latency. The tradeoff is the work needed to refresh and store that table.
EXPLORE A SIMPLE EXAMPLE
When does preparing a table pay off?
Assume each report scans 100 GB of raw data, or 1 GB from an intermediate table. A daily refresh scans the original 100 GB once.
Illustrative scan cost at the published Lake rate of $5/TB, using 1,000 GB/TB. Excludes storage and Jobs fees. Actual savings and latency depend on workload and refresh strategy.
QUERY RAW DATA EACH TIME$10.00/day in scan costs
2,000 GB scanned
REFRESH ONCE + QUERY THE SUMMARY$0.60/day in scan costs
120 GB scanned, including refresh
Less repeated processing.
Reuse an aggregation instead of recalculating it for each report.
Freshness on your terms.
Choose a schedule that fits when new answers are needed.
Measure the whole cost.
Include refresh scans and table storage when evaluating the benefit.
Get notified about Jobs
Join the waitlist for early access.