Google Big Query is serverless architecture. It lets you query huge amount of data and provides desired result 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 know more about creating a Google Cloud account click here).
- Google Cloud Project (to know more about creating a Google Cloud account click here).
- Google Cloud Storage API (to know more about creating a Google Cloud account click here).
- User Authentication – to authenticate user, 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.
- To reach Product Selection Page, follow the steps mentioned in Section 1.
- 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:
- Enter the Name for the dataset.
- Enter the Description for the dataset.
- 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.
- Select a Dataset from the Dataset dropdown list.
- Select required tables from the Select Tables multi select You can select more than one table in a single instance.
- 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.
Table of Contents