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 Explanation
BLOCK name Configure the name displayed on this BLOCK.
GCP service account Select the GCP service account to use with this BLOCK.
Source dataset Designate the source dataset's ID.
Source table Designate the source table's ID.
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 notes about this BLOCK.
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.
Reattempts in case of errors Configure the number of attempts to try in case of a BigQuery error or time out.
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.