The Hightouch Blog - All

The state of automated testing in the data warehouse

A deep dive into automated data testing, why it matters and the top tools to consider

Exploring data lineage with OpenLineage

In this post, we ask what is data lineage and take a detailed dive into OpenLineage and how it aims to unify metadata and lineage across tools to make data lineage easier to reason about.

What's the difference between Reverse ETL tools and Segment?

Trying to understand the differences between Reverse ETL and Segment? Find out here! We break down the key differences between the two technologies, so you can make an informed decision.

Announcing Hightouch's SOC 2 compliance

Hightouch has achieved SOC 2 Type 1 compliance for the security, availability, and confidentiality trust service principles.

The state of Reverse ETL: what operational analytics looks like today & beyond

A deep-dive into how companies are using Reverse ETL in to power their operational workflows

Using Hightouch and Slack to power sales ops workflows

Getting data from your Data Warehouse into Slack couldn't be easier. With just a few lines of SQL, you can start sending custom notifications to your teams in minutes.

Enabling sales teams by syncing product data into HubSpot

Learn how to grab product metrics from your product database and generate queries that will expose that data in Hubspot to enable your Sales teams

Automate your external reporting with the Modern Data Stack

With the right infrastructure, reporting can become truly routine. Even more than that, it’s a chance to demonstrate your value to the company and customers.

How to use customer data to personalize your marketing campaigns

Running a marketing campaign without any customer data is like shooting in the dark. Help your customers feel understood by personalizing your outreach using customer data in your favorite marketing tools

Introducing the live debugger

Introducing our Live Debugger, the latest feature that helps make Hightouch the gold standard for integration observability.

3 great ways to schedule a Hightouch sync from your existing workflows

We've got three great ways of integrating Hightouch with your existing workflows: Airflow Operators, dbt Cloud integrations, and Webhook APIs.

What is a data Lakehouse?

The Data Warehouse and the Data Lake both have their strengths and weaknesses. Like yin and yang, they often coexist within the same data stack and this has given rise to a hybrid category — the Data Lakehouse!

The definitive guide to pushing data from your EDW to Salesforce CRM

With the growing adoption of CRMs in large and small organizations, serving customer data to sales teams is a true competitive advantage. This guide outlines multiple ways for pushing data to Salesforce from your EDW.

Why data engineers should not manage dbt

dbt transformations are critical and should be owned by data analysts and scientists because they have the most context to make the data a lot more usable for business teams.

Data engineers shouldn't write Reverse ETL: a guide to building a happy data engineering department

This guide sheds light on the state of data engineering in 2021 as well as talks about the rise of Reverse ETL as a core component of the Modern Data Stack.

Modern data warehouse modeling: the definitive guide - part 2

This guide on modern data warehouse modelling explores the current sentiment toward Kimball as well as shines some light on Wide Tables and what the data community thinks of them.

Modern data warehouse modeling: the definitive guide - part 1

A guide on modern data warehouse modeling, exploring best practices from the community and famous modelling paradigms like Kimball’s Dimensional Modeling, Inmon, Data Vault and Wide Tables.

dbt Snapshots: the definitive guide

One of the most important questions that any analytics-focused company should strive to answer is “How has my data changed over time?” dbt provides a simple solution addressing this exact problem called dbt snapshots.

dbt Cloud: 4 reasons for data teams to embrace it

The biggest benefit that dbt Cloud offers to data teams and analytics engineers? Freedom from distractions, and the ability to focus where you can add unique value making sense of your company's data.

How Datadog operationalizes their data warehouse to supercharge their business teams

In conversation with Romoli Bakshi, Engineering Team Lead at Datadog who walks us through the process her team follows to operationalize their data warehouse in order to supercharge their business teams.

The future of warehouses and customer data - software engineering daily

Tune in to this episode from the Software Engineering Daily podcast where one of our founders talks about the future of warehouses, what we're building, and the customer data ecosystem as a whole.

How to monitor customer usage in Slack via SQL

The Slack integration on Hightouch enables you to pull the resources and metrics important to your business via SQL and then get notified when these resources and metrics change, right within Slack of course!

Syncing custom objects and fields from your data warehouse to HubSpot

We use and love HubSpot and so do our customers and therefore we decided to draft this guide that walks you through the process of syncing custom objects and fields from your Data Warehouse to HubSpot.

Identity resolution in SQL

What is identity, and how does it relate to customer data? Identity can have many different meanings but essentially, it involves unifying different pieces of data about your customers. Read on to learn more.