Vertex AI Search for retail is being renamed to Vertex AI Search for commerce. We're updating content to reflect the new branding.

BigQuerySource

JSON representation

BigQuery source import data from.

JSON representation

JSON representation
{ "projectId" : string , "datasetId" : string , "tableId" : string , "gcsStagingDir" : string , "dataSchema" : string , // Union field `partition` can be only one of the following: "partitionDate" : { object ( `Date` ) } // End of list of possible types for union field `partition` . }

 { 
 "projectId" 
 : 
 string 
 , 
 "datasetId" 
 : 
 string 
 , 
 "tableId" 
 : 
 string 
 , 
 "gcsStagingDir" 
 : 
 string 
 , 
 "dataSchema" 
 : 
 string 
 , 
 // Union field partition 
can be only one of the following: 
 "partitionDate" 
 : 
 { 
 object (  Date 
 
) 
 } 
 // End of list of possible types for union field partition 
. 
 }

Fields

projectId

string

The project ID (can be project # or ID) that the BigQuery source is in with a length limit of 128 characters. If not specified, inherits the project ID from the parent request.

datasetId

string

Required. The BigQuery data set to copy the data from with a length limit of 1,024 characters.

tableId

string

Required. The BigQuery table to copy the data from with a length limit of 1,024 characters.

gcsStagingDir

string

Intermediate Cloud Storage directory used for the import with a length limit of 2,000 characters. Can be specified if one wants to have the BigQuery export to a specific Cloud Storage directory.

dataSchema

string

The schema to use when parsing the data from the source.

Supported values for product imports:

product (default): One JSON Product per line. Each product must have a valid Product.id .
product_merchant_center : See Importing catalog data from Merchant Center .

Supported values for user events imports:

user_event (default): One JSON UserEvent per line.
user_event_ga360 : The schema is available here: https://support.google.com/analytics/answer/3437719 .
user_event_ga4 : The schema is available here: https://support.google.com/analytics/answer/7029846 .

Supported values for autocomplete imports:

suggestions (default): One JSON completion suggestion per line.
denylist : One JSON deny suggestion per line.
allowlist : One JSON allow suggestion per line.

Union field partition . BigQuery table partition info. Leave this empty if the BigQuery table is not partitioned. partition can be only one of the following:

partitionDate

object ( Date )

BigQuery time partitioned table's _PARTITIONDATE in YYYY-MM-DD format.

BigQuerySource Stay organized with collections Save and categorize content based on your preferences.

BigQuerySource