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
  • Add Transformation to Model Canvas
  • Remove Data View from Model Canvas
  • Delete Transformation
  • Naming Transformations
  • Publishing Transformations

Was this helpful?

  1. Data Transformations
  2. What is a Transformation

Transformation Management

PreviousElements of a TransformationNextBuilding Transformations

Last updated 3 years ago

Was this helpful?

Add Transformation to Model Canvas

Add a completed and published transformation as a Table by dragging the Data view onto the Model canvas or selecting the Add button on the data view row.

Calculated Columns and Aggregated Measures are included in the parent table and are available as long as the parent table remains on the canvas.

Remove Data View from Model Canvas

Remove the Data View from the Model Canvas by selecting the Data View Menu, opening More Options and selecting Remove Table.

Delete Transformation

Deleting the transformation is done within the transformation editing canvas by selecting Delete Column, or Delete Data View on the right panel within the transformation.

A confirmation modal will display listing potentially impacted collections which use the transformation.

Note: Models which are used in collections cannot be deleted, and transformations used in collections are similarly linked.

Naming Transformations

The transformation name is the value provided to the Transformation Output. An automatically generated name will be provided upon connection to the Output tile and the Output Tile will switch from Incomplete (red) to Valid (black) once it is properly connected.

Input the desired Transformation Name on the right panel of the Output.

A valid set of transformation step(s) and Input must be connected to the Output to be able to input a name value on the right panel.

Publishing Transformations

Publishing a transformation makes it accessible on the model canvas and confirms there are no data transformation errors.

When transformations are edited and updated, they must be republished to make the latest revision available in the model.

Publishing a transformation also updates the model, requiring every inheriting collection be republished to push the new model configuration to the embedded collection.

To publish a collection open the collection and select the publish button in the top right.

When editing a collection in Verb as an admin, the modified/draft model is used to display data. Therefore the latest version of the transformation and model will be visible when reviewing collections after updates have been made to transformations and models. This efforts the opportunity to review the changes, prior to publishing the collection which would make the changes live for users.