Refresh visits_view Table's SQL Source After Removing Attribute from AudienceDB

[stephilippou]

Is there a way to refresh the visit_view table's SQL source after removing an attribute from AudienceDB?

For example, we removed the metric attribute 9822 from our AudienceDB and published the profile. As expected, we can no longer see the column visits.metric_9822 in the visits table:

However, we can no longer access the visits_view table and it appears all the columns are blank:

The issue is that the SQL source for the visits_view table is still looking for visits.metric_9822 event though it has been deleted:

If we can't rebuild the visits_view table, we'll have to spend a lot of time updating our scripts to use visits instead. Is there any way to refresh the visits_view table after removing an attribute from AudienceDB? I imagine people remove attributes from AudienceDB all the time so I'm surprised I didn't find any other posts on this but this is very important for us.

Thanks for any help!

[mark_reddin]

@stephilippou Please reach out to support@tealium.com on this topic.

[stephilippou]

Ok thank you Mark I created a support ticket #113329

[stephilippou · Accepted solution]

I contacted support and the visits_view table should automatically refresh so this issue is a bug.

A workaround is to do another publish, specifically an "empty publish", of your Tealium profile. This means simply publish your profile a second time and make no changes before doing so. That resolved the issue for us.