Execute DML query (beta)
This BLOCK executes a BigQuery Data Manipulation Language open_in_new query.
error This BLOCK is currently in beta and may become usable after the official version is released. Please switch to using the official version at that time.
As a beta version, some features may not work as intended. We appreciate your feedback regarding bugs and ways to improve MAGELLAN BLOCKS.
|BLOCK name||Configure the name displayed on this BLOCK.|
|GCP service account||
Select the GCP service account to use with this BLOCK.
Designate a DML query to execute.
To send % format characters, like
|Query priority level||
Select the query priority level from the following:
|BLOCK memos||Make notes about this BLOCK.|
|Reattempts in case of errors||Configure the number of attempts to try in case of a request error.|
|Minimum timeout interval||Set the number of seconds to wait for results. If results are not returned during this interval, the time will be doubled for each reattempt until the time set in the Maximum timeout interval property is reached.|
|Maximum timeout interval||Indicate the maximum number of seconds to wait for results. The timeout interval will start with the value set in the Minimum timeout interval property and double with each reattempt until reaching the value set here.|
|Output query logs||
Configure whether or not to output query logs. Query logs are output with expanded variables.
Query logs are not output by default. Check this property to output query logs.