BLOCKS Reference

BigQuery

Table content Slack notice

Overview

This BLOCK sends a notification to Slack containing the contents of a BigQuery table.

It takes up to the first 10 rows of a specified table and sends a notification to Slack containing the data as JSON text.

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.

Source dataset

Designate the ID of the dataset that contains the table whose contents will be sent to Slack.

Source table

Designate the ID of the table whose contents will be sent to Slack.

Webhook URL

Designate a Slack Webhook URL.

Slack username

Designate the username to be shown for the Slack notification. If omitted, the user listed at the time of acquiring Webhook will be used.

Channel

Designate a channel for the Slack notification. If omitted, the channel listed at the time of acquiring Webhook will be used.

Icon

Designate the icon to be used 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.

Rows to acquire (Maximum: 10 rows) Designate the number of rows to acquire from the table. A maximum of 10 rows can be acquired.
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.