Models are designed to define and organize data, simplifying the process of querying from various sources.This guide outlines the process of creating a model, from selecting a data source to defining the model using various methods such as SQL queries, table selectors, or dbt models.
Creating a model in AI Squared involves a series of steps designed to streamline the organization of your data for efficient querying. This overview will guide you through each step of the process.
Essential Configuration:
Every model in AI Squared must be configured with a unique primary key.
This primary key is pivotal for uniquely identifying each record in your dataset.
Configuring the Primary Key:
During the final step of model creation, select a column that holds unique values from your dataset.
Ensuring the uniqueness of this primary key is crucial for the integrity and accuracy of data synchronization.
Importance of a Unique Key:
A unique primary key is essential for effectively managing data synchronization.
It enables the system to track and sync only the new or updated data to the designated destinations, ensuring data consistency and reducing redundancy.
After completing these steps, your model will be set up and ready to use.