# JDBC Connector - Single Account Query?

**URL:** <https://developer.sailpoint.com/discuss/t/jdbc-connector-single-account-query/28186>\
**Category:** SHF Discussion and Questions\
**Tags:** identity-security-cloud\
**Created:** [January 30, 2024, 5:44pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-connector-single-account-query/28186 "2024-01-30T17:44:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![moss\_snake\_01](https://avatars.discourse-cdn.com/v4/letter/m/2acd7d/32.png) [@moss\_snake\_01](https://developer.sailpoint.com/discuss/u/moss_snake_01)\
**Post date:** [January 30, 2024, 5:44pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-connector-single-account-query/28186/1 "2024-01-30T17:44:38Z")

</div>

Hello,

I am curious how the Single Account Query in “Query Settings” is utilized? I see that it is not a required field, but I thought this was used to compare attributes from the target system. I’ve been using this document for reference ([Query Settings](https://documentation.sailpoint.com/connectors/identityiq8_3/jdbc/help/integrating_jdbc/account_query_settings.html)) but it was unclear.

Does this get fired for only individual account attribute syncs?

---

<div class="post-metadata">

**Author:** ![kjakubiak](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/kjakubiak/32/7052_2.png) [@kjakubiak](https://developer.sailpoint.com/discuss/u/kjakubiak)\
**Post date:** [January 30, 2024, 5:50pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-connector-single-account-query/28186/2 "2024-01-30T17:50:45Z")

</div>

Check this

[https://documentation.sailpoint.com/connectors/jdbc/help/integrating\_jdbc/loading\_single\_account\_group.html?Highlight=Single%20account](https://documentation.sailpoint.com/connectors/jdbc/help/integrating_jdbc/loading_single_account_group.html?Highlight=Single%20account)

---

<div class="post-metadata">

**Author:** ![amishra97](https://avatars.discourse-cdn.com/v4/letter/a/50afbb/32.png) [@amishra97](https://developer.sailpoint.com/discuss/u/amishra97)\
**Post date:** [January 30, 2024, 8:40pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-connector-single-account-query/28186/3 "2024-01-30T20:40:28Z")

</div>

Hi @moss_snake_01  
It is used when you do single account aggregation for a jdbc application.

---

<div class="post-metadata">

**Author:** ![moss\_snake\_01](https://avatars.discourse-cdn.com/v4/letter/m/2acd7d/32.png) [@moss\_snake\_01](https://developer.sailpoint.com/discuss/u/moss_snake_01)\
**Post date:** [January 31, 2024, 1:25am UTC](https://developer.sailpoint.com/discuss/t/jdbc-connector-single-account-query/28186/5 "2024-01-31T01:25:12Z")

</div>

Oh, I’m being dense, the single account query correlates to the “Aggregate Account” action for the identity itself when viewed from Identity List / Accounts. Thank you for the clarification!

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [March 31, 2024, 1:26am UTC](https://developer.sailpoint.com/discuss/t/jdbc-connector-single-account-query/28186/6 "2024-03-31T01:26:11Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.