Spotlight database views
-
- UpdatedJan 30, 2025
- 2 minutes to read
- Yokohama
- Spotlight
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.
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.

- 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?
- Update Database View
- Delete Database View
- Set DB View on Insert