docs for schema/column definitions of SNOW tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Friday
Hi,
Where can I get docs for schema/column definitions of below SNOW tables.
sn_customerservice_case
sn_customerservice_escalation
sn_customerservice_u_case_esc_sla
incident
incident_sla
I am working on some Analytics on Historical customer service related data and might need to see definitions of more tables in future to accurately understand what data each column contains.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
The columns are defined on-platform in table [sys_dictionary]. incident_sla for example is just a database view of task_sla and incident and will join these two tables together.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
everything is available in docs for these tables and what they are being used for
-> sn_customerservice_case (OOTB table to store CSM Case)
-> sn_customerservice_escalation (OOTB table to store Escalations related to CSM Case)
-> incident (OOTB table to store incidents raised by end users)
-> incident_sla (OOTB Database view table joining incident and task_sla table)
-> sn_customerservice_u_case_esc_sla (Seems to be a custom table or a database view table in your instance)
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
43m ago
Thank you for marking my response as helpful.
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader