Single Account Aggregation for JDBC

Hi Everyone,

For JDBC connector, is it possible to use other attributes that’s present in the account schema for single account aggregation other than Account ID?

Eg: SELECT * FROM table WHERE email=‘$(identity)’ . Here, $(identity) will get replaced by Account ID. Let’s say I have an attribute called “ABC” in the schema which is not marked as Account ID. Can I use this attribute for the single account aggregation?

Thanks,
Sushant

Hi @Sushant,
For single account aggregation only $(identity) is available. You cannot use other attributes for querying single account.