From VTEX to BigQuery: managed, scheduled, no code.
Creating a pipeline that sends data from VTEX to BigQuery data warehouses takes only a few minutes with Kondado. And the whole integration from VTEX to BigQuery is managed and executed by our platform. With Kondado, you can focus on extracting value from VTEX data and combining it with other data in your BigQuery data warehouse
How to send VTEX data to BigQuery? Kondado provides a direct integration that automatically replicates your ecommerce data on a configurable schedule. Simply connect your VTEX account as a data source, select BigQuery as your destination, and choose which pipelines to activate. Your inventory, orders, and customer data flow into BigQuery without manual exports or complex coding, allowing your team to focus on analysis rather than data preparation.
Once configured, Kondado maintains your datasets with automated updates running every 5 minutes, hourly, or daily based on your business needs. This ensures your BigQuery environment always contains current information for building dashboards, running SQL queries, and combining VTEX data with other business sources for comprehensive analytics.
Kondado automatically replicates VTEX data to Google BigQuery on a user-configured schedule, offering 17 distinct pipelines including Orders, Stock, SKUs, and Marketing Data with 432 fields, enabling automated analytics and reporting without manual data extraction.
With Kondado, your Orders and Order Items pipelines feed detailed transaction data into BigQuery, enabling you to analyze purchase patterns, calculate customer lifetime value, and identify your best-selling SKUs using SQL queries. The Marketing Data of Orders pipeline captures affiliate and UTM campaign information, allowing you to attribute revenue to specific marketing channels and optimize your advertising spend directly within your data warehouse. Additionally, Stock and SKUs pipelines provide current inventory visibility, helping you prevent stockouts and manage warehouse operations by monitoring reserved quantities and available stock across locations.
Try out all the features for free for 14 days
Replicated to BigQuery
VTEX data available for BigQuery
Tables Kondado writes into your BigQuery, on a schedule you control.
17
available pipelines
432
extractable fields
BigQuery
Destination
Available integrations
Coupons
Includes fields like coupon_id, expirationintervalperuse, and isarchived, allowing management of promotions and their reuse intervals.
Stock
Presents data such as skuid, warehouseid, and totalquantity, providing information on the stock position of SKUs by warehouse.
Master Data
Contains fields like id, updatedin, and createdin, allowing management of entities and their dynamic properties.
Orders
Includes information such as orderid, status, and totalvalue, allowing detailed tracking of orders and their status.
Shipping Data of Orders
Provides shipping details including shippingestimateddate and shippingestimateddatemax, essential for logistical management.
Marketing Data of Orders
Includes information such as affiliateid and utmcampaign, allowing analysis of marketing campaigns associated with orders.
Order Details
Presents fields like lastmessageunread and callcenteroperatorname, offering insights into customer communication and service.
Logistics Information of Orders
Includes data such as invoiceinput and invoiceoutput, essential for managing fiscal and logistical documents.
Order Items
Contains information about each order item, such as totalitems and paymentnames, allowing detailed analysis of purchased products.
Payments: Order Transactions
Includes details about payment transactions, such as paymentnames and totalvalue, essential for financial control of orders.
Orders: Fees and Benefits
Includes information about fees and benefits associated with orders, such as totalvalue, shippingestimateddate, and paymentnames.
Orders: Totals
Presents the totals of orders, including orderid, totalvalue, and totalitems, along with details about the creation date.
Products
Contains data about available products, including skuid, warehousename, and totalquantity, along with pricing information.
Promotions
Provides details about promotions, including coupon_id, expirationintervalperuse, and maxitemsperclient, along with campaign information.
SKUs
Presents information about SKUs, such as skuid, totalquantity, and reservedquantity, along with data on stock availability.
SKUs: Kits
Includes data about SKU kits, allowing the visualization of product combinations along with their respective quantities and prices.
SKUs: Prices
Provides information about SKU prices, including skuid and pricing details, allowing for cost and promotion analysis.
Sync data automatically — no code, no manual exports.
1
Connect VTEX Account
Authenticate your VTEX environment in Kondado by providing your API credentials, establishing a direct link to your ecommerce data without technical configuration.
2
Configure BigQuery Destination
Set up BigQuery as your destination by specifying your Google Cloud project and dataset, ensuring data flows directly into your preferred warehouse location.
3
Select Pipelines and Schedule
Choose which VTEX pipelines to activate, such as Orders, Stock, or Marketing Data, and define your update frequency from every 5 minutes to daily based on your analytics requirements.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending VTEX data to BigQuery automatically
How does the VTEX to BigQuery connection work?▼
Kondado uses a direct integration to connect with your VTEX environment through API authentication. Once connected, the platform automatically extracts data from your selected pipelines and loads it into your specified BigQuery dataset on your chosen schedule. You maintain full control over which data endpoints to activate and how frequently they update.
What specific VTEX data can I replicate to BigQuery?▼
You can replicate 17 different pipelines encompassing 432 fields, including Orders, Order Items, Stock, SKUs, Coupons, and Marketing Data. This covers transactional information, inventory levels, promotional details, and shipping logistics. The data arrives in BigQuery as structured datasets that you can query immediately using standard SQL.
How often does VTEX data update in BigQuery?▼
Kondado replicates data on a configurable schedule that you control, with options ranging from every 5 minutes to daily updates. You can set different frequencies for different pipelines based on your analytical needs, ensuring high-velocity data like orders updates more frequently than reference data like SKUs.
Can I combine VTEX data with other sources in BigQuery?▼
Yes, once your VTEX data resides in BigQuery, you can easily join it with information from your CRM, ERP, or advertising platforms. Kondado supports connections to 80+ data sources, allowing you to create unified datasets that provide complete business visibility across all your operational systems.
What format does VTEX data take in BigQuery?▼
Data arrives as normalized tables within your BigQuery dataset, with each pipeline corresponding to a specific table structure. Fields maintain their original data types and relationships, preserving the integrity of your ecommerce information. This structured format allows you to build complex queries, create views, and develop custom analytics models immediately upon connection.
Are there pre-built dashboards available for VTEX data?▼
Yes, Kondado provides ready-made report templates including the VTEX Power BI Report and VTEX Looker Studio Report. These templates connect directly to your BigQuery dataset, offering immediate visualizations of sales performance, inventory trends, and marketing attribution without requiring you to build charts from scratch.
Do I need technical skills to set up the VTEX BigQuery pipeline?▼
No coding is required to establish the connection. The setup process involves authenticating your VTEX account and configuring your BigQuery destination through Kondado's interface. While SQL knowledge helps for subsequent analysis in BigQuery, the data replication itself requires only basic configuration steps.
Can I send VTEX data to destinations other than BigQuery?▼
Absolutely, while BigQuery offers powerful warehouse capabilities, Kondado also supports sending VTEX data to Power BI, Looker Studio, Google Sheets, PostgreSQL, MySQL, Excel, Redshift, SQL Server, and Amazon S3.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
