Sync data from Materialize to OpenSearch

Trusted by

Use Cases

Insert and update documents in OpenSearch indices

How our customers activate their data

Don’t just keep your data locked in dashboards. Send your valuable data models like LTV, ARR & more to the tools your teams live in day-to-day so that together you can grow your business.

Step By Step Guide

Select the data you need from Materialize
Write SQL directly, define the data you need in our Visual Audience Builder or import from existing tables and dbt models.
Choose OpenSearch from our catalog
Connect to OpenSearch with your credentials.
Manage Mappings
Configure the mappings that define how fields from your query should map to fields in the destination.
Set up a schedule and begin syncing data
Multiple basic and advanced scheduling options are available. Set up one of these and watch as data begins syncing!

By data engineers, for data engineers

No scripts. No APIs. Just SQL.

Don’t waste your time building custom integrations with each SaaS tool. Focus on building data models instead.

Leverage the Modern Stack

Use your existing dbt and Looker models. Trigger syncs with Airflow, dbt Cloud, Dagster, or by hitting our API.

Learn more

Observability and Alerting

Get alerted when syncs fail in Datadog, Pagerduty, & Slack. Then, use our live debugger which records all responses from API requests to fix errors.

Learn more

Version control with Git

Hightouch encourages engineering best practices by bi-directionally syncing all configuration changes with git.

Learn about Git Sync

Turn your warehouse into your CDP

Don't wait 6 months to implement a CDP. Hightouch turns your warehouse into a CDP so you can activate your data now and use flexible data models

Learn more

Learn more about our data engineering features

Why Hightouch

No Scripts. No APIs. No CSVs. Just SQL
Don’t waste your time building custom integrations for each of your SaaS tools. Activate your data instantly across all of your business tools.
Flexible Data Models
Build your data models once and reuse them anywhere. Leverage your data models in the warehouse, write SQL statements, or take advantage of your existing BI tools.
Self-Serve Audiences
Enable business teams to build custom audiences without SQL using a simple drag and drop interface leveraging the data models your team has already set in place.
Scale
Sync hundreds, thousands, or millions of rows from your warehouse without worrying about API failures or rate limits.
Deep Observability
Track changes using Git for version control and monitor your syncs in real-time using our debugger and alerts

About
Materialize

Materialize is a streaming database powered by Timely and Differential Dataflow, purpose-built for low-latency applications. It lets you ask complex questions about your data using SQL, and incrementally maintains the results of these SQL queries as the underlying data changes.

Learn more about Materialize

About
OpenSearch

OpenSearch is a scalable, flexible, and extensible open-source software suite for search, analytics, and observability applications licensed under Apache 2.0. Powered by Apache Lucene and driven by the OpenSearch Project community, OpenSearch offers a vendor-agnostic toolset you can use to build secure, high-performance, cost-efficient applications. Use OpenSearch as an end-to-end solution or connect it with your preferred open-source tools or partner projects.

Learn more about OpenSearch

“Salesforce wasn’t built for product-led growth companies. The key to finding qualified leads across Zeplin’s millions of users is looking at product usage metrics. Without Hightouch, our account team is running blind.”

Andrew YipSales Operations @ Zeplin

“With Hightouch, we have confidence that we can get the data we need into HubSpot to run campaigns with fresh data to add that personal touch”

Jake LevingerMarketing Operations @ Retool

“The value is being able to pull in Salesforce, Marketo, Asana, NetSuite and Lever, and blend the data from historically separate departments together for analysis. With Hightouch we can then push it out to make sure that everyone's looking at the same metrics.”