Connecting to Google BigQuery

Connecting to Google BigQuery

Our platform enables you to connect quickly and easily to Google BigQuery.This article covers the basic requirements that will be needed to run BigQuery connectors.

Before continuing with a step-by-step guide on setting up a Google Cloud Platform connection, 1st, introduce a few basic concepts and requirements.

Basic Concepts

Projects

Projects are top-level containers in the Google Cloud Platform. They store information about billing and authorized users and contain BigQuery data. Each project has a name and a unique ID.

Datasets

dataset is contained within a specific project. Datasets are top-level containers that organize and control access to your tables and views. A table or view must belong to a dataset, so you must create at least one dataset before using Google BigQuery.

You must create a dataset within your project before adding tables.

Tables

A BigQuery table contains individual records organized in rows. Each record is composed of columns (also called fields). Every table is defined by a schema that describes the column names, data types, and other information.

Basic Requirements

Please follow these steps to get started with BigQuery:

  1. Select or create a Google Cloud Platform project.
    Go to the manage resources page
  2. Make sure that billing is enabled for your Google Cloud Platform project.
    Learn how to enable billing
  3. BigQuery is automatically enabled in new projects. To activate BigQuery in a pre-existing project, go to Enable the BigQuery API.
    Enable the API

Please review the official Google BigQuery Quickstart Guide to read more.

    • Related Articles

    • Google BigQuery - Data Source Connector

      Our platform enables you to quickly and easily connect your data sources to a Google BigQuery table. This enables a one-way synchronization—changes in the Google BigQuery table are downloaded into your data source on a regular basis. Your data source ...
    • Task Connector – Google BigQuery

      Our platform lets you quickly and easily connect your data sources to a Google BigQuery table, enabling streamlined data synchronization. One-Way Synchronization This connector supports one-way synchronization, meaning any updates in the BigQuery ...
    • Form Connector – Google BigQuery

      Our platform’s Premium BigQuery connector provides a direct link to Google’s BigQuery database service. This tool allows you to automatically insert your form entries as new rows in a target BigQuery database table. This creates a one-way ...
    • Data Source Connector – Google BigQuery

      Our platform enables you to quickly and easily connect a data source to a Google BigQuery table. This enables a one-way synchronization to occur, where any changes in the Google BigQuery table are downloaded into your data source on a regular basis. ...
    • Connecting to Google Drive & Spreadsheets

      Adding and authenticating a Connection to your Google Drive and Spreadsheets allows data to be pushed and pulled between the two platforms. Form Connectors can then be added to send files to your Google account or add rows to a spreadsheet when a ...