def skip_leading_rows(self):
"""int: The number of rows at the top of a CSV file.
See
https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#CsvOptions.FIELDS.skip_leading_rows
"""
return _int_or_none(self._properties.get("skipLeadingRows"))
def skip_leading_rows(self):
"""Optional[int]: Number of rows to skip when reading data (CSV only).
See:
https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationLoad.FIELDS.skip_leading_rows
"""
return _helpers._int_or_none(self._get_sub_prop("skipLeadingRows"))
def max_bad_records(self):
"""Optional[int]: Number of invalid rows to ignore.
See:
https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationLoad.FIELDS.max_bad_records
"""
return _helpers._int_or_none(self._get_sub_prop("maxBadRecords"))
def skip_leading_rows(self):
"""int: The number of rows at the top of a CSV file.
See
https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs#configuration.query.tableDefinitions.(key).csvOptions.skipLeadingRows
https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#externalDataConfiguration.csvOptions.skipLeadingRows
"""
return _int_or_none(self._properties.get("skipLeadingRows"))
def skip_leading_rows(self):
"""int: The number of rows at the top of a sheet that BigQuery will
skip when reading the data.
See
https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#GoogleSheetsOptions.FIELDS.skip_leading_rows
"""
return _int_or_none(self._properties.get("skipLeadingRows"))
def skip_leading_rows(self):
"""int: The number of rows at the top of a sheet that BigQuery will
skip when reading the data.
See
https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs#configuration.query.tableDefinitions.(key).googleSheetsOptions.skipLeadingRows
https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#externalDataConfiguration.googleSheetsOptions.skipLeadingRows
"""
return _int_or_none(self._properties.get('skipLeadingRows'))
def input_files(self):
"""Count of source files.
Returns:
Optional[int]: the count (None until set from the server).
"""
return _helpers._int_or_none(
_helpers._get_sub_prop(self._properties,
["statistics", "load", "inputFiles"]))
def output_rows(self):
"""Count of rows saved to destination table.
Returns:
Optional[int]: the count (None until set from the server).
"""
return _helpers._int_or_none(
_helpers._get_sub_prop(self._properties,
["statistics", "load", "outputRows"]))
def skip_leading_rows(self):
"""int: The number of rows at the top of a sheet that BigQuery will
skip when reading the data.
See
https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs#configuration.query.tableDefinitions.(key).googleSheetsOptions.skipLeadingRows
https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#externalDataConfiguration.googleSheetsOptions.skipLeadingRows
"""
return _int_or_none(self._properties.get('skipLeadingRows'))
def input_file_bytes(self):
"""Count of bytes loaded from source files.
Returns:
Optional[int]: the count (None until set from the server).
Raises:
ValueError: for invalid value types.
"""
return _helpers._int_or_none(
_helpers._get_sub_prop(self._properties,
["statistics", "load", "inputFileBytes"]))
def from_api_repr(cls, resource):
"""Factory: construct a CSVOptions given its API representation
:type resource: dict
:param resource:
A CSVOptions in the same representation as is
returned from the API.
:rtype: :class:`~google.cloud.bigquery.external_config.CSVOptions`
:returns: Configuration parsed from ``resource``.
"""
slr = resource.get('skipLeadingRows')
config = cls()
config._properties = copy.deepcopy(resource)
config.skip_leading_rows = _int_or_none(slr)
return config
def from_api_repr(cls, resource):
"""Factory: construct a CSVOptions given its API representation
:type resource: dict
:param resource:
A CSVOptions in the same representation as is
returned from the API.
:rtype: :class:`~google.cloud.bigquery.external_config.CSVOptions`
:returns: Configuration parsed from ``resource``.
"""
slr = resource.get('skipLeadingRows')
config = cls()
config._properties = copy.deepcopy(resource)
config.skip_leading_rows = _int_or_none(slr)
return config
def end_line(self):
"""int: One-based end line."""
return _helpers._int_or_none(self._properties.get("endLine"))
def _call_fut(self, value):
from google.cloud.bigquery._helpers import _int_or_none
return _int_or_none(value)
def _call_fut(self, value):
from google.cloud.bigquery._helpers import _int_or_none
return _int_or_none(value)
def start_line(self):
"""int: One-based start line."""
return _helpers._int_or_none(self._properties.get("startLine"))
def start_column(self):
"""int: One-based start column."""
return _helpers._int_or_none(self._properties.get("startColumn"))
def end_column(self):
"""int: One-based end column."""
return _helpers._int_or_none(self._properties.get("endColumn"))
