# Hotjar + Amazon S3

> Store data as Parquet in S3 Iceberg with Erathos. Sync Hotjar data with Erathos, an incremental, no-code pipeline with observability t

Source: https://www.erathos.com/en/pipelines/hotjar-amazon-s3
Em português: https://www.erathos.com/pipelines/hotjar-amazon-s3

Hotjar is an online behavior analytics tool that provides insights into how users interact with websites, helping to optimize user experience and boost conversions. It uses heatmaps, session recordings, and feedback loops to identify areas for improvement. Amazon Redshift, on the other hand, is a cloud data warehouse designed for fast and efficient analysis of massive datasets.

With Erathos, your Hotjar data lands in Amazon S3 as organized, query-ready files, without your team having to write a single line of ETL code. This paves the way for querying via Athena or Spark and archiving your full historical data without the costs associated with a traditional data warehouse.

### What Hotjar data does Erathos sync to Redshift?

The integration automatically syncs the core Hotjar objects:

- **Events** all tracked events along with custom properties
- **Sessions** source, duration, device, and behavioral data
- **Users** profiles, properties, and activity history
- **Conversion Funnels** steps, drop-offs, and conversion rates by segment
- **Cohorts** retention and engagement over time
- **Custom Properties** event properties and user properties defined by your team

### Why sync Hotjar to Amazon S3?

In Amazon S3, your Hotjar data is stored in open formats, ready to be queried via Athena, Spark, or any analytics engine, without lock-in to a specific data warehouse.

### How it works

Erathos connects to Hotjar via its official API and syncs your data incrementally: only new or updated records are processed in each run, keeping pipelines fast and Amazon S3 costs predictable. You choose the sync frequency (from every 5 minutes to daily), the objects to sync, and the destination dataset. Every run is logged with full observability: execution time, rows processed, contextual error logs, and instant alerts via Slack or email if anything goes wrong.

## Hotjar data in Amazon S3 in minutes

### Ready-to-use Hotjar connector

Connect Hotjar to Amazon S3 and automatically export data. Centralize engagement tracking data for analysis — no spreadsheets and no scripts.

### Full control over your Hotjar pipelines

Configure the schedule, frequency, and sync type at the table level. Configure partitioning, file format, and write frequency at the table level. The Iceberg format ensures ACID compliance and schema evolution — without full bucket rewrites.

### End-to-end observability

Stop finding out about Hotjar issues only when the business team complains. Every run is logged with runtime, processed rows, and error context. Automatic alerts via Slack, Discord, or email the moment something goes off track — so your data is always fresh for analysis.

## Centralizing Hotjar data in Amazon S3 has never been easier

Erathos is a data ingestion platform built for marketing and data teams. With the Hotjar connector, you automatically centralize sessions, recordings, and behavioral data in Amazon S3 — always up to date, with full observability into every run and zero maintenance.

## FAQ

### What is Erathos, and how can it help my business?

Erathos is a data ingestion platform built for reliability, transparency, and control. We help data teams connect tools like Hotjar to their data warehouse—with full observability into every run, zero maintenance, and none of the black-box behavior you get from traditional market tools.

### Which Hotjar data does Erathos sync to Amazon S3?

With Erathos, you centralize Hotjar data on views, likes, comments, reach, audience growth, and engagement in Amazon S3 for content analytics.

### How often does Erathos sync data from Hotjar to Amazon S3?

You can configure sync frequency from every 5 minutes up to daily, at the table level. Erathos uses incremental sync—only new or updated records are processed on each run, keeping the Hotjar pipeline efficient and Amazon S3 costs predictable.

### What happens if a Hotjar sync fails?

Erathos automatically detects failures and sends alerts to your email, Slack, or Discord with full context — not just “job failed.” Smart retries handle transient errors, and every run is logged with runtime, rows processed, and error context so your team can debug in minutes, not hours.

### Is there a free trial period for the Hotjar connector?

Yes. Every Erathos connector includes a 14-day free trial. Connect Hotjar to Amazon S3 and start syncing right away — no credit card required.
