pulumi-gcp-kotlin/com.pulumi.gcp.bigquery.kotlin.outputs/TableExternalDataConfigurationGoogleSheetsOptions

TableExternalDataConfigurationGoogleSheetsOptions

data class TableExternalDataConfigurationGoogleSheetsOptions(val range: String? = null, val skipLeadingRows: Int? = null)

Constructors

constructor(range: String? = null, skipLeadingRows: Int? = null)

Types

Link copied to clipboard
object Companion

Properties

Link copied to clipboard
val range: String? = null

Range of a sheet to query from. Only used when non-empty. At least one of range or skip_leading_rows must be set. Typical format: "sheet_name!top_left_cell_id:bottom_right_cell_id" For example: "sheet1!A1:B20"

Link copied to clipboard
val skipLeadingRows: Int? = null

The number of rows at the top of the sheet that BigQuery will skip when reading the data. At least one of range or skip_leading_rows must be set.