The following uses an example to show how a query is processed on VantageCloud Lake.
A social media analysis company has one environment with three different departments:
The user, Jane, is the Data Analyst in the Exploration Department. Her administrator assigned her to her department's compute group. For instructions on how to do this, see Granting Users Access to Compute Clusters.
The user is running a query that accesses four tables. Two tables are stored in block storage on the primary cluster, one table is stored in external object storage, and one table is stored in the Object File System.