CData Power BI Connector for Google BigQuery 2019 - Online Help
Questions / Feedback?

INSERT Statements

CData Power BI Connector for Google BigQuery 2019 - Build 19.0.7354

To create new records, use INSERT statements. This statement can be accessed using the Odbc.Query function in the M formula language.

INSERT Syntax

The INSERT statement specifies the columns to be inserted and the new column values. You can specify the column values in a comma-separated list in the VALUES clause, as shown in the following example:

INSERT INTO <table_name> 
( <column_reference> [ , ... ] )
VALUES 
( { <expression> | NULL } [ , ... ] ) 
  

<expression> ::=
  | @ <parameter> 
  | ?
  | <literal>
The following is an example query:
INSERT INTO publicdata.samples.github_nested (repository.name) VALUES ('CoreCLR')

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0