# VTEX + BigQuery

> Integrate data into BigQuery with Erathos. Sync VTex data with Erathos, an incremental, no-code pipeline with full observability.

Source: https://www.erathos.com/en/pipelines/vtex-bigquery
Em português: https://www.erathos.com/pipelines/vtex-bigquery

VTex is an e-commerce platform for building and managing online stores with a focus on omnichannel experiences.

With Erathos, you can integrate VTex data into BigQuery in just a few minutes. Our platform handles the entire data movement process for your serverless data warehouse and makes it possible to combine that data with other sources. That way, your time goes toward what really creates value — extracting insights and making data-driven decisions.

### Which VTex data does Erathos sync with BigQuery?

The integration automatically syncs the main VTex objects:

- **Orders** — status, value, items, and shipping address
- **Products** — SKU, price, inventory, and description
- **Customers** — profile data, purchase history, and reviews
- **Payments** — method, status, and amounts
- **Reviews** — ratings, comments, and replies
- **Returns** — reason, status, and refunded amount

### Why sync VTex with BigQuery?

In BigQuery, you can combine this data with product, revenue, and customer satisfaction metrics — joining sources with standard SQL and query-based billing. Native integration with Looker Studio, Vertex AI, and BQML enables advanced analysis without additional infrastructure.

### How it works

Erathos connects to VTex via the official API and syncs your data incrementally — only new or updated records are processed in each run. You choose the sync frequency (from every 5 minutes to daily), which objects to sync, and the destination in BigQuery. The sync uses incremental processing that handles only new or updated records — keeping BigQuery costs predictable. You choose the sync frequency, which objects to sync, and the destination dataset. Every run is logged with full observability: execution time, rows processed, and alerts via Slack or email.

## VTEX data in BigQuery in minutes

### Ready-to-use VTEX connector

Connect VTex to BigQuery and automatically export data. Centralize marketplace data for analysis — no spreadsheets, no scripts.

### Full control over your VTEX pipelines

Configure sync schedule, frequency, and sync type at the table level. Configure sync schedule, frequency, and sync type at the table level. Incremental sync processes only new or changed records, keeping BigQuery costs low and your analytics always up to date.

### End-to-end observability

Stop finding VTEX issues only when the business team complains. Every run is logged with runtime, rows processed, and error context. Automatic alerts via Slack, Discord, or email as soon as something deviates from expected behavior — so your data stays fresh for analysis.

## Centralizing VTEX data in BigQuery has never been easier

Erathos is a data ingestion platform built for operations and data teams. With the VTex connector, you can automatically centralize operational data and metrics in BigQuery — keeping data 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 VTEX to their data warehouse — with full observability for every run, zero maintenance, and none of the black-box behavior you get from traditional market tools.

### Which VTEX data does Erathos sync to BigQuery?

Erathos connects VTEX to your data warehouse, syncing orders, products, customers, inventory, reviews, and sales performance data incrementally and automatically.

### How often does Erathos sync data from VTEX to BigQuery?

You can configure sync frequency from every 5 minutes up to once a day, at the table level. Erathos uses incremental sync—only new or updated records are processed on each run, keeping your VTEX pipeline efficient and BigQuery costs predictable.

### What happens if a VTEX 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 VTEX connector?

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