Good day Community - I have been using Fivetran to export community data into Snowflake and have questions about 2 Tables:
What information do these 2 Tables provide and what does "Session" define?
Thank you, Toby
Hey Toby,
Appreciate you asking us this! From what I can see in the database only the Session table is present of the two you are asking about. That Search option is most likely something that was added with whatever third-party software you are using so I can't see it. I would assume it would be a log of search queries, who made them and at what time.
The session table basically logs when a userID logs into Vanilla and sets them up with a SessionID. That ID then has an expiration time, that can be configured via the Admin Dashboard on the community, that will then automatically log the user out of the site.
