Query Lake data

Use the SQL workbench to query data available in FastBI Lake. Select a table in Data explorer, check its columns, and copy its full connector.dataset.table name.

Query a table

SELECT country, SUM(revenue) AS revenue
FROM lake.uploads.orders
WHERE status = 'completed'
GROUP BY country
ORDER BY revenue DESC
LIMIT 100;

Here, lake is the connector, uploads is the dataset, and orders is an example table. Replace the table and columns with entries in your catalog.

Check readiness and access

Your account needs access to the table. For a new upload or synchronization, wait until preparation completes before querying the full dataset. A preview does not necessarily mean all rows are ready.

If a table is missing, check the selected organization, source access, and its latest job status. See Jobs for progress and errors.

Keep queries focused

Select the columns you need and use a reporting date range. Use Explain to review the query before running a large calculation. A row limit controls the result size; it does not guarantee a smaller scan or lower cost.

FastBI may request confirmation for a large scan. Access, usage limits, and available funding still apply after confirmation. See pricing examples and usage controls.

Read and save results

The workbench displays results in pages. A conversation preview may show fewer rows than the complete query result. Calculate totals in SQL rather than adding up preview rows.

Download or save an available result before it expires. Save to Lake creates a snapshot, not an automatically refreshed table. See results and limits for details.

Combine Lake with other sources

Join Lake data with connected tables using their full catalog names. Confirm matching key types, currency, timezone, and row granularity before comparing totals. Follow the cross-source guide for examples.