Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://developers.google.com/bigquery/docs/create-machine-learning-model-console below:

Create a machine learning model in BigQuery ML by using the Google Cloud console

Stay organized with collections Save and categorize content based on your preferences.

Preview

This feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms. Pre-GA features are available "as is" and might have limited support. For more information, see the launch stage descriptions.

This document shows you how to use the Google Cloud console to create a BigQuery ML model.

• To create a model and run inference, you must be granted the following roles:

  • BigQuery Data Editor (roles/bigquery.dataEditor)
  • BigQuery User (roles/bigquery.user)

1. In the Google Cloud console, on the project selector page, select or create a Google Cloud project.

   Note: If you don't plan to keep the resources that you create in this procedure, create a project instead of selecting an existing project. After you finish these steps, you can delete the project, removing all resources associated with the project.

   Go to project selector

2. Verify that billing is enabled for your Google Cloud project.

3. Enable the BigQuery and BigQuery Connection APIs.

   Enable the APIs

Before you create a model, make sure that you have addressed any prerequisites for the type of model that you are creating:

• If you want to use a query to select training data for a model, you must have that query available as a saved query.

• Matrix factorization models require reservations. For more information, see Pricing.

• The following remote models require a Cloud resource connection:

  • Remote models over Vertex AI and partner models
  • Remote models over open models
  • Remote models over Cloud AI services
  • Remote models over custom models in Vertex AI

  The connection's service account must also be granted certain roles, depending on the type of remote model.

• To import a model, you must have that model uploaded to a Cloud Storage bucket.

Create a BigQuery dataset to contain your resources:

1. In the Google Cloud console, go to the BigQuery page.

   Go to the BigQuery page

2. In the Explorer pane, click your project name.

3. Click more_vert View actions > Create dataset.

4. On the Create dataset page, do the following:

   • For Dataset ID, type a name for the dataset.

   • For Location type, select a location for the dataset.

   • Click Create dataset.

1. To create a new dataset, use the bq mk command with the --location flag:

   bq --location=LOCATION mk -d DATASET_ID

   Replace the following:

   • LOCATION: the dataset's location.
   • DATASET_ID is the ID of the dataset that you're creating.

2. Confirm that the dataset was created:

   bq ls

Use this procedure to create the following types of models:

• Time series models:

  • ARIMA_PLUS
  • ARIMA_PLUS_XREG

• Contribution analysis: Contribution analysis

• Classification:

  • Logistic regression
  • Boosted tree classification
  • Random forest classification
  • Deep Neural network (DNN) classification
  • Wide-and-deep classification
  • AutoML classification

• Regression:

  • Linear regression
  • Boosted tree regression
  • Random forest regression
  • Deep Neural network (DNN) regression
  • Wide-and-deep regression
  • AutoML regression

• Clustering: K-means

• Recommendation: Matrix factorization

• Dimensionality reduction:

  • Principal component analysis (PCA)
  • Autoencoder

These models have different sets of options according to their type. While BigQuery ML automatic tuning works well in most cases, you can choose to manually tune your model as part of the procedure. If you want to do so, refer to the documentation for the given type of model to learn more about the model options.

To create a model:

1. Go to the BigQuery page.

   Go to BigQuery

2. In the Explorer pane, click the dataset that you created.

3. Click more_vert View actions next to the dataset, and then click Create BQML Model.

   The Create new model pane opens.

4. For Model name, type a name for the model.

5. If you want to create a saved query that contains the CREATE MODEL statement for the model, select Save Query .

   1. For Query name, type a name for the saved query.
   2. For Region, choose a region for the saved query.

6. Click Continue.

7. In the Creation method section, select Train a Model in BigQuery.

8. In the Modeling objective section, select a modeling objective for the model.

9. Click Continue.

10. On the Model options page, select a model type. The type of model you can select varies based on the modeling objective you chose.

11. In the Training data section, do one of the following:

    • Select Table/View to get training data from a table or view, and then select the project, dataset, and view or table name.
    • Select Query to get training data from a saved query, and then select the saved query.

12. In Selected input label columns, choose the columns from the table, view, or query that you want to use as input to the model.

13. If there is a Required options section, specify the requested column information:

    • For classification and regression models, for INPUT_LABEL_COLS, select the column that contains the label data.

    • For matrix factorization models, select the following:

      • For RATING_COL, select the column that contains the rating data.
      • For USER_COL, select the column that contains the user data.
      • For ITEM_COL, select the column that contains the item data.

    • For times series forecasting models, select the following:

      • For TIME_SERIES_TIMESTAMP_COL, select the column that contains the time points to use when training the model.
      • For TIME_SERIES_DATA_COL, select the column that contains the data to forecast.

14. Optional: In the Optional section, specify values for additional model tuning arguments. The arguments available vary based on the type of model that you are creating.

15. Click Create model.

16. When model creation is complete, click Go to model to view model details.

Use this procedure to create the following types of remote models:

• Models over Vertex AI or partner models
• Models over open models

To create a model:

1. Go to the BigQuery page.

   Go to BigQuery

2. In the Explorer pane, click the dataset that you created.

3. Click more_vert View actions next to the dataset, and then click Create BQML Model.

   The Create new model pane opens.

4. For Model name, type a name for the model.

5. If you want to create a saved query that contains the CREATE MODEL statement for the model, select Save Query .

   1. For Query name, type a name for the saved query.
   2. For Region, choose a region for the saved query.

6. Click Continue.

7. In the Creation method section, select Connect to Vertex AI LLM service and Cloud AI services.

8. On the Model options page, select Google and Partner Models or Open Models for the model type, as appropriate for your use case.

9. In the Remote connection section, do the one of the following:

   • If you have a default connection configured, or if you have both the BigQuery Admin and the Project IAM Admin roles, select Default connection.

   • If you don't have have a default connection configured, or if you lack the appropriate roles, select Cloud resource connection.

     1. For Project, select the project that contains the connection that you want to use.
     2. For Location, select the location used by the connection.

     3. For Connection, select the connection to use for the remote model, or select Create new connection to create a new connection.

        Important: If you create a new connection, you must grant appropriate roles to the connection's service account before continuing. For more information about what roles to grant, see the reference documentation for the type of remote model that you are creating.

10. In the Required options section, do one of the following:

    • For remote models over Google models and partner models, specify the endpoint to use. This is the name of the model, for example gemini-2.0-flash. For more information about supported models, see ENDPOINT.
    • For remote models over open models, copy and paste in the endpoint to use. This is the shared public endpoint of a model deployed to Vertex AI, in the format https://location-aiplatform.googleapis.com/v1/projects/project/locations/location/endpoints/endpoint_id. For more information, see ENDPOINT.

11. Click Create model.

12. When model creation is complete, click Go to model to view model details.

Use this procedure to create remote models over custom models deployed to Vertex AI.

To create a model:

1. Go to the BigQuery page.

   Go to BigQuery

2. In the Explorer pane, click the dataset that you created.

3. Click more_vert View actions next to the dataset, and then click Create BQML Model.

   The Create new model pane opens.

4. For Model name, type a name for the model.

5. If you want to create a saved query that contains the CREATE MODEL statement for the model, select Save Query .

   1. For Query name, type a name for the saved query.
   2. For Region, choose a region for the saved query.

6. Click Continue.

7. In the Creation method section, select Connect to user managed Vertex AI endpoints.

8. In the Remote connection section of the Model options page, do one of the following:

   • If you have a default connection configured, or if you have both the BigQuery Admin and the Project IAM Admin roles, select Default connection.

   • If you don't have have a default connection configured, or if you lack the appropriate roles, select Cloud resource connection.

     1. For Project, select the project that contains the connection that you want to use.
     2. For Location, select the location used by the connection.

     3. For Connection, select the connection to use for the remote model, or select Create new connection to create a new connection.

        Important: If you create a new connection, you must grant appropriate roles to the connection's service account before continuing. For more information about what roles to grant, see the reference documentation for the type of remote model that you are creating.

9. In the Required options section, specify the endpoint to use. This is the shared public endpoint of a model deployed to Vertex AI, in the format https://location-aiplatform.googleapis.com/v1/projects/project/locations/location/endpoints/endpoint_id. For more information, see ENDPOINT.

10. Click Create model.

11. When model creation is complete, click Go to model to view model details.

Use this procedure to create remote models over Cloud AI services.

To create a model:

1. Go to the BigQuery page.

   Go to BigQuery

2. In the Explorer pane, click the dataset that you created.

3. Click more_vert View actions next to the dataset, and then click Create BQML Model.

   The Create new model pane opens.

4. For Model name, type a name for the model.

5. If you want to create a saved query that contains the CREATE MODEL statement for the model, select Save Query .

   1. For Query name, type a name for the saved query.
   2. For Region, choose a region for the saved query.

6. Click Continue.

7. In the Creation method section, select Connect to Vertex AI LLM service and Cloud AI services.

8. On the Model options page, select Cloud AI Services.

9. In the Remote connection section, do the one of the following:

   • If you have a default connection configured, or if you have both the BigQuery Admin and the Project IAM Admin roles, select Default connection.

   • If you don't have have a default connection configured, or if you lack the appropriate roles, select Cloud resource connection.

     1. For Project, select the project that contains the connection that you want to use.
     2. For Location, select the location used by the connection.

     3. For Connection, select the connection to use for the remote model, or select Create new connection to create a new connection.

        Important: If you create a new connection, you must grant appropriate roles to the connection's service account before continuing. For more information about what roles to grant, see the reference documentation for the type of remote model that you are creating.

10. In the Required options section, select the Cloud AI service type to use.

11. In the Optional section, specify document processor information if you are using the CLOUD_AI_DOCUMENT_V1 service. Optionally, you can specify speech recognizer information if you are using the CLOUD_AI_SPEECH_TO_TEXT_V2 service.

12. Click Create model.

13. When model creation is complete, click Go to model to view model details.

Use this procedure to create BigQuery ML models by importing the following types of models:

• ONNX
• TensorFlow
• TensorFlow Lite
• XGBoost

To create a model:

1. Go to the BigQuery page.

   Go to BigQuery

2. In the Explorer pane, click the dataset that you created.

3. Click more_vert View actions next to the dataset, and then click Create BQML Model.

   The Create new model pane opens.

4. For Model name, type a name for the model.

5. If you want to create a saved query that contains the CREATE MODEL statement for the model, select Save Query .

   1. For Query name, type a name for the saved query.
   2. For Region, choose a region for the saved query.

6. Click Continue.

7. In the Creation method section, select Import model.

8. On the Model options page, select the type of model that you want to import.

9. For GCS path, browse for or paste in the URI for the Cloud Storage bucket that contains the model.

10. Click Create model.

11. When model creation is complete, click Go to model to view model details.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-08-07 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[],[]]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4