Beberapa produk dan fitur sedang dalam proses penggantian nama. Fitur playbook dan alur generatif juga dimigrasikan ke satu konsol gabungan. Lihat detailnya.
Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Anda dapat mengekspor
logging interaksi
ke
BigQuery.
Setelah dikonfigurasi, semua logging interaksi live akan ditulis ke tabel BigQuery Anda.
Hal ini memberi Anda alat analisis lanjutan
yang dapat membantu Anda men-debug dan meningkatkan kualitas agen
serta menemukan pola dalam data percakapan.
Batasan
Batasan berikut berlaku:
Maksimum 500 giliran dapat diekspor untuk setiap percakapan.
Izin lintas project
Jika agen Dialogflow dan data BigQuery Anda tidak berada dalam project yang sama, akun layanan yang terkait dengan project Dialogflow Google Cloud Anda juga harus memiliki izin IAM roles/bigquery.dataEditor untuk set data BigQuery di project BigQuery Google Cloud Anda.
Format akun layanan: service-<dialogflow-project-number>@gcp-sa-dialogflow.iam.gserviceaccount.com
Pengguna yang mengonfigurasi ekspor di Dialogflow harus memiliki izin di project BigQuery. Jika tidak, project BigQuery tidak akan muncul sebagai opsi di Dialogflow Console.
Izin minimum yang diperlukan di project BigQuery agar
pengguna dapat melihatnya di Dialogflow adalah resourcemanager.projects.get.
Atau, Anda dapat menetapkan salah satu peran standar Google Cloud berikut yang menyertakan izin ini, tetapi tidak mengharuskan pengguna memiliki akses ke set data BigQuery: roles/browser atau roles/bigquery.metadataViewer.
Deskripsi tabel
Setiap baris tabel berisi satu giliran percakapan dengan kolom berikut:
Kolom
Jenis
Deskripsi
project_id
STRING
Project ID.
agent_id
STRING
ID agen.
conversation_name
STRING
Nama resource yang sepenuhnya memenuhi syarat untuk sesi.
[[["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-18 UTC."],[[["\u003cp\u003eDialogflow interaction logs can be exported to BigQuery, enabling advanced analysis for debugging, agent improvement, and identifying conversation patterns.\u003c/p\u003e\n"],["\u003cp\u003eA maximum of 500 turns per conversation can be exported, and if the Dialogflow agent and BigQuery data are in different projects, the Dialogflow service account needs \u003ccode\u003eroles/bigquery.dataEditor\u003c/code\u003e permission on the BigQuery dataset.\u003c/p\u003e\n"],["\u003cp\u003eEach row in the exported BigQuery table represents a single conversational turn and contains columns such as project ID, agent ID, conversation name, turn number, request/response details, and additional metadata.\u003c/p\u003e\n"],["\u003cp\u003eTo configure the export, interaction logging must be enabled, a BigQuery dataset and table must be created using the provided SQL schema, and the agent settings must be updated with the dataset and table names.\u003c/p\u003e\n"],["\u003cp\u003eUsers configuring the export must have permissions on the BigQuery project, with the minimum being \u003ccode\u003eresourcemanager.projects.get\u003c/code\u003e or one of the roles \u003ccode\u003eroles/browser\u003c/code\u003e or \u003ccode\u003eroles/bigquery.metadataViewer\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# Interaction logging export to BigQuery\n\nYou can export\n[interaction logging](/dialogflow/cx/docs/concept/agent-settings#settings-general)\nto\n[BigQuery](/bigquery/docs).\nOnce configured, all live interaction logging is written\nto your BigQuery table.\nThis provides you with advanced analysis tools\nthat can help you debug and improve your agent\nand to discover patterns in conversation data.\n\nLimitations\n-----------\n\nThe following limitations apply:\n\n- A maximum of 500 turns can be exported for each conversation.\n\nCross project permissions\n-------------------------\n\nIf your Dialogflow agent and BigQuery data are not in the\nsame project, the [service account](/dialogflow/cx/docs/quick/setup#sa)\nassociated with your Dialogflow Google Cloud project must also have the\n`roles/bigquery.dataEditor` IAM permission for the BigQuery dataset in\nyour BigQuery Google Cloud project.\n\nService account format: `service-\u003cdialogflow-project-number\u003e@gcp-sa-dialogflow.iam.gserviceaccount.com`\n\nThe user configuring the export in Dialogflow must have permissions on\nthe BigQuery project. If they don't, the BigQuery project\nwon't appear as an option in the Dialogflow Console.\n\nThe minimum permission required on the BigQuery project in order for\nthe user to see it in Dialogflow is `resourcemanager.projects.get`.\nAlternatively, you can assign one of the following Google Cloud predefined roles\nthat include this permission but don't require the user to have access to the\nBigQuery dataset: `roles/browser` or `roles/bigquery.metadataViewer`.\n\nTable description\n-----------------\n\nEach row of the table contains one conversational turn\nwith the following columns:\n\nConfiguration\n-------------\n\nTo configure interaction logging export:\n\n1. Ensure that [interaction logging](/dialogflow/cx/docs/concept/agent-settings#settings-general) is enabled.\n2. Follow the BigQuery [dataset creation guide](/bigquery/docs/datasets#create-dataset) to create a dataset. Note the dataset name, as you will need this in the next step.\n3. Follow the BigQuery\n [table creation guide](/bigquery/docs/tables)\n to create a table with a SQL schema definition.\n Use the following SQL statement for creation:\n\n CREATE TABLE \u003cyour_dataset_name\u003e.dialogflow_bigquery_export_data(\n project_id STRING,\n agent_id STRING,\n conversation_name STRING,\n turn_position INTEGER,\n request_time TIMESTAMP,\n language_code STRING,\n request JSON,\n response JSON,\n partial_responses JSON,\n derived_data JSON,\n conversation_signals JSON,\n bot_answer_feedback JSON\n );\n\n4. Configure your\n [agent settings](/dialogflow/cx/docs/concept/agent-settings#settings-general)\n to enable BigQuery export, and to provide the dataset and table names\n created above.\n\n | **Note:** If your agent is protected by a Customer Managed Encryption Key (CMEK), you will see a warning if the destination BigQuery table is not protected by CMEK."]]
