tabledata

Creates, updates, deletes, gets or lists a tabledata resource.

Overview

Name	tabledata
Type	Resource
Id	google.bigquery.tabledata

Fields

Name	Datatype	Description
etag	string	A hash of this page of results.
kind	string	The resource type of the response.
pageToken	string	A token used for paging results. Providing this token instead of the startIndex parameter can help you retrieve stable results when an underlying table is changing.
rows	array	Rows of results.
totalRows	string	Total rows of the entire table. In order to show default value 0 we have to present it as string.

Methods

Name	Accessible by	Required Params	Description
list	SELECT	+datasetId, +tableId, projectId	List the content of a table in rows.
insert_all	INSERT	+datasetId, +tableId, projectId	Streams data into BigQuery one record at a time without needing to run a load job.

SELECT examples

List the content of a table in rows.

SELECT
etag,
kind,
pageToken,
rows,
totalRows
FROM google.bigquery.tabledata
WHERE +datasetId = '{{ +datasetId }}'
AND +tableId = '{{ +tableId }}'
AND projectId = '{{ projectId }}';

INSERT example

Use the following StackQL query and manifest file to create a new tabledata resource.

All Properties

/*+ create */
INSERT INTO google.bigquery.tabledata (
+datasetId,
+tableId,
projectId,
ignoreUnknownValues,
rows,
skipInvalidRows,
templateSuffix,
traceId
)
SELECT 
'{{ +datasetId }}',
'{{ +tableId }}',
'{{ projectId }}',
{{ ignoreUnknownValues }},
'{{ rows }}',
{{ skipInvalidRows }},
'{{ templateSuffix }}',
'{{ traceId }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: ignoreUnknownValues
      value: boolean
    - name: kind
      value: string
    - name: rows
      value:
        - - name: insertId
            value: string
          - name: json
            value: []
    - name: skipInvalidRows
      value: boolean
    - name: templateSuffix
      value: string
    - name: traceId
      value: string