BLOCKS Reference

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.

This BLOCK cannot get records that were loaded via Stream Insert.

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.