The ML Accelerator is a purpose-built Looker application designed to give business users access to BigQuery and Vertex AI's machine learning capabilities. It provides a user-friendly interface designed to guide the user through each step of creating a machine learning model. Because of its simple, no-code interface, the application serves as a pathway for business analysts to learn and use predictive analytics in Looker.

View the ML Model Creation Flow document for an example of an end-to-end user journey.

Additional configuration is required after installation. A Looker Admin should complete the application configuration using the Installation Instructions below.

Report bugs or feature requests with this form. Contact [email protected] with questions or comments.

You will need to select a BigQuery connection during installation. The application can only be used with a single connection to prevent data from moving between connections. The connection chosen will determine which Looker Explores will be accessible from within the application.

The service account used by the BigQuery connection chosen in Step 1 should have the following IAM predefined roles.

• BigQuery Data Editor
• BigQuery Job User
• Vertex AI User

Create a dataset (e.g., looker_bqml) in the BigQuery connection's GCP project.

The application can be installed directly from Looker Marketplace (recommended) or manually installed following the steps below.

Refer to the Looker Docs for installing a tool from Marketplace. Select the BigQuery connection name chosen in Step 1 during installation.

• Fork this GitHub repository

• Create a blank LookML project named marketplace_bqml_ext

  IMPORTANT: The LookML project must be named marketplace_bqml_ext

• Connect the new LookML project to the forked repository

• Update the value of the CONNECTION_NAME constant in the manifest.lkml file

• Commit and deploy changes to production

The application uses three Looker user attributes to store its configuration settings. The following user attributes are required for the application to work properly. Each user attribute needs to be named exactly as listed below with a data type of String. The recommended setting for user access is View.

Create the following user attributes and set their default values.

The application is designed for users with access to Explores and SQL Runner in Looker. Users will need the following permissions to use the application.

• explore
• use_sql_runner

We recommend creating a new Looker role to easily manage user access to the application and guarantee users have the required permissions above.

• Create a new Looker model set named ML Accelerator containing the LookML model ml_accelerator
• Create a new Looker permission set named ML Accelerator containing all the permisions in the default User permission set AND the use_sql_runner permission
• Create a new Looker role named ML Accelerator using the new model and permission set
• Assign the ML Accelerator role to Looker users and groups

After release 2.2, the application can use text generating AI to summarize the model evaluation to more clearly communicate model performance. This optional feature requires additional setup.

In BigQuery, an external connection is required to connect it to pre-trained models in Vertex AI. If one is not already set up, you must do so. A tutorial can also be found here.

1. Under the same gcp project already in use for the application, verify the BigQuery Connection and Vertex AI APIs are both enabled.
2. In BigQuery click “add,” then "Connections to external data sources."
3. Select "BigLake and remote function" and use the same location as the dataset already in use by the application
4. The ID will be the name of your connection. Since it could be used to connect to any number of pre-trained models in vertex it is wise to choose something generic, such as “ext-vertex-ai”
5. Create the connection
6. Go to the connection and copy the service account ID. In order to access remote functions from Vertex AI, the BigQuery connection delegation service agent (of the form bqcx-[#]@gcp-sa-bigquery-condel.iam.gserviceaccount.com) that is associated with this connection must have the "Vertex AI User" role, which can be added in IAM.

In BigQuery, enter the following statement in the query editor (this code uses the suggested naming conventions for the the steps above and assumes region is US-Multi). The text-bison@002 model is suggested, but other LLM models with good performance generating text could also be used. The model_name will be later added as a User Attribute value. A suggestion for model_name is "mla-text-bison"

CREATE OR REPLACE MODEL project_id.dataset_id.model_name
  REMOTE WITH CONNECTION `us.ext-vertex-ai`
  OPTIONS (endpoint = 'text-bison@002');

This will take a few minutes to load and will not return any results.

Similar to section 5 above.