Write it explicitly.
Express the filters, joins, and calculations your analysis needs.
Coming later
Your Lake. Your queries. Your workspace.
Write SQL against FastBI Lake, inspect results, and explore the relationships in your data. Take a useful query from investigation to a recurring job.
THE LAKE SQL WORKSPACESample queries and results · no live execution
SELECT order_id, customer_id, total
FROM lake.orders
ORDER BY order_id
LIMIT 3;Source: lake.orders
EXAMPLE RESULT · 3 ROWS
| order_id | customer_id | total |
|---|---|---|
| 1001 | C-014 | 120.00 |
| 1002 | C-028 | 85.00 |
| 1003 | C-014 | 65.00 |
01Write a query
Start with SELECT. See where it takes you.
Explore a table, compare periods, or join datasets. SQL gives you a direct way to ask precise questions of the data in Lake.
Inspect the result.
Work through the rows behind the headline number.
Refine the question.
Adjust the query as you learn more about the data.
02Go deeper
The next question is one query away.
Move from a quick check to a deeper investigation without exporting your data into another tool.
Explore relationships.
Join Lake datasets to connect customers, events, and transactions.
Build useful summaries.
Aggregate raw records into the shape your analysis needs.
Keep the logic visible.
Use explicit SQL to make calculations easy to inspect.
03Make it repeatable
Found a useful query? Give it a future.
Pair SQL with Jobs when the same transformation needs to run again. Use the resulting Lake tables in Analysis and reports.
SQL
Develop the query.
Jobs
Schedule the recurring transformation.
Analysis
Explore the resulting Lake tables.
Get notified about SQL
Join the waitlist for early access.