Google Cloud BigQuery Setup

Follow these steps to set up Google Cloud BigQuery for CloudMart:

1. Create a Google Cloud Project:
   • Go to the Google Cloud Console (https://console.cloud.google.com/).
   • Click on the project dropdown and select "New Project".
   • Name the project "CloudMart" and create it.
2. Enable BigQuery API:
   • In the Google Cloud Console, go to "APIs & Services" > "Dashboard".
   • Click "+ ENABLE APIS AND SERVICES".
   • Search for "BigQuery API" and enable it.
3. Create a BigQuery Dataset:
   • In the Google Cloud Console, go to "BigQuery".
   • In the Explorer pane, click on your project name.
   • Click "CREATE DATASET".
   • Set the Dataset ID to "cloudmart".
   • Choose your data location and click "CREATE DATASET".
4. Create a BigQuery Table:
   • In the dataset you just created, click "CREATE TABLE".
   • Set the Table name to "cloudmart-orders".
   • Define the schema according to your order structure. For example:
     • id: STRING
     • items: JSON
     • userEmail: STRING
     • total: FLOAT
     • status: STRING
     • createdAt: TIMESTAMP
   • Click "CREATE TABLE".