Verify Resource Group Configuration

After configuring directory authentication and resource groups, verify that users can authenticate and that their queries are assigned to the expected resource groups.

Connect to Trino

Connect to Trino as a user who belongs to one of the configured directory groups:

trino --server https://<trino-coordinator-host>:<trino-coordinator-port> \ --user <directory_user> \ --password \ --catalog <catalog_name> \ --schema <schema_name>

Run a Test Query

Run a query against your configured data source.

For example, you can create a sample table, insert data, and query the table to verify that queries execute successfully. The source provides Hive-backed sample SQL for this purpose.


Verify Resource Group Assignment

Run the following query while the test query is running or after it completes:

SELECT query_id, user, resource_group, query FROM system.runtime.queries WHERE user = '<directory_user>';

Verify that the resource_group value corresponds to the resource group mapped to the user's directory group.

For example:

["global", "<pool_1_name>"]

Repeat the test with users from different directory groups to verify that each user is assigned to the expected resource group. You can also run multiple concurrent queries to verify the configured concurrency and memory limits.



  Last updated