To direct queries to a specific cluster, set the cluster at the role level using the following SQL statement:
ALTER ROLE <your_user> SET CLUSTER = <custom_cluster>;
Replace <your_user> with the name of your Materialize role and <custom_cluster> with the name of the cluster you want to use.
Once set, all new sessions for that user will automatically run in the specified cluster, eliminating the need to manually specify it in each query or connection.
## Execute and visualize a query 1. Create a new SQL cell. 2. Inside the cell, select the new **Materialize** connection and paste the following query: ```mzsql SELECT number, row_num FROM ( SELECT power(series_number, 2) AS number, row_number() OVER (ORDER BY series_number ASC, series_number DESC) AS row_num FROM ( SELECT generate_series(0, 1000) AS series_number ) AS subquery ); ``` This query generates a series of 1000 numbers squared and assigns row numbers to each. 3. Click the **Run** button. 4. Inside the cell, click the **Chart** button and configure as follows: 1. In the **X Axis** options, select the **row_num** column. 2. In the **Y Axis** options, select the **number** column.