BLOCKS Reference

Block Reference

BigQuery

Table content Slack notice

This BLOCK notifies Slack about BigQuery table contents.

It acquires information regarding the content of a specified table, beginning with the leading row and continuing until the tenth row, points to the row with JSON and sends a notification to Slack.

Property name Explanation
BLOCK name Designate a name for BLOCKS. The names will be displayed on the BLOCKS.
GCP service account Select the GCP service account for use with this BLOCK.
Acquisition source data set Designate an ID for the acquisition source data set.
Acquisition source table Designate an ID for the acquisition source table.
Webhook URL Designate a Slack Webhook URL.
Slack display name Designate a username for Slack notification. If omitted, the user listed at the time of acquiring Webhook will be used.
Channel Designate a channel for Slack notification. If omitted, the channel listed at the time of acquiring Webhook will be used.
Icon Designate an icon for Slack notification. If omitted, the icon listed at the time of acquiring Webhook will be used.
Header Designate a message to display before table content.
Footer Designate a message to display after table content.
BLOCK memos Make any comments regarding BLOCKS.
Maximum number of acquirable rows (Maximum: 10 rows) Designate the maximum number of rows to acquire from tables. Even if you specify a number greater than 10, only 10 rows will be retrieved.
Repetition attempts Designate the number of repetitions to occur in the case of an error or time out in BigQuery.
Minimum duration for time out Indicate how many seconds to wait for a response (time out) in BigQuery. It will double with every repetition. The maximum value for the time increase between repetitions is set under 'Maximum duration for time out" in the properties.
Maximum duration for time out As time outs increase from the "Minimum duration for time out", they reach a maximum value. It is defined in units of seconds.