Sets your session compute group.
- SET SESSION COMPUTE GROUP Syntax
- SET SESSION COMPUTE GROUP Syntax Elements
- Example: Show Session Compute Group
VantageCloud Lake checks if your query can run on a compute cluster and if you can access the session compute group, and runs your query on the primary cluster or compute cluster as follows:
| Query Can Run on Compute Cluster | You Can Access Session Compute Group | Where Query Runs |
|---|---|---|
| No | Primary cluster | |
| Yes | Yes | Active compute cluster in session compute group, if there is one; otherwise, primary cluster. |
| Yes | No You get a warning. |
Active compute cluster in your user profile compute group, if there is one; otherwise, active compute cluster in your default compute group, if there is one; otherwise, primary cluster. |