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.