Field present under "Show XML" but missing in dictionary

Nisar3 · ‎01-08-2025

In a table record, I can see a column u_latitude when I click "Show XML"

But if I go to Configure->Table, then I do not see it listed there

Any idea why this could be happening?

Nisar3 · ‎01-15-2025

Turns out it's an issue with deleted columns.

sys_storage_alias table will contain the field details. One will need to filter on element_name (column name) and table and delete it. If user is unable to delete it, he/she will need to raise a ticket with SNOW and they will do it via CHG.

View solution in original post

jcmings · ‎01-08-2025

Is this a child table by any chance? Maybe the field exists on the parent table.

Nisar3 · ‎01-08-2025

It is a child table but the parent table does not contain that field as well.

If it's worth anything, I also noticed that the labels for these fields do not show up in the "Filter" as well on the list view of the table

So that makes me believe something is definitiely not configured correctly in the system.

jcmings · ‎01-09-2025

Longshot here, but maybe a caching issue? Try clearing your cache (cache.do).

Nisar3 · ‎01-09-2025

Had tried that already before posting here. No luck.