Navigate to [https://console.cloud.google.com/](https://console.cloud.google.com/welcome?hl=en&project=summer-sun-237618)

SELECT  FROM `summer-sun-237618.rfm.RFM_Z_VALUES` LIMIT 1000

Go to <https://docs.buaimarketing.com/k-means-clustering-for-segmentation/> - Copy the code in section: 4. K-means Clustering

Copy the code: "CREATE OR REPLACE MODEL `your_project.your_dataset.rfm_kmeans_model`\
OPTIONS(model_type='kmeans', num_clusters=4) AS\
SELECT\
recency_z,\
frequ..."


CREATE OR REPLACE MODEL `your_project.your_dataset.rfm_kmeans_model`
OPTIONS(model_type='kmeans', num_clusters=4) AS
SELECT
  recency_z,
  frequency_z,
  monetary_z
FROM
  `your_project.your_dataset.standardized_rfm_table`;


Switch back to tab "BigQuery – My Project – Google Cloud console"

Click on Query . Click "`myproject.rfm.RFM_Z_VALUES`" and replace the code with your project's name and dataset.

K-means in Google Cloud Console