Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Sebelum Anda dapat menggunakan
Gemini in BigQuery, yang
menawarkan bantuan yang didukung AI untuk analisis data Anda, tim Anda harus melakukan
hal berikut:
Beberapa fitur Gemini in BigQuery tersedia tanpa biaya tambahan, sementara fitur lainnya memerlukan kuota yang diperoleh dengan menggunakan kapasitas komputasi. Untuk mempelajari lebih lanjut cara menggunakan fitur Gemini in BigQuery, lihat Harga Gemini in BigQuery.
Mengaktifkan API yang diperlukan dan memberikan peran
Untuk menggunakan Gemini di BigQuery, Anda harus mengaktifkan API yang diperlukan dan memberikan peran Identity and Access Management (IAM) yang diperlukan. Administrator layanan atau pemilik project dengan izin IAM serviceusage.services.enable biasanya melakukan langkah ini. Untuk mengetahui daftar API dan layanan yang digunakan oleh
BigQuery, lihat Mengelola dependensi BigQuery API.
Di konsol Google Cloud , dengan project Anda dipilih, buka halaman
BigQuery Studio.
Melihat fitur Gemini in BigQuery di
konsol Google Cloud . Misalnya, di BigQuery Studio, arahkan kursor ke ikon pen_sparkarrow_drop_downGemini.
Anda akan diminta untuk mengaktifkan Google Cloud API tambahan.
Klik Continue untuk mulai mengaktifkan Google Cloud API yang diperlukan. Panel samping mencantumkan API yang diperlukan untuk menggunakan Gemini di BigQuery.
Untuk setiap API yang diperlukan, klik Aktifkan untuk mengaktifkan API bagi project saat ini, lalu klik Berikutnya.
Untuk memberikan peran IAM yang diperlukan untuk menggunakan Gemini di BigQuery kepada akun utama, masukkan nama pengguna mereka.
Peran berikut memberikan izin yang diperlukan untuk menggunakan Gemini:
Jika Anda seorang analis data, ilmuwan data, atau developer yang ingin menggunakan fitur Gemini in BigQuery tertentu untuk menulis kueri SQL dan kode Python, Anda harus mengaktifkan fitur tersebut di konsol Google Cloud . Untuk mempelajari cara mengaktifkan fitur, lihat
Sebelum memulai di
"Menulis kueri dengan bantuan Gemini".
Pengguna yang memiliki peran atau izin IAM yang diperlukan kemudian dapat mengakses fitur Gemini di BigQuery yang Anda aktifkan untuk project mereka Google Cloud . Untuk mengetahui informasi selengkapnya, lihat
Ringkasan Gemini untuk Google Cloud .
Menggunakan fitur insight data dan pembuatan metadata otomatis
Fitur insight data BigQuery dan pembuatan metadata otomatis tersedia bagi pelanggan yang menggunakan komputasi sesuai permintaan BigQuery, edisi Enterprise, atau edisi Enterprise Plus. Kuota untuk pemindaian insight data dan pembuatan metadata didasarkan pada penggunaan model komputasi ini di tingkat organisasi. Untuk mengetahui informasi tentang kuota untuk fitur ini, lihat
Kuota untuk Gemini di BigQuery.
Jika organisasi Anda menggunakan edisi BigQuery Standard hanya untuk komputasi, Anda dapat menggunakan Gemini Code Assist Standard, yang mencakup kemampuan insight data dan pembuatan metadata otomatis selain fitur yang tercantum dalam Ringkasan harga Gemini Code Assist Standard dan Enterprise.
Untuk mempelajari cara membeli Gemini Code Assist Standard, lihat Membeli langganan Gemini Code Assist Standard dan ikuti petunjuk untuk membeli edisi Standard.
Mengaktifkan fitur pratinjau Gemini in BigQuery
Fitur Gemini in BigQuery tertentu dalam versi
Pratinjau
adalah bagian dari program penguji tepercaya. Untuk meminta akses ke fitur ini, administrator harus mengisi formulir Pendaftaran Pra-GA Gemini di BigQuery.
Akses fitur pra-GA Gemini di BigQuery diaktifkan secara berkala dalam batch.
Fitur pratinjau yang memerlukan pendaftaran Gemini in BigQuery mencakup:
Penyelesaian kueri SQL (Pratinjau)
Pembuatan metadata otomatis untuk insight data (Pratinjau)
Ekspresi bahasa alami dalam SQL (Eksperimental)
Insight set data dengan mesin pengetahuan BigQuery (Pratinjau)
[[["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-19 UTC."],[[["\u003cp\u003eTo use Gemini in BigQuery, you must purchase either the Enterprise Plus edition or Gemini Code Assist Enterprise edition.\u003c/p\u003e\n"],["\u003cp\u003eEnabling Gemini in BigQuery requires enabling the Gemini for Google Cloud API and, optionally, the Recommender API for certain features.\u003c/p\u003e\n"],["\u003cp\u003eGranting users access to Gemini in BigQuery involves assigning them the Gemini for Google Cloud User IAM role, along with other feature-specific roles if needed.\u003c/p\u003e\n"],["\u003cp\u003eCertain preview features, like SQL query completion and Apache Spark assisted troubleshooting, require signing up through the Gemini in BigQuery Pre-GA Sign-up form.\u003c/p\u003e\n"],["\u003cp\u003eData analysts, scientists, or developers need to turn on Gemini in BigQuery features in the Google Cloud console to utilize AI-assisted SQL query and Python code writing.\u003c/p\u003e\n"]]],[],null,["# Set up Gemini in BigQuery\n\nBefore you can use\n[Gemini in BigQuery](/gemini/docs/bigquery/overview), which\noffers AI-powered assistance for your data analytics, your team must do\nthe following:\n\n1. [Enable necessary APIs and grant roles.](#enable-api)\n2. [Turn on Gemini in BigQuery features in\n the Google Cloud console.](#use)\n\nSome Gemini in BigQuery features are available at no\nadditional charge while other features require [quota](/gemini/docs/quotas#bigquery)\nwhich is earned by using compute capacity. To learn more about using\nGemini in BigQuery features, see [Gemini\nin BigQuery pricing](/gemini/pricing#gemini-in-bigquery-pricing).\n| **Note** : Gemini in BigQuery is part of Gemini for Google Cloud and doesn't support the same compliance and security offerings as BigQuery. You should only set up Gemini in BigQuery for BigQuery projects that don't require [compliance offerings that aren't supported by Gemini for Google Cloud](/gemini/docs/discover/certifications). For information about how to turn off or prevent access to Gemini in BigQuery, see [Turn off Gemini for Google Cloud products](/gemini/docs/turn-off-gemini).\n\nEnable necessary APIs and grant roles\n-------------------------------------\n\nTo use Gemini in BigQuery,\nyou must enable required APIs and grant necessary Identity and Access Management (IAM)\nroles. A service administrator or project\nowner with the [`serviceusage.services.enable` IAM permission](/service-usage/docs/access-control#predefined_roles)\ntypically performs this step. For a list of APIs and services used by\nBigQuery, see [Manage BigQuery API dependencies](/bigquery/docs/service-dependencies).\n\n1. In the the Google Cloud console, with your project selected, go to the\n **BigQuery Studio** page.\n\n [Go to BigQuery Studio](https://console.cloud.google.com/bigquery)\n2. View a Gemini in BigQuery feature in the\n the Google Cloud console. For example, in BigQuery Studio hover\n over the\n pen_sparkarrow_drop_down**Gemini**\n icon.\n\n You are prompted to enable additional Google Cloud APIs.\n3. Click **Continue** to get started enabling required\n Google Cloud APIs. A side panel lists the required APIs\n required to use Gemini in BigQuery.\n\n4. For each required API, click **Enable** to enable the API for the current\n project, and then click **Next**.\n\n5. To grant principals the IAM roles that are required to use\n Gemini in BigQuery, enter their user names.\n The following roles grant the permissions required to use Gemini:\n\n - [BigQuery Studio User](/bigquery/docs/access-control#bigquery.studioUser)\n - [BigQuery Studio Admin](/bigquery/docs/access-control#bigquery.studioAdmin)\n6. Click **Done**.\n\nTurn on Gemini in BigQuery features\n-----------------------------------\n\nIf you're a data analyst, data scientist, or developer who wants to use\nspecific Gemini in BigQuery features to write\nSQL queries and Python code, then you need to turn on the feature in\nthe Google Cloud console. To learn how to turn on features, see\n[Before you begin](/bigquery/docs/write-sql-gemini#before_you_begin) in\n\"Write queries with Gemini assistance.\"\nUsers who have the necessary IAM roles or permissions can then access\nthe Gemini in BigQuery features that you enabled\nfor their Google Cloud project. For more information, see\n[Gemini for Google Cloud overview](/gemini/docs/overview).\n\n### Use data insights and automated metadata generation features\n\nBigQuery data insights and automated metadata generation features\nare available to customers using BigQuery on-demand compute,\nEnterprise edition, or Enterprise Plus edition. The quota for\ndata insights scans and metadata generation is based on the use of these\ncompute models at the\norganization level. For information about quotas for these features, see\n[Quotas for Gemini in BigQuery](/gemini/docs/quotas#bigquery).\n\nIf your organization is using BigQuery Standard edition\nfor compute only, then you can use Gemini Code Assist Standard, which\nincludes data insights and automated metadata generation capabilities in\naddition to features listed in [Gemini Code Assist Standard and\nEnterprise pricing\noverview](/products/gemini/pricing#gemini_code_assist_standard_and_enterprise_pricing_overview).\nTo learn how to purchase Gemini Code Assist Standard, see [Purchase a\nGemini Code Assist Standard\nsubscription](/gemini/docs/discover/set-up-gemini#purchase-subscription) and\nfollow the instructions to purchase Standard edition.\n\n### Enable Gemini in BigQuery preview features\n\nCertain Gemini in BigQuery features in\n[Preview](/products#product-launch-stages)\nare part of the trusted tester program. To request access to these features,\nan administrator must complete the\n[Gemini in BigQuery Pre-GA Sign-up form](https://goo.gle/gemini-in-bq-preview).\nGemini in BigQuery pre-GA feature access is\nenabled periodically in batches.\n\nPreview features that require Gemini in BigQuery\nsign-up include the following:\n\n- SQL query completion (Preview)\n- Automated metadata generation for data insights (Preview)\n- Natural language expressions in SQL (Experimental)\n- Dataset insights with BigQuery knowledge engine (Preview)\n\nWhat's next\n-----------\n\n- Learn more about the [types of generative AI assistance available in Gemini for Google Cloud](/gemini/docs/overview).\n- Learn [how Gemini for Google Cloud uses your data](/gemini/docs/discover/data-governance).\n- Learn [how to access and manage Gemini administrator controls](/gemini/docs/admin)."]]
