The Hightouch Blog - All

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.