LogoLogo
Home
  • Verb Documentation
  • Release Notes
  • Environment Settings
    • Authentication
      • Authentication Endpoint
  • Data Sources
    • Ingestion Methods
    • Table Sync Intervals
    • Data Source Integrations
      • Network Permissions
      • Microsoft SQL Server
      • PostgreSQL
      • MongoDB
      • Snowflake
      • Elasticsearch
      • DynamoDB
      • Google BigQuery
      • Firebase Cloud Firestore
      • Supabase
      • Cloud Files
      • Flat Files
    • Data Synchronization
      • Synchronization Methods
        • Full Synchronization
        • Incremental Synchronization
        • Change Tracking
        • Change Data Capture
      • Synchronization Intervals
      • Synchronization Status
        • Pausing and Resuming
      • Synchronization History
      • Schema Changes
      • Row Filtering
      • Schemaless & NoSQL
      • Managing Connections
      • Troubleshooting
  • Models
    • What is a Model
      • Elements of a Model
      • Model Management
    • Building a Model
      • Add/Remove Data
      • Relationships
      • Row-Level Security
      • Transformations
    • Advanced Model Information
      • Database Keys
      • Unstructured Data
      • Publishing Updates
      • Troubleshooting
      • Automatic Modeling
  • Data Transformations
    • What is a Transformation
      • Elements of a Transformation
      • Transformation Management
    • Building Transformations
      • Creating Transformations
      • Configure Transformation Steps
      • Transformation Steps
        • Calculator
        • Manipulate Text
        • Map Values
        • Remove Duplicates
        • Date Operation
        • Select Columns
        • Change Type
        • Group Data
        • Filter Data
        • Join Data
        • Append Rows
        • Pivot Data
        • Rank Data
        • Window Data
      • Complete and Publish
  • Collections
    • What is a Collection
      • Elements of a Collection
    • Building Collections
    • API Collections
      • Building API Collections
        • Connect Data Sources
        • Data Model
        • Select Data
        • Authentication and Security
        • Data Access API Keys
        • Data Access API Documentation
      • API Collection Versions
    • Advanced Collection Options
      • Time Zones
      • Currency Symbols
  • Tiles
    • What is a Tile
      • Elements of a Tile
    • Tile Management
      • Tile Data
    • Tile Actions
    • Custom Date Formats
    • Currency Conversion
  • Design Themes
    • What is a Design Theme
    • General Theme Settings
    • Data Visualization Settings
  • Account Settings
    • Integrations
      • Slack
  • Legal
    • Terms of Use
    • Privacy Policy
    • Subscription Agreement Terms
    • Subscription Agreement
    • Data Processing Addendum
Powered by GitBook
On this page
  • Select Tables
  • Relationships
  • Transformations (ELT Pipeline)

Was this helpful?

  1. Collections
  2. API Collections
  3. Building API Collections

Data Model

The second step in creating a Data Access API

PreviousConnect Data SourcesNextSelect Data

Last updated 3 years ago

Was this helpful?

The data model in Verb defines what tables will be available to select from and the relationship paths that connect tables and data sources. You may also create data transformations and store these as new views in the model or add them as columns to existing tables.

The tables added to a model are not automatically available to end-users of the API. Configuring the fields available via API will be done in the next step, selecting data.

Select Tables

The first step in creating your model is to add tables to the canvas. To do this, select "add" on the table or "Add All" on the data source level to drop the tables you want onto the canvas. Tables on the canvas are will be available in the model when creating a collection.

If you're modeling with unstructured data Verb treats each object as a table so that relationships can be created across sources.

Relationships

Relationships are created between tables by selecting the fields to match on. Verb honors foreign keys from structured databases and between objects on unstructured data.

To create a new relation select a table on the canvas or left panel, using the 'options' button. In the table options panel select manage relationships. You'll see;

  • Suggested Relationships - These are inherited from you data source.

  • Existing Relationships - Relationships established on the model already.

  • Create Relationships - Where you'll be able to connect fields from different tables in the model.

Transformations (ELT Pipeline)

Visually define and sequence operations using Verb’s drag-and-drop transformation builder - no-code required. You may add new columns to existing tables or create new data views. A table must be added to the model in order for the data to be available in transformations.

If you have these transformations pre-built you can share them as part of the ingestion process and they will function just as a normal table or field.

To set a transformation live you'll need to publish the transformation. If edits are made you may publish the updates when ready.

Select "Add" on the table or data source to add to the model
Creating a new relationship across data sources
Create new columns or views with transformations