Multiwoven platform is built on a few core concepts that are essential to understand in order to use the platform effectively. This guide will help you understand these concepts and how they work together.

Hero Light

Sources: The Foundation of Data

Overview

Sources are the starting points of your data journey. It’s where all your data is stored and where Multiwoven pulls data from.

Hero Light

These can be:

  • Data Warehouses: For example, Snowflake Google BigQuery and Amazon Redshift
  • Databases and Files: Including traditional databases, CSV files, SFTP

Adding a Source

To integrate a source with Multiwoven, navigate to the Sources overview page and select ‘Add source’.

Destinations: Where Data Finds Value

Overview

‘Destinations’ in Multiwoven are business tools where you want to send your data stored in sources.

Hero Light

These can be:

  • CRM Systems: Like Salesforce, HubSpot, etc.
  • Advertising Platforms: Such as Google Ads, Facebook Ads, etc.
  • Marketing Tools: Braze and Klaviyo, for example

Integrating a Destination

Add a destination by going to the Destinations page and clicking ‘Add destination’.

Models: Shaping Your Data

Overview

‘Models’ in Multiwoven determine the data you wish to sync from a source to a destination. They are the building blocks of your data pipeline.

Hero Light

They can be defined through:

  • SQL Editor: For customized queries
  • Visual Table Selector: For intuitive interface
  • Existing dbt Models or Looker Looks: Leveraging pre-built models

Importance of a Unique Primary Key

Every model must have a unique primary key to ensure each data entry is distinct, crucial for data tracking and updating.

Syncs: Customizing Data Flow

Overview

‘Syncs’ in Multiwoven helps you move data from sources to destinations. They help you in mapping the data from your models to the destination.

Hero Light

There are two types of syncs:

  • Full Refresh Sync: All data is synced from the source to the destination.
  • Incremental Sync: Only the new or updated data is synced.