Creating a service account user
1. Go to the Google Cloud Console
- Open the Google Cloud Console.
2. Navigate to the “IAM & Admin” Section
- In the navigation menu, go to IAM & Admin > Service Accounts.
- Direct link: Service Accounts
3. Create a New Service Account
- Click the + CREATE SERVICE ACCOUNT button.
-
Provide the following details:
- Service account name: Choose a meaningful name (e.g.,
bigquery-service-account). - Service account ID: This will auto-generate based on the name.
- Service account description: Optionally, add a brief description.
- Service account name: Choose a meaningful name (e.g.,
- Click CREATE AND CONTINUE.
4. Grant Permissions to the Service Account
-
In the next step, assign roles to the service account:
- Select BigQuery Admin or other relevant roles, depending on your needs.
- For detailed role descriptions, see the BigQuery Roles documentation.
- Click CONTINUE.
5. Set Up Access to the Service Account (Optional)
- If needed, specify users or groups who can access or manage the service account.
- Click DONE to complete the creation process.
6. Generate and Download a Key
- In the Service Accounts list, locate your new service account.
- Click the ⋮ (More Actions) menu and select Manage Keys.
- Click ADD KEY > Create new key.
- Select the key type:
- Choose JSON.
- Click CREATE to download the key file.
- Save the JSON file securely, as it contains sensitive credentials.