---
sourceDocument: Xanadu Platform Analytics
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/now-intelligence

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu Platform Analytics

ft:clusterId :

    - par

bundleId :

    - par

workflow :

    - Platform


---

# Spotlight database views

# Spotlight database views {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Spotlight ensures that a database view joins the Spotlight \[spotlight\] table and the
facts table whose records the Spotlight group evaluates. You need this database view to use
Spotlight interactive analysis. Administrators can access this database view to create reports or
to diagnose problems.

After creating the database view, Spotlight adds a reference to it in the related Spotlight
Group record on the Spotlight Group \[spotlight_groups\] table. The reference consists of the
primary key field value of the database view, which is in the database_view column of the record.  
Note:  
If you upgrade from an earlier version than London, you start with an empty database_view value in the database_view column of your spotlight_groups records. This empty column has no impact. The column populates as users modify the records in the spotlight_groups table.

If you are an administrator, you can access the database view directly. To see the database
view for a Spotlight Group, click the Show Database View related link on
the Spotlight Group form. You can also add a Database View column to the
Spotlight Groups list.  
If the database view is missing or invalid, an error message appears on the Spotlight Group record. In this case, you can click the Generate Database View related link, which becomes available. A message appears afterwards to inform you whether database generation succeeded.Figure 1. Spotlight group with missing database view  
If you delete a Spotlight group, Spotlight deletes the database view associated with that group if it is safe to do so. To determine whether it is safe to delete the database view, Spotlight checks for the following conditions:

* Do any other Spotlight groups have a reference to that database view?
* Are any other Spotlight groups defined with a main indicator that uses the same facts table as the main indicator of the group that you are deleting?
{#spotlight-analyzing-data__ul_ihx_glm_3cb} If neither condition is true, Spotlight deletes the database view.  
When creating, modifying, or deleting database views, Spotlight runs these business rules:

* Update Database View
* Delete Database View
* Set DB View on Insert
{#spotlight-analyzing-data__ul_exh_sdx_fcb}
**Related topics**   

* [Database views](https://www.servicenow.com/docs/access?context=c_DatabaseViews&version=xanadu&pubname=xanadu-platform-administration&ft:locale=en-US)