Manipulation
These functions are used to manipulate data in existing tables.
Functions
insert_data
| Attribute | Value |
|---|---|
| Name | insert_data |
| ID | bqtools.[region].insert_data |
| Description | Inserts data into an existing table using the INSERT DML Statement. The schema of the data returned by executing the insert_sql STRING must exactly match the destination table. |
| Type | PROCEDURE |
| Arguments | destination_table_id STRING, insert_sql STRING |
| Returns | None |
| Dependencies | bqtools-qb.[region].insert_data |
execution: insert
CALL bqtools.eu.insert_data(destination_table_id, insert_sql);
CALL bqtools.us.insert_data(destination_table_id, insert_sql);