Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Membuat model dari data sampel
Pelajari cara menggunakan Looker (Google Cloud core) untuk membuat model data dasar secara otomatis dari koneksi yang disertakan dalam setiap instance.
Setiap instance Looker (Google Cloud core) dilengkapi dengan contoh project LookML yang diinstal secara default di instance. Contoh project LookML menyertakan model LookML pilihan yang didasarkan pada set data BigQuery publik the Look eCommerce. Contoh project LookML menggunakan koneksi, sample_bigquery_connection. Anda dapat menggunakan koneksi ini untuk membuat model data baru yang didasarkan pada salah satu tabel project contoh. Karena panduan memulai ini hanya untuk tujuan instruksional, Anda akan menghapus model data di akhir proses.
Sebelum memulai
Untuk mengikuti panduan memulai ini, Anda memerlukan hal berikut:
Akses ke instance Looker (Google Cloud core) yang menyertakan contoh project LookML.
Seseorang dengan peran IAM Looker Admin harus mengaktifkan BigQuery API untuk Google Cloud project yang berisi instance Looker (inti Google Cloud) Anda.
Di halaman beranda Looker (inti Google Cloud), klik ikon Main menu Looker menu dan aktifkan Mode Pengembangan dengan memilih tombol Development Mode di bagian bawah menu.
Di halaman beranda Looker (inti Google Cloud), klik tombol Create di menu navigasi utama untuk membuka menu drop-down.
Dari menu drop-down, pilih LookML Model untuk membuka halaman Create a Model.
Tentukan model Anda
Di halaman Create a Model, ikuti langkah-langkah berikut:
Di bagian Select Database Connection, pilih sample_bigquery_connection dari menu drop-down.
Pilih tombol pilihan untuk menambahkan model ke project sample_thelook_ecommerce, lalu klik Next.
Di bagian Select Tables, biarkan project Google Cloud default di kolom Select GCP project.
Di kolom Datasets, pilih bq_dataset.
Klik panah di sebelah kanan bq_dataset untuk membuka kolom Tables.
Di kolom Tables, pilih bq_table.
Klik panah di sebelah kanan bq_table untuk membuka kolom Kolom.
Di kolom Kolom, pilih semua kolom, lalu klik Berikutnya.
Di bagian Select Primary Keys, pilih Name sebagai kunci utama, lalu klik Next.
Di bagian Select Explores to Create, pilih file bq_table.view, lalu klik Next.
Di bagian Enter Model Name, masukkan nama model yang unik.
Klik tombol Selesaikan dan Lihat Model. Tindakan ini akan mengarahkan Anda ke IDE Looker.
Melihat model Anda
Setelah Anda melengkapi semua kolom di halaman Create a Model, lihat model yang dihasilkan Looker.
Melihat file model di IDE Looker
Setelah mengklik tombol Complete and View Model, Anda akan berada di Looker IDE. Di browser file IDE, Anda akan melihat folder untuk model LookML contoh yang sudah ada, yaitu 0_start_here, 1_basic_lookml, 2_intermediate_lookml, dan 3_advanced_lookml. Anda juga akan melihat folder yang dibuat untuk model yang dihasilkan, models, dan views.
Luaskan folder models dan views untuk melihat file LookML yang dibuat Looker untuk model yang Anda tentukan di halaman Buat Model. Titik biru di samping setiap file menunjukkan bahwa file tersebut adalah file baru dan belum di-deploy ke produksi.
File .modelmenentukan model. Dalam file model, Anda dapat melihat koneksi yang dipilih, tampilan bq_table, serta konfigurasi default lainnya.
File bq_table.viewmenentukan tampilan. Dalam file tampilan, Anda dapat melihat kolom birthdate, name, dan rating yang dipilih serta cara kolom tersebut ditentukan dalam tabel database BigQuery, serta ukuran count default yang ditambahkan Looker.
Anda juga akan melihat file README.md yang dibuat Looker karena kotak centang Buat file Readme yang memberikan informasi selengkapnya tentang penggunaan LookML di halaman Buat Model dipilih secara default.
Melihat model di halaman Project LookML
Dari IDE, buka menu navigasi utama dengan mengklik ikon Main menu.
Jika Anda belum berada di menu Develop, klik Develop.
Lihat model Anda di kolom Models pada baris sample_thelook_ecommerce. Model ini muncul bersama model advanced_ecomm, basic_ecomm, dan intermediate_ecomm dari contoh project LookML.
Melihat Jelajah yang dibuat oleh model
Dari halaman Project, klik nama model Anda untuk kembali ke file model di IDE.
Dengan file model terbuka di IDE, klik panah Lihat tindakan file di samping nama file di bagian atas IDE.
Pilih Explore Bq Table- your_model_name dari menu drop-down. Pilihan ini akan mengarahkan Anda ke Jelajah Tabel Bq yang dibuat oleh model Anda.
Di pemilih kolom, catat dimensi Birthdate Date, Name, dan Rating yang Anda pilih di halaman Create a Model ini, serta ukuran Count default.
File model, konfigurasi model, dan Jelajahi yang telah Anda lihat hanya tersedia di cabang Git pribadi saat dalam Mode Pengembangan. Jika ingin menyediakan model ini kepada pengguna lain di instance Looker (inti Google Cloud), Anda harus melakukan commit pada perubahan, menggabungkan cabang, dan men-deploy cabang produksi. Namun, untuk tujuan memulai cepat ini, Anda akan menghapus model ini, seperti yang dijelaskan di bagian berikutnya.
Pembersihan
Untuk memaksimalkan performa Looker, model yang tidak diperlukan tidak boleh di-deploy ke produksi. Untuk mempertahankan cabang Git pribadi yang bersih dan menghindari deployment model ini ke produksi secara tidak sengaja, selesaikan langkah-langkah berikut untuk menghapus model:
Dari Jelajahi, klik link Buka LookML di pemilih kolom. Tindakan ini akan mengarahkan Anda ke IDE Looker.
Di IDE, pilih ikon Git Actions.
Di menu Git Actions, klik Revert to.
Di jendela Revert to, pastikan opsi Revert uncommitted changes dipilih, lalu klik Confirm.
Di IDE, Anda tidak akan lagi melihat file model.
Untuk menghapus konfigurasi model, buka halaman Projects dengan mengklik Projects di menu Develop.
Cari model Anda di tabel, lalu klik tombol Konfigurasi di barisnya.
Pastikan Anda berada di jendela untuk model dengan memeriksa nama di kolom Model, lalu klik Delete Model Configuration.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-08-25 UTC."],[],[],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)"]]
