r"(?:Users|home)[/\\]+([^/\\\s]+)[/\\]+\.gemini"), "system_background") AS user_name モデル名 SPLIT(log.model, "/")[OFFSET(ARRAY_LENGTH(SPLIT(log.model, "/")) - 1)] AS model_name, 入力トークン SUM( CAST(JSON_VALUE(log.full_response.usageMetadata.promptTokenCount) AS INT64) - COALESCE(CAST(JSON_VALUE(log.full_response.usageMetadata.cachedContentTokenCount) AS INT64), 0) ) AS total_input_tokens, キャッシュ入力トークン SUM( COALESCE(CAST(JSON_VALUE(log.full_response.usageMetadata.cachedContentTokenCount) AS INT64), 0) ) AS total_cached_input_tokens, 出力トークン SUM( CAST(JSON_VALUE(log.full_response.usageMetadata.candidatesTokenCount) AS INT64) + COALESCE(CAST(JSON_VALUE(log.full_response.usageMetadata.thoughtsTokenCount) AS INT64), 0) ) AS total_output_tokens,