[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC)：2025-09-05。"],[],[],null,["# Quickstart: Generate a model from sample data\n\nGenerate a model from sample data\n=================================\n\nLearn how to use Looker (Google Cloud core) to automatically generate a basic data model from a connection that is included in each instance.\n\nEach Looker (Google Cloud core) instance comes with the [sample LookML project](/looker/docs/looker-core-sample-project) that is installed by default on the instance. The sample LookML project includes curated LookML models that are based on the [public BigQuery dataset `the Look eCommerce`](https://console.cloud.google.com/marketplace/product/bigquery-public-data/thelook-ecommerce). The sample LookML project uses a [connection](/looker/docs/connecting-to-your-db), `sample_bigquery_connection`. You can use this connection to generate a new data model that is based on one of the sample project's tables. Since this quickstart is for instructional purposes only, you'll delete the data model at the end of the process.\n| **Tip:** To generate a model using your own connection and real data, follow the steps on the [Generating a LookML model](/looker/docs/generating-a-model) documentation page.\n\nBefore you begin\n----------------\n\nTo follow along with this quickstart, you'll need the following:\n\n- Access to a Looker (Google Cloud core) instance that includes the [sample LookML project](/looker/docs/looker-core-sample-project).\n- Someone with the [**Looker Admin** IAM role](/looker/docs/looker-core-access-control#iam-roles) must enable the BigQuery API for the Google Cloud project that contains your Looker (Google Cloud core) instance.\n\n [Enable the API](https://console.cloud.google.com/flows/enableapi?apiid=bigquery.googleapis.com)\n- You must have either the [**Looker Admin**](/looker/docs/admin-panel-users-roles#default_roles) role or the [`develop` permission](/looker/docs/admin-panel-users-roles#develop).\n\nNavigate to the Create a Model page\n-----------------------------------\n\n1. On the Looker (Google Cloud core) homepage, click the Looker **Main menu** icon menu and enable Development Mode by selecting the **Development Mode** toggle at the bottom of the menu.\n2. On the Looker (Google Cloud core) homepage, click the **Create** button in the main navigation menu to open the drop-down menu.\n3. From the drop-down menu, select **LookML Model** to open the **Create a Model** page.\n\nDefine your model\n-----------------\n\nOn the **Create a Model** page, follow these steps:\n\n1. In the **Select Database Connection** section, select `sample_bigquery_connection` from the drop-down menu.\n2. Select the radio button to add the model to the `sample_thelook_ecommerce` project, and click **Next**.\n3. In the **Select Tables** section, leave the default Google Cloud project in the **Select GCP project** field.\n4. In the **Datasets** field, select `bq_dataset`.\n5. Click the arrow to the right of `bq_dataset` to get to the **Tables** field.\n6. In the **Tables** field, select `bq_table`.\n7. Click the arrow to the right of `bq_table` to get to the **Fields** field.\n8. In the **Fields** field, select all the fields, and click **Next**.\n9. In the **Select Primary Keys** section, select **Name** as the primary key, and click **Next**.\n10. In the **Select Explores to Create** section, select the `bq_table.view` file, and click **Next**.\n11. In the **Enter Model Name** section, enter a unique model name.\n12. Click the **Complete and View Model** button. This action takes you to the Looker IDE.\n\nView your model\n---------------\n\nOnce you've completed all fields in the **Create a Model** page, view the model that Looker generated.\n\n### View the model files in the Looker IDE\n\n1. After clicking the **Complete and View Model** button, you will be in the Looker IDE. In the IDE file browser, you see the folders for the pre-existing sample LookML models, which are `0_start_here`, `1_basic_lookml`, `2_intermediate_lookml`, and `3_advanced_lookml`. You also see the folders created for the generated model, `models` and `views`.\n2. Expand the `models` and `views` folders to see the LookML files that Looker created for the model that you defined on the **Create a Model** page. The blue dot next to each file indicates that they are new files and not yet deployed to production.\n - The `.model` file [defines the model](/looker/docs/lookml-project-files#model_files). In the model file, you can see the connection that you selected, the `bq_table` view, as well as other default configurations.\n - The `bq_table.view` file [defines the view](/looker/docs/lookml-project-files#view_files). In the view file, you can see the `birthdate`, `name`, and `rating` fields that you selected and how they are defined in the BigQuery database table, as well as a default `count` measure that Looker added.\n3. You also see the `README.md` file that Looker generated because the **Generate a Readme file that gives more information about using LookML** checkbox on the **Create a Model** page was selected by default.\n\n### View the model on the LookML Projects page\n\n1. From the IDE, open the main navigation menu by clicking the **Main menu** icon.\n2. If you aren't already in the **Develop** menu, click **Develop**.\n3. From the **Develop** menu, select **Projects** to navigate to the [**LookML Projects** page](/looker/docs/manage-projects).\n4. View your model in the **Models** column of the **sample_thelook_ecommerce** row. It appears along with the `advanced_ecomm`, `basic_ecomm`, and `intermediate_ecomm` models from the sample LookML project.\n\n### View the Explore that was created by the model\n\n1. From the **Projects** page, click the name of your model to return to the model file in the IDE.\n2. With the model file open in the IDE, click the **See file actions** arrow next to the filename at the top of the IDE.\n3. Select **Explore Bq Table- your_model_name** from the drop-down menu. This selection takes you to the **Bq Table** Explore that was created by your model.\n4. In the field picker, note the **Birthdate Date** , **Name** , and **Rating** dimensions that you selected on this **Create a Model** page, as well as the default **Count** measure.\n\n| **Note:** The model that has been generated doesn't contain data, so running a query on the Explore will return no results.\n\nThe model files, model configuration, and Explore that you've viewed are available only in your [personal Git branch](/looker/docs/version-control-and-deploying-changes#working_with_git_branches) while in Development Mode. If you wanted to make this model available to other users in your Looker (Google Cloud core) instance, you would [commit your changes, merge your branch, and deploy the production branch](/looker/docs/version-control-and-deploying-changes#getting_your_changes_to_production). However, for the purposes of this quickstart, you will delete this model, as described in the next section.\n\nClean up\n--------\n\nTo maximize Looker performance, unnecessary models shouldn't be deployed to production. To maintain a clean personal Git branch and avoid accidentally deploying this model to production, complete the following steps to delete the model:\n\n1. From the Explore, click the **Go to LookML** link in the field picker. This action takes you to the Looker IDE.\n2. In IDE, select the **Git Actions** icon.\n3. In the **Git Actions** menu, click **Revert to**.\n4. In the **Revert to** window, make sure that the **Revert uncommitted changes** option is selected, and click **Confirm**.\n\n | **Tip:** If you want to see if there are other changes in your working branch, click **View Changes** before clicking **Confirm**.\n5. In the IDE, you should no longer see your model files.\n\n6. To delete the model configuration, navigate to the **Projects** page by clicking **Projects** in the **Develop** menu.\n\n7. Locate your model in the table, and click the **Configure** button in its row.\n\n8. Make sure you are in the window for your model by checking the name in the **Model** field, and click **Delete Model Configuration**.\n\nWhat's next\n-----------\n\n- [Generating a LookML model](/looker/docs/generating-a-model)\n- [Looker IDE overview](/looker/docs/looker-ide)\n- [Managing LookML files and folders](/looker/docs/creating-project-files)\n- [Common LookML patterns](/looker/docs/additional-lookml-basics)\n- [Using version control and deploying](/looker/docs/version-control-and-deploying-changes)"]]
