BigQuery
Get table contents (beta)
Overview
This BLOCK loads the contents of a table into a variable. It can get a maximum of 1,000 records.
With this BLOCK, you can easily get the contents of a table without writing a query. However, you cannot narrow down which records to get, how to order them, or other fine adjustments that you can do with the Execute query BLOCK.
info_outline This BLOCK cannot get records that were loaded via Stream Insert.
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.
Properties
| Property | Explanation |
|---|---|
| BLOCK name |
Configure the name displayed on this BLOCK. |
| GCP service account |
Select the GCP service account to use with this BLOCK. |
| Dataset |
Designate the dataset that contains the table whose contents you want to load into a variable. Supports % format characters and variable expansion. |
| Table |
Designate the table whose contents you want to load into a variable. Supports % format characters and variable expansion. |
| Destination variable |
Designate the variable that will store the contents of the table. |
| BLOCK memos |
Make notes about this BLOCK. |