gcloud cli

cheatsheet.sh

gcloud config configurations create my-profile
gcloud config set account [email protected]

gcloud config configurations list
gcloud config configurations activate my-profile
gcloud auth application-default login

verify_sa_bq_access.py

from google.cloud import bigquery

# Authenticate with the service account JSON key
client = bigquery.Client.from_service_account_json("./service-account.json")

# Define the query
query = """
SELECT 
    table_catalog AS project_id, 
    table_schema AS dataset_name, 
    table_name
FROM `project.dataset.INFORMATION_SCHEMA.TABLES`
ORDER BY dataset_name, table_name;
"""

# Run the query
query_job = client.query(query,location="europe-north1")
results = query_job.result()

# Print the results
for row in results:
    print(row)

verify_sa_with_requests.py

# Check metadata
import requests

metadata_url = "http://metadata.google.internal/computeMetadata/v1/instance/service-accounts/default/email"
headers = {"Metadata-Flavor": "Google"}
response = requests.get(metadata_url, headers=headers)

print(f"Service Account Email: {response.text}")