---
sourceDocument: Yokohama Enable AI
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/intelligent-experiences

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Enable AI

ft:clusterId :

    - platai

bundleId :

    - platai

workflow :

    - Platform


---

# Database View support for Predictive Intelligence

# Database View support for Predictive Intelligence {#ariaid-title1}

Release version: Yokohama  
Updated January 30, 2025  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read
Summarize  
![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI  
This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.  

## Summary of Database View support for Predictive Intelligence

ServiceNow's Predictive Intelligence now supports using database views as input for machine learning (ML) solutions.
Database views allow you to join two or more tables into a single consolidated view, expanding the amount of data fields available for training your ML models.
This capability enhances the richness of input data, improving the quality of predictions and classifications.
Show full answer Show less  

## Key Features

* **Use of Database Views:** You can create database views that combine multiple tables and use these views directly in ML solution definitions.
* **Support Across ML Frameworks:** Database views are supported in all four Predictive Intelligence frameworks---classification, similarity, clustering, and regression.
* **Example with Similarity Solutions:** In similarity solutions, instead of selecting a single table, you select a database view to increase the volume and variety of records processed during training.
* **Record Minimums:** Each table within a database view must meet a minimum record threshold (default 10,000 records) to be effectively used in ML training. This ensures sufficient data for reliable model performance.

## Practical Application for ServiceNow Customers

By leveraging database views in your Predictive Intelligence solutions, you can:

* Combine data from multiple related tables into a single, richer dataset for training ML models.
* Improve outcomes by enabling your ML models to analyze more comprehensive data, such as multiple Knowledge Base article types in one view.
* Configure similarity solutions to compare records across multiple tables simultaneously, enhancing their ability to find relevant matches.

To implement this, first create the required database view in your ServiceNow instance. Then, select this view in your ML solution setup (e.g., in the Table field of similarity definitions) instead of a single table. Ensure each underlying table meets the minimum record count, or contact ServiceNow Customer Support to adjust this threshold if necessary.  
Use database views to join two or more tables as input for your Machine Learning (ML)
solution.

## Using database views in an ML solution {#database-view-support-predictive-intelligence__section_f3q_rvj_2mb}

Database views help expand the amount of fields your solution can use for training. By using
more than one table in your ML solution definition form, you can access more input data to help
enrich the solution outcome.

Database views enable you to join two or more tables into one consolidated view. For this to
work in an ML solution you must first create the database view. See [Database views](https://www.servicenow.com/docs/access?context=c_DatabaseViews&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US).

Database views are supported in all four of the Predictive Intelligence capability
frameworks: classification, similarity, clustering, and regression.

## A database view example for Predictive Intelligence {#database-view-support-predictive-intelligence__section_tsg_yj4_dmb}

In the following example scenario, you've created a database view for use in an ML similarity
solution. The image below shows the database view record you've created, including its
Name and Label.

When you click the record Name, its content appears, as shown in the
image below. Within the database view content, the five Knowledge Base tables you've joined
to the view are listed. Most of these tables contain different Knowledge article template
types, such as an FAQ or a How To article.

When a database view is used as input to a similarity solution, each of the tables that
constitute the view must have at least the required number of records set in the configuration
of your ServiceNow instance. The default minimum number required is
10,000. For example, the Knowledge View database view has five tables and
each table must have 10,000 records. If a table doesn't have 10,000 records, you may not see the
results from that table. If you must change that value, contact Customer Support.

In the image below you can see the similarity solution definition record you've already
created, which you plan to associate to your database view. When you click the
Label for your similarity record, its Similarity Definition form
appears.

Similarity Definition forms compare your existing table records based on their similarity by
using a table in the Table field and another table in the Test Table field.

To use a database view in your similarity solution, instead of selecting a table in the
Table field, you select the database view you created, which in this
example scenario is the Knowledge View database view. This configuration
increases the number of records your solution uses in training because the system compares and
processes five tables of data instead of one.