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

Was this helpful?

  1. Data Sources
  2. Data Synchronization

Schema Changes

Database schemas are subject to change, and Verb accommodates changes as broadly as possible. The Verb platform will adapt to your schema changes whenever possible. Any changes that we can internally resolve or reconcile will be automatically applied on your behalf.

However, there are times when changes to your schema may result in changes you need to address. Below are a few common examples.

Columns Removed

It's not uncommon for columns to be removed from a database. However your dashboards are built from a schema that, at one point, included the missing column. In this case, you have a few options.

You can use the data source editor to disable a table column. Doing so will prevent any further attempts to ingest data from that column. This option is suitable when models and dashboard collections do not depend on the data in the removed column.

If the data in the removed column is used for reporting in one or more dashboard collections, the data source will need to be updated. You can edit your data source in the same way it was originally created. Verb will rebuild your schema without the deleted column and ingestion will resume with the updated configuration. This option is more aggressive and may result in additional data ingestion (possibly a full re-synchronization depending on your database's schema).

Columns Added

Similar to columns being removed, you will need to inform Verb of newly added columns. You can do so by simply editing your data source and configuring the new column to set type, aggregation, and display values. Once configured, the data for the new column will be ingested. If historical data for this column is important, a full synchronization may be necessary to include all data for the newly added column.

Tables Removed

While column changes are often automated, table changes are not. Your schema as well as the data you synchronize with Verb has a particular "shape." Tables are the element that defines the schema's shape. In SQL terms, tables are used to join between data in various tables and views to produce a data set. If you remove a table from your schema, you will need to edit your data source to allow Verb to rebuild a map of your new schema. Depending on the complexity of your schema, this kind of change likely requires updating your models. Model use a similar "join" structure to understand the path between tables in your schema. Once your data source is updated, you can update your model accordingly. Finally, any dashboard tils that used data from the removed tables will need to be updated. Tiles are build from the models you create, so tile reconfiguration is as simple as selecting the right fields from the model you redefine.

Tables Added

Like adding columns, you will need to inform Verb of newly added tables. You can do so by editing your data source and configuring synchronization interval. Once configured, the data for the new table will be ingested. Data will follow the normal method starting with the oldest records until the data has been fully ingested.

PreviousSynchronization HistoryNextRow Filtering

Last updated 2 years ago

Was this helpful?