I've been blocked from Google Cloud - please help!

Google Cloud Data Analytics
1

I was working in BigQuery, using Gemini for the first time - all is going well and then suddenly get an email saying I’m in breach of terms and conditions and I’m completely blocked from my project and access to Google Cloud - I’ve raised a dispute - this was last Wednesday. I’ve heard nothing back. I’m a long time user of GC and specifically BQ, I don’t know how to get help with this.

I was working on Categorising product data with Google’s Product Categories based of off their Titles and Descriptions.

Primary script here:

DECLARE prompt_text STRING;

SET prompt_text = ‘’’
Assign this product to one of the following valid Google Product Categories.
Return only the exact category string from the list below:
‘’';

WITH
– Build the category list into a single string
Categories AS (
SELECT STRING_AGG(category, '\n- ') AS category_list
FROM trade-products-handling.reference.trade_google_product_categories
),

– Build prompts for each product
PromptTable AS (
SELECT
p.Product ID,
CONCAT(
prompt_text, '\n- ', c.category_list,
'\n\nProduct Title: ', p.Title,
'\nProduct Description: ', p.Body HTML
) AS prompt
FROM trade-products-handling.processed_products.singular_products p
CROSS JOIN Categories c
)

– Call Gemini to generate categories
SELECT
Product ID,
ml_generate_text_llm_result AS Product Category
FROM
ML.GENERATE_TEXT(
MODEL trade-products-handling.ml_models.gemini-fl,
(SELECT * FROM PromptTable),
STRUCT(
0.2 AS temperature, – keep randomness low for consistency
80 AS max_output_tokens,
0.8 AS top_p,
40 AS top_k,
TRUE AS flatten_json_output
)
);

I have no idea what I’ve done wrong here, I’ve lost a day’s worth of work as I can’t access in the project and I’m week behind where I’m suppose to be.

Any help would be greatly, greatly appreciated.

Thanks,
Joe