Snowflake - Icon

Snowflake

Redshift - Icon

Redshift

PostgreSQL-icon-color

PostgreSQL

Samsara - Icon

Samsara

Reltio - Icon

Reltio

SQL-Server

Microsoft SQL Server

Amazon Athena - Icon

Amazon Athena

MySQL - Icon

MySQL

FreshService

Freshservice

Databricks - Icon

Databricks

MongoDB - Icon

MongoDB

IBMDB2-icon-color

IBM DB2

PagerDuty - Full

PagerDuty

ServiceTitan - Icon

ServiceTitan

Veeva

Firebase - Icon

Firebase

Mode - Icon

Mode

Sapling - Icon

Sapling

AccuWeather - Icon

AccuWeather

pestroutes

PestRoutes

Delete the table specified by table_id from the dataset. If the table contains data, all the data will be deleted.

Delete table

Get job

Gets full details about a Google BigQuery table.

Get table

Insert job

Inserts up to 500 rows into a Google BigQuery table.

Insert rows

Uploads a CSV file to BigQuery, saves the rows into a table.

Insert rows from CSV file

List datasets

List job query results

List jobs

List all the projects you have in your Google BigQuery account.

List projects

List datasets DDL

Create a new, empty table in the dataset.

Create table

Add or update one or more columns in a table in BigQuery via the API, so you don't have to create them manually. Useful when you're looking to ensure that a table matches a schema before running an "Insert Rows" operation.

Add or update columns in table

List jobs DDL

List projects DDL

List tables

List tables DDL

Run query

MongoDB-Logo

How to integrate MongoDB

postgresql-logo

How to integrate PostgresSQL

aws redshift

How to integrate Amazon Redshift

flow-data-between-csv-and-your-stack-with-csv-processor blog post cover image

flow-data-between-csv-and-your-stack-with-csv-processor

Learn How to Automate Your CSV and Flat File Management

Connector Department - Developers - Cards

New Relic - Full - Dark

New Relic - Anonymous

Developers

Google BigQuery - Icon

Google BigQuery

Database

Retrieves mobile events such as success, on duty, failed, … for the currently active plan (i.e. the last plan that was sent to drivers). Each request returns up to 500 events which occurred after the specified tag. The result will contain a new tag which you can use in the next request to skip already received events.

List mobile events

Retrieves the status of the planning process.

Get planning status

Creates a new order in the system or updates an existing order.

Create order

Creates update or replace one or more orders in the system. Note that geocoding addresses is not available in this call. The locations for orders must either exist in the system, or be specified via latitude and longitude coordinates. Geocoding is available in Create Order.

Create/Update orders

Delete order

Retrieves the routes for a specific date.

List routes

Perform a raw HTTP request with some pre-configuration and processing by the connector, such as authentication.

Raw HTTP Request (Advanced)

Starts the planning process for the specified date.

Start planning

Updates driver parameters for a particular date and driver start and end location. Any existing routes for the specified date/driver will be unscheduled.

Update driver parameters

marketing tools by tray.io

How Automation is Changing the Face of Business

hot-topics-blog-header-3@2x

Streamline strategic sales with an automated deal desk

Tray-IO Blog 6

The ultimate guide to automating the entire lead lifecycle

Vox Media is on the Tray platform

Vox Media connects and automates pre- and post-sales to streamline workflow

business-automation blog post cover image

business-automation

GDPR compliance for US companies: What you need to know

Connector Department - All - Cards

OptimoRoute

Vertical

"Request a trial" -> Trial LP [Primary] | MAIN SITEWIDE CTA

MAIN SITEWIDE CTA | Trial Landing Page

Experiences

Capabilities

Foundation - Merlin AI and Enterprise Core

CTA - Universal Automation Cloud LP - "Learn more" - Secondary

Universal Automation Cloud

CTA - Cvent case study - "Show me how" - Primary 

cvent-logo-white

Cvent migrates 500+ legacy integrations and achieves a 95% customer retention rate

Customer Spotlight

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua

Lorem ipsum dolor

UAC Solutions - By Team

UAC Solutions - By Use Case

UAC Solutions - By Application

A strategic platform with solutions for mission critical use cases

Solutions

Solutions Customer Spotlight: Beyond Finance CTA - Primary

Logo - Beyond Finance - White

Beyond Finance reduces employee onboarding time from 10 days to 5 minutes

Resources - Learn & Evaluate

Resources - Success

Resources - Company

Your journey to automation excellence starts here

Resources

TUAC Resources Spotlight - Udemy

Resources Customer Spotlight - Primary

Udemy - White Full

Udemy streamlines self-service to enterprise sales process and saves 20+ hours per month

Tray.io > Tray.ai animation DARK

Homepage Tray.ai logo animation DARK

Tray.io > Tray.ai Animation - LIGHT

Homepage Tray.ai logo animation LIGHT

See all our connectors (Tertiary)

Similar connectors to Google BigQuery and OptimoRoute

G2-2024-spring_creative

Tray is the leading AI ready integration and automation platform

DigitalOcean - Full - Dark

David Dorman of Digital Ocean works with Tray.io

David Dorman - DigitalOcean

DigitalOcean - David Dorman

Details - Double

Header CTA Banner - Welcome to Tray.ai, the AI-ready iPaaS

Header CTA Banner (Connectors) - Welcome to Tray.ai

Our interactive tour walks you through the Tray platform, showing you how integrations and automations work together to optimize your operations - on your own time, no pressure.

Take interactive tour

First Name

Last Name

Email

Submit (Get a demo)

How did you hear about Tray - Interactive Tour (Hidden)

offer_type (interactive tour)

Salesforce Campaign ID (Interactive Tour)

Interactive Tour Form

"Take interactive tour" -> Interactive Tour Form Modal [Primary]

"Request 1:1 demo" -> Platform Demo 1:1 Form Modal [Primary]

Google BigQuery and OptimoRoute integrations couldn’t be easier with the Tray platform’s robust Google BigQuery and OptimoRoute connector, which connects any services without the need for separate integration tools.

Google BigQuery and OptimoRoute integrations couldn’t be easier with the Tray platform’s robust Google BigQuery and OptimoRoute connectors, which can connect to any service without the need for separate integration tools.

Integrate Google BigQuery and OptimoRoute with any SaaS application or service using the Tray platform’s generic connectivity options, such as the HTTP Client, Webhook Trigger, and our Connector Builder. Configure them to connect to Google BigQuery and OptimoRoute and any other API, database, webhook, and more.

Google BigQuery and OptimoRoute integration + automation

Google BigQuery and OptimoRoute Connector Details

Popular Google BigQuery and OptimoRoute integrations

Google BigQuery and OptimoRoute templates