Google Big Query is a serverless architecture. It lets you query huge amounts of data and provides desired results in seconds. It helps you to manage and analyse your data with built-in features.

Prerequisites for a Google Big Query are:

• Google Cloud account (to learn more about creating a Google Cloud account, click here).
• Google Cloud Project (to learn more about creating a Google Cloud account, click here).
• Google Cloud Storage API (to learn more about creating a Google Cloud account, click here).
• User Authentication – to authenticate the user, a JSON file is required (to know more about service account keys, click here).

After completing the above steps, you are ready to create a dataset using Google Big Query.

Retrieve Data from Google Big Query

To retrieve data from Google Big Query, follow the steps given below.

1. To reach the Product Selection Page, follow the steps mentioned in Section 1.
2. From the API option, select Google Big Query. Create Google Big Query Dataset page is displayed.
   
   
   

Create a Dataset

On Create Google Big Query page:

1. Enter the Name for the dataset.
2. Enter the Description for the dataset.
3. Click on the Browse button to select the credential JSON file. The system will establish the connection with Google Cloud Account and Retrieve Dataset information.
4. Select a Dataset from the Dataset dropdown list.
5. Select required tables from the Select Tables multi select You can select more than one table in a single instance.
6. Click Create.
   
   
   
   
   The data is retrieved from Google Big Query and saved in the dataset.
   You can view this dataset on the landing page for further actions.