# How to get partial\_unexpected\_index\_list in case of snowflake database?

**URL:** <https://discourse.greatexpectations.io/t/how-to-get-partial-unexpected-index-list-in-case-of-snowflake-database/662>\
**Category:** Archive\
**Created:** [March 10, 2021, 10:22am UTC](https://discourse.greatexpectations.io/t/how-to-get-partial-unexpected-index-list-in-case-of-snowflake-database/662 "2021-03-10T10:22:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Garima93](https://avatars.discourse-cdn.com/v4/letter/g/96bed5/32.png) [@Garima93](https://discourse.greatexpectations.io/u/Garima93)\
**Post date:** [March 10, 2021, 10:22am UTC](https://discourse.greatexpectations.io/t/how-to-get-partial-unexpected-index-list-in-case-of-snowflake-database/662/1 "2021-03-10T10:22:24Z")

</div>

We are working with snowflake data base and we want to identify the record uniquely, wwe are getting the unexpected value in json file, but there is no way to identify the record uniquely.

Can you please help in this

---

<div class="post-metadata">

**Author:** ![eugene.mandel](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/eugene.mandel/32/22_2.png) [@eugene.mandel](https://discourse.greatexpectations.io/u/eugene.mandel)\
**Post date:** [March 22, 2021, 4:18pm UTC](https://discourse.greatexpectations.io/t/how-to-get-partial-unexpected-index-list-in-case-of-snowflake-database/662/2 "2021-03-22T16:18:31Z")

</div>

@Garima93 partial\_unexpected\_index\_list is supported only for Pandas, since DataFrames have an index. It is not supported for SQL databases. How would you suggest to identify records that did not meet expectations in a table?