gcloud config set compute/zone NAME
gcloud config set compute/region NAME
https://cloud.google.com/vertex-ai/generative-ai/docs/learn/locations?_gl=1*1bcvdro*_ga*NTI3NDI1NDQuMTc0NTAzMjk5NA..*_ga_WH2QY8WWF5*MTc0NTE5NzkzOS40LjEuMTc0NTE5OTMyMi42MC4wLjA.
gcloud beta billing projects describe ACCOUNT
gcloud pubsub subscriptions pull billing-topic-sub --auto-ack
gcloud pubsub topics publish billing-topic4 --message="{\"budgetDisplayName\": \"$60 Monthly Budget Alert\", \"costAmount\": 0.05, \"costIntervalStart\": \"2025-08-01T07:02:00Z\", \"budgetAmount\": 60.0, \"budgetAmountType\": \"SPECIFIED_AMOUNT\", \"currencyCode\": \"USD\"}"
bq query --use_legacy_sql=false "SELECT * FROM `PROJECT.billing_topic.billing-topic` LIMIT 1000"
Install CLI on mac
https://cloud.google.com/sdk/docs/downloads-versioned-archives
gcloud auth login
Create a kubernetes cluster:
$ gcloud container clusters create --machine-type n1-standard-2 --num-nodes 2 --zone us-central1-b --cluster-version latest k8scluster
Delete the cluster
$ gcloud container clusters delete k8scluster --zone us-central1-b
SELECT
title,
description,
CONCAT('https://gemini.google.com/gem/', id) AS url,
owner.user.email AS owner_user_email,
COALESCE(
REGEXP_EXTRACT(org_unit_path, r'^/[^/]+/([^/]+)'),
REGEXP_EXTRACT(org_unit_path, r'^/([^/]+)')
) AS org_unit,
version,
owner.shared_drive.id AS owner_shared_drive_id,
creator.user.email AS creator_user_email,
FORMAT_TIMESTAMP('%Y-%m-%d %H:%M:%S', create_time_micros) AS create_time,
FORMAT_TIMESTAMP('%Y-%m-%d %H:%M:%S', last_modified_time_micros) AS last_modified_time,
permission.permission_id,
permission.name AS permission_name,
permission.type AS permission_type,
permission.role AS permission_role,
permission.view,
permission.allow_file_discovery,
permission.email AS permission_email,
permission.domain AS permission_domain,
permission.inherited_permissions_disabled,
detail.permission_type AS details_permission_type,
detail.role AS details_role,
detail.inherited_from AS details_inherited_from,
detail.inherited AS details_inherited,
detail.allow_file_discovery AS details_allow_file_discovery,
size_bytes,
parent,
id
FROM `drive-inventory-bq-export.DriveInventory.inventory`
LEFT JOIN UNNEST(access.permissions) AS permission
LEFT JOIN UNNEST(permission.permission_details) AS detail
WHERE
mime_type = 'application/vnd.google-gemini.gem' AND trashed = FALSE
ORDER BY
org_unit,
owner_user_email,
id