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
  • Primary and Foreign Keys
  • Composite Keys

Was this helpful?

  1. Models
  2. Advanced Model Information

Database Keys

Primary and Foreign Keys

Verb honors foreign keys from structured databases and between objects on unstructured data.

The primary keys and foreign keys defined in your database will be kept and are required for functions such as Calculated Columns or Aggregated Measures.

Composite Keys

Create multiple relationships between tables and both will be used when querying data. This relationship is Composed of multiple columns and is sometimes necessary based on developer decisions and your structure.

PreviousAdvanced Model InformationNextUnstructured Data

Last updated 3 years ago

Was this helpful?