Mantieni tutto organizzato con le raccolte
Salva e classifica i contenuti in base alle tue preferenze.
Visualizzazione VECTOR_INDEX_COLUMNS
La vista INFORMATION_SCHEMA.VECTOR_INDEX_COLUMNS contiene una riga per ogni colonna con indice di vettore in ogni tabella di un set di dati.
Autorizzazioni obbligatorie
Per visualizzare i metadati dell'indice di vettori, devi disporre dell'autorizzazione Identity and Access Management (IAM) bigquery.tables.get o bigquery.tables.list per la tabella con l'indice. Ciascuno dei seguenti ruoli IAM predefiniti include almeno una di queste autorizzazioni:
Quando esegui una query sulla vista INFORMATION_SCHEMA.VECTOR_INDEX_COLUMNS, i risultati della query contengono una riga per ogni colonna indicizzata in ogni tabella di un set di dati.
La vista INFORMATION_SCHEMA.VECTOR_INDEX_COLUMNS ha lo schema seguente:
Nome colonna
Tipo di dati
Valore
index_catalog
STRING
Il nome del progetto che contiene il set di dati.
index_schema
STRING
Il nome del set di dati contenente l'indice vettoriale.
table_name
STRING
Il nome della tabella in cui viene creato l'indice vettoriale.
index_name
STRING
Il nome dell'indice del vettore.
index_column_name
STRING
Il nome della colonna indicizzata.
index_field_path
STRING
Il percorso completo del campo indicizzato espanso, a partire dal nome della colonna. I campi sono separati da un punto.
Ambito e sintassi
Le query su questa vista devono avere un qualificatore del set di dati. La tabella seguente illustra l'ambito della regione per questa visualizzazione:
[[["Facile da capire","easyToUnderstand","thumb-up"],["Il problema è stato risolto","solvedMyProblem","thumb-up"],["Altra","otherUp","thumb-up"]],[["Difficile da capire","hardToUnderstand","thumb-down"],["Informazioni o codice di esempio errati","incorrectInformationOrSampleCode","thumb-down"],["Mancano le informazioni o gli esempi di cui ho bisogno","missingTheInformationSamplesINeed","thumb-down"],["Problema di traduzione","translationIssue","thumb-down"],["Altra","otherDown","thumb-down"]],["Ultimo aggiornamento 2025-09-04 UTC."],[[["\u003cp\u003eThe \u003ccode\u003eINFORMATION_SCHEMA.VECTOR_INDEX_COLUMNS\u003c/code\u003e view provides metadata about each vector-indexed column within a dataset, with one row per indexed column.\u003c/p\u003e\n"],["\u003cp\u003eAccessing vector index metadata requires specific IAM permissions, such as \u003ccode\u003ebigquery.tables.get\u003c/code\u003e or \u003ccode\u003ebigquery.tables.list\u003c/code\u003e, which are included in roles like \u003ccode\u003eroles/bigquery.admin\u003c/code\u003e, \u003ccode\u003eroles/bigquery.dataViewer\u003c/code\u003e, and others.\u003c/p\u003e\n"],["\u003cp\u003eQuery results from this view include details like \u003ccode\u003eindex_catalog\u003c/code\u003e, \u003ccode\u003eindex_schema\u003c/code\u003e, \u003ccode\u003etable_name\u003c/code\u003e, \u003ccode\u003eindex_name\u003c/code\u003e, \u003ccode\u003eindex_column_name\u003c/code\u003e, and \u003ccode\u003eindex_field_path\u003c/code\u003e, providing comprehensive information about the indexed columns.\u003c/p\u003e\n"],["\u003cp\u003eQueries against the \u003ccode\u003eVECTOR_INDEX_COLUMNS\u003c/code\u003e view must specify a dataset qualifier and must be executed within the same region as the \u003ccode\u003eINFORMATION_SCHEMA\u003c/code\u003e view.\u003c/p\u003e\n"],["\u003cp\u003eThe view is queried at a dataset level, with the syntax including optional \u003ccode\u003ePROJECT_ID\u003c/code\u003e and a required \u003ccode\u003eDATASET_ID\u003c/code\u003e, and can provide insights into indexed columns across multiple tables like in the example.\u003c/p\u003e\n"]]],[],null,["# VECTOR_INDEX_COLUMNS view\n=========================\n\nThe `INFORMATION_SCHEMA.VECTOR_INDEX_COLUMNS` view contains one row for each\nvector-indexed column on each table in a dataset.\n\nRequired permissions\n--------------------\n\nTo see [vector index](/bigquery/docs/vector-index) metadata, you need the\n`bigquery.tables.get` or `bigquery.tables.list` Identity and Access Management (IAM)\npermission on the table with the index. Each of the following predefined\nIAM roles includes at least one of these permissions:\n\n- `roles/bigquery.admin`\n- `roles/bigquery.dataEditor`\n- `roles/bigquery.dataOwner`\n- `roles/bigquery.dataViewer`\n- `roles/bigquery.metadataViewer`\n- `roles/bigquery.user`\n\nFor more information about BigQuery permissions, see\n[Access control with IAM](/bigquery/docs/access-control).\n\nSchema\n------\n\nWhen you query the `INFORMATION_SCHEMA.VECTOR_INDEX_COLUMNS` view, the query results contain one row for each indexed column on each table in a dataset.\n\n\u003cbr /\u003e\n\nThe `INFORMATION_SCHEMA.VECTOR_INDEX_COLUMNS` view has the following schema:\n\nScope and syntax\n----------------\n\nQueries against this view must have a [dataset qualifier](/bigquery/docs/information-schema-intro#syntax). The\nfollowing table explains the region scope for this view:\n\n\u003cbr /\u003e\n\nReplace the following:\n\n- Optional: \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: the ID of your Google Cloud project. If not specified, the default project is used.\n- \u003cvar translate=\"no\"\u003eDATASET_ID\u003c/var\u003e: the ID of your dataset. For more information, see [Dataset qualifier](/bigquery/docs/information-schema-intro#dataset_qualifier).\n\n \u003cbr /\u003e\n\n \u003cbr /\u003e\n\n | **Note:** You must use [a region qualifier](/bigquery/docs/information-schema-intro#region_qualifier) to query `INFORMATION_SCHEMA` views. The location of the query execution must match the region of the `INFORMATION_SCHEMA` view.\n\n\u003cbr /\u003e\n\n**Example** \n\n -- Returns metadata for vector indexes in a single dataset.\n SELECT * FROM myDataset.INFORMATION_SCHEMA.VECTOR_INDEX_COLUMNS;\n\nExamples\n--------\n\nThe following query extracts information on columns that have vector indexes: \n\n```googlesql\nSELECT table_name, index_name, index_column_name, index_field_path\nFROM my_project.dataset.INFORMATION_SCHEMA.VECTOR_INDEX_COLUMNS;\n```\n\nThe result is similar to the following: \n\n```\n+------------+------------+-------------------+------------------+\n| table_name | index_name | index_column_name | index_field_path |\n+------------+------------+-------------------+------------------+\n| table1 | indexa | embeddings | embeddings |\n| table2 | indexb | vectors | vectors |\n| table3 | indexc | vectors | vectors |\n+------------+------------+-------------------+------------------+\n```"]]
