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. |