# Group Schema Query Setup

Set up how the connector queries the JDBC source for account and/or group schema information.

> [!NOTE]
>
> **Screenshot**
>
> [![Query Settings](<https://documentation.sailpoint.com/connectors/jdbc/saas/help/img/query_settings.png>)](<https://documentation.sailpoint.com/connectors/jdbc/saas/help/img/query_settings.png>)

Select the **Edit** icon ![](<https://documentation.sailpoint.com/connectors/jdbc/saas/help/img/query_configure_button.png>) for the schema you want to configure to launch additional settings.

Perform the following tasks to configure the queries for groups, which help with JDBC entitlements.

## Group Connection Settings

Enter the connection information to allow SailPoint to locate and connect to the JDBC server to load group information, as well as any group-related functions.

> [!NOTE]
>
> If these fields are left blank, the connector uses the [Account Connection Settings](<https://documentation.sailpoint.com/connectors/jdbc/saas/help/account_query_settings.html#account-connection-settings>).

> [!NOTE]
>
> **Screenshot**
>
> [![Group Connection Settings](<https://documentation.sailpoint.com/connectors/jdbc/saas/help/img/jdbc_group_conn_saas.png>)](<https://documentation.sailpoint.com/connectors/jdbc/saas/help/img/jdbc_group_conn_saas.png>)

1. Enter the **User Name** required to access the server.
2. Enter the **Password** associated with the user name to access the server.
3. Enter the server's address into the **Database URL** field. The address should be in the following format:

   ```text
   jdbc:<database_type>://<host>:<port>/<database_name>
   ```

   For example:

   ```text
   jdbc:snowflake://sailpoint-conn.snowflakecomputing.com
   ```
4. Enter the **Driver Class**. For example:

   ```text
   net.snowflake.client.jdbc.SnowflakeDriver
   ```
5. Select **Save**.

## Group Query Settings

Configure the SQL queries SailPoint uses to retrieve group data from your JDBC server.

> [!IMPORTANT]
>
> SQL entries can't end with a semicolon (;). Ending an SQL entry with a semicolon (;) can cause a general error message to display.

> [!NOTE]
>
> **Screenshot**
>
> [![Group Query Settings](<https://documentation.sailpoint.com/connectors/jdbc/saas/help/img/jdbc_group1.png>)](<https://documentation.sailpoint.com/connectors/jdbc/saas/help/img/jdbc_group1.png>) [![Group Query Settings](<https://documentation.sailpoint.com/connectors/jdbc/saas/help/img/jdbc_group2.png>)](<https://documentation.sailpoint.com/connectors/jdbc/saas/help/img/jdbc_group2.png>)

1. Enter a SQL query to load groups into the **Group SQL Query** field. Groups are used for entitlements. Check the **Use Stored Procedure for Group SQL Query** box to execute a stored procedure on the database.
2. Enter a SQL query to load a single group into the **Single Group SQL Query** field. Check the **Use Stored Procedure for Single Group SQL Query** box to execute a stored procedure on the database.
3. Select **Save**.

## Additional Group Query Settings

Set additional query settings to support the SQL queries.

> [!IMPORTANT]
>
> SQL entries can't end with a semicolon (;). Ending an SQL entry with a semicolon (;) can cause a general error message to display.

> [!NOTE]
>
> **Screenshot**
>
> [![Additional Group Query Settings](<https://documentation.sailpoint.com/connectors/jdbc/saas/help/img/jdbc_dp.png>)](<https://documentation.sailpoint.com/connectors/jdbc/saas/help/img/jdbc_dp.png>)

1. Check the **Use executeQuery** box to tell SailPoint to return a single ResultSet object when it queries the JDBC database.
2. Enable **Direct Permission** and add the SQL query. For more information, refer to [Direct Permissions](<https://documentation.sailpoint.com/connectors/jdbc/saas/help/account_query_settings.html#direct-permissions>).
3. Select **Save**.