No-code pipeline · Tray → BigQuery

Send data from Tray to BigQuery

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

From Tray to BigQuery: managed, scheduled, no code.

Creating a pipeline that sends data from Tray to BigQuery data warehouses takes only a few minutes with Kondado. And the whole integration from Tray to BigQuery is managed and executed by our platform. With Kondado, you can focus on extracting value from Tray data and combining it with other data in your BigQuery data warehouse

Connect Tray now →

Send Tray Data to BigQuery Automatically

How do you send Tray data to BigQuery without writing complex code? Kondado offers a direct integration that connects your Tray eCommerce platform to Google’s data warehouse in minutes. Simply authenticate your Tray account as a data source, configure your BigQuery destination, and choose which data pipelines to replicate. The platform automatically handles schema mapping and data transfer, delivering fresh sales records, customer profiles, and product catalogs directly to your analytics environment.

Once your data arrives in BigQuery, you can build custom reports analyzing sales performance, customer segmentation, and inventory trends using SQL queries or connect to visualization tools like Looker Studio and Power BI. This automated workflow eliminates manual data exports and ensures your team always works with current information for faster decision making.

Kondado replicates data from Tray to BigQuery on a configurable schedule ranging from every 5 minutes to daily, supporting 14 pipelines including Customers, Orders, Payments, and Products with 328 total fields available for analysis.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Available Tray Data in BigQuery

Replicate the Orders and Order Details pipelines to analyze transaction patterns, average order values, and shipping performance directly in BigQuery. Combine this with the Customers pipeline to build comprehensive customer lifetime value models and segment your audience based on purchase history and registration dates. You can also leverage the Products and Sold Products pipelines to track inventory turnover, identify top-performing SKUs, and correlate sales data with Discount Coupons information to optimize your pricing strategy. With Payments data flowing into the same warehouse, you can reconcile revenue across multiple methods and create financial dashboards that update automatically as new transactions complete in your Tray store.

Try out all the features for free for 14 days

Replicated to BigQuery

Tray data available for BigQuery

Tables Kondado writes into your BigQuery, on a schedule you control.

available pipelines

328

extractable fields

BigQuery

Destination

Available integrations

Customers

Includes information such as name, email, and registration date, along with modification date and last visit.

Discount Coupons

Contains details such as coupon code, creation date, and discount value, along with usage restrictions.

Newsletters

Presents information about the customer's email, newsletter status, and creation and modification dates.

Payments

Includes data on payment methods, status, and values of transactions made by customers.

Orders

Provides information such as order ID, order date, and delivery status, along with customer details.

Order Details

Includes detailed information such as order ID, billing address, and additional cart values.

Order Details: Mercado Livre

Presents data such as customer ID, estimated delivery date, and information about the purchased product.

Additional Product Information for Orders

Contains additional information such as product ID and product name related to each order.

Order Invoices

Includes data such as invoice ID and product CFOP, essential for accounting.

Order Transactions

Provides information on transaction status and values associated with each order made.

Products

Table contains information about products, including id, name, and variants. Fields such as attributes_id and attributes_value provide additional details.

Products (Kits)

Table presents product kits, detailing id and attributes. Fields such as attributes_customer_attribute_id provide information about the characteristics of the kits.

Sold Products

Table displays sold products, including id and sales information. Fields such as order_id and order_item_quantity help understand sales performance.

Products: Variants

Table details product variants, including id and attributes. Fields such as additionalproductinfo_product_id and additionalproductinfo_variant_id provide specific information about each variant.

See all available data → Send Tray to BigQuery →

Try out all the features for free for 14 days

How to send Tray data to BigQuery

Sync data automatically — no code, no manual exports.

Connect Tray to Kondado

Add Tray as a data source in Kondado by authenticating with your store credentials, granting the platform access to your eCommerce pipelines without writing code.

Set Up BigQuery Destination

Configure BigQuery as your destination warehouse by entering your Google Cloud project ID, dataset name, and service account key for seamless data loading.

Choose Pipelines and Schedule

Select specific Tray pipelines like Orders, Customers, or Products to replicate, then define your update interval from every 5 minutes to daily for automated synchronization.

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

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Send data from Tray to other destinations

Tray > Looker Studio

Tray > Power BI

Other visualizations

Tray > Amazon S3

Tray > BigQuery

Tray > Excel

Tray > Google Sheets

Tray > MySQL

Tray > PostgreSQL

Tray > Redshift

Tray > SQL Server

Choose a tool to visualize your Tray data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Tray > Airtable

Tray > Alteryx

Tray > Amazon Quicksight

Tray > BIMachine

Tray > Cortex

Tray > Data Studio

Tray > Geckoboard

Tray > Grafana

Tray > IBM Cognos Analytics

Tray > Klipfolio

Tray > Looker Studio

Tray > Looker

Tray > Looqbox

Tray > Metabase

Tray > Microstrategy

Tray > Pentaho

Tray > Power BI

Tray > Qlik Cloud Analytics

Tray > Qlik Sense

Tray > Qlik

Tray > QlikView

Tray > Redash

Tray > Superset

Tray > Tableau

Tray > BI TOTVS

Tray > Zoho Analytics

Frequently Asked Questions (FAQ)

Answers about sending Tray data to BigQuery automatically

How does Tray to BigQuery replication work on Kondado? ▼

Kondado connects to your Tray account via API and extracts data from selected pipelines, then loads it into your BigQuery dataset on a configurable schedule. You choose the update frequency, ranging from every 5 minutes to daily, and the platform handles schema mapping and data type conversion automatically.

What Tray data can I replicate to BigQuery? ▼

You can replicate 14 different pipelines including Customers, Orders, Order Details, Payments, Products, Discount Coupons, and Newsletters, totaling 328 available fields. This covers customer profiles, transaction history, product catalogs, and marketing subscription data for comprehensive eCommerce analysis.

How often does Tray data update in BigQuery? ▼

Kondado updates your BigQuery data on a configurable schedule that you control, with options including every 5 minutes, 15 minutes, hourly, or daily intervals. This ensures your analytics reflect recent store activity without overwhelming your API limits or computing resources.

What format does Tray data take in BigQuery? ▼

Data arrives in BigQuery as structured tables that mirror your Tray pipelines, with properly typed columns for dates, currency values, and text fields. You can query this data directly with SQL or connect it to Looker Studio and Power BI for visualization.

Can I combine Tray data with other sources in BigQuery? ▼

Yes, once your data reaches BigQuery, you can join Tray information with additional sources and platforms. This allows you to correlate eCommerce transactions with advertising spend, inventory management systems, or CRM data for unified business intelligence.

Do I need coding skills to send Tray data to BigQuery? ▼

No coding is required to set up the connection, as Kondado provides a no-code interface for authenticating your Tray account and selecting pipelines. The platform manages the technical complexity of API connections, data extraction, and warehouse loading automatically.

Can I send Tray data to tools other than BigQuery? ▼

Yes, besides BigQuery, you can replicate Tray data to PostgreSQL, Google Sheets, MySQL, Redshift, SQL Server, Amazon S3, and Excel depending on your analytics needs and infrastructure preferences.

How do I start analyzing Tray data after it reaches BigQuery? ▼

Once replication begins, you can immediately query your data using BigQuery SQL or connect to business intelligence tools to build custom dashboards. Create reports tracking sales trends, customer acquisition costs, and product performance using the fresh data that updates automatically from your Tray store.

Try out all the features for free for 14 days

Related on Kondado

Try out all the features for free for 14 days