Google BigQuery

Google BigQuery is Google Cloud's data warehouse.

With Amalgam, you can two-way sync data into Excel and Google Sheets, or enable your AI tools to take direct actions without hand-holding.

Book a Demo

Spreadsheets

AI Chat

Routines

Reports

Category: Data Storage
Connects By: Signing In
Reports: 1
Website: cloud.google.com

What You Can Do With Google BigQuery

In a Spreadsheet

Pull data into Excel or Google Sheets, and refresh it whenever you need current numbers.

See How It Works

In an AI Chat

Connect your AI tool to Amalgam, and it can run Google BigQuery reports to answer your questions.

See Amalgam for AI

On a Schedule

Set a routine to fetch data on a schedule and deliver it to your shared drive, inbox, or directly into a document.

See Routines

How to Connect

Sign in to Google BigQuery and approve access. Each account you connect becomes its own connection in Amalgam, and you can add as many as you need.

Read the Connection Guide

Report1

This report comes straight from Google BigQuery. Set the options once, then refresh whenever you need.

Base Query Report

BigQuery Base Query executing a SQL query against Google BigQuery.

Options

Project IDBigQuery project ID

Dataset IDBigQuery dataset ID

Table IDBigQuery table ID

Date ColumnColumn name used for date filtering

Start DateStart of date range (YYYY-MM-DD)

End DateEnd of date range (YYYY-MM-DD)

Filter Column (1)Filter condition: column name for equality match #1

Filter Value (1)Filter condition: value for equality match #1

Filter Column (2)Filter condition: column name for equality match #2

Filter Value (2)Filter condition: value for equality match #2

Filter Column (3)Filter condition: column name for equality match #3

Filter Value (3)Filter condition: value for equality match #3

Don't See What You Need?

Tell us which Google BigQuery report or record you're missing, and we'll build it for you, usually within a week.

More Data Storage Integrations

Snowflake

Google Sheets

Try It With Your Google BigQuery Data

Book a demo, take a tour of Amalgam, and get a free trial on us to test the different systems and see how the integrations work first hand.