Send slack notification with BQ results

Last update: Dec 16, 2022

Overview

bq2slack-github-action

Send slack notification with BQ results.

How to use

Sample github actions workflow yaml

name: Run SQL against BQ and notify slack
on:
  schedule:
    - cron:  '0 10 * * *' # run every day at 10:00

jobs:
  bq2slack:
    runs-on: ubuntu-latest
    name: Execute SQL query and send results to Slack
    steps:
      - name: Run
        uses: data-i-consulting/[email protected] # use the latest tag
        with:
          slack_webhook: ${{secrets.SLACK_WEBHOOK}}
          gcp_service_account: ${{secrets.GCP_SERVICE_ACCOUNT}}
          sql: |
            WITH something AS (
              SELECT 1 as my_number
            )

            SELECT * FROM something

Sample output

Development

npm i
npm run start

Build

npm i
npm run build

Build Schema.org graphs for JavaScript Runtimes (Browser, Node, etc). Improve your sites SEO with quick and easy Rich Results.

schema-org-graph-js The quickest and easiest way to build Schema.org graphs for JavaScript Runtimes (Browser, Node, etc). Status: 🔨 In Development Pl

Dec 21, 2022

🔎 (Draft!) VSCode extension to show the search results in a tree view

vscode-search-tree 🔎 (Draft!) VSCode extension to show the search results in a tree view The work on this extension is on-pause for now since VSCode

Sep 7, 2022

🎲 An exact-results dice-rolling library, for answering dice-related stat questions.

Roll.js 🎲 An exact-results dice-rolling library, for answering dice-related stat questions. I'm an avid D&D player, as is my brother, and we both lik

Dec 28, 2022

An extension to get randomized results from directus.

Directus Extension Randomized Results As the name suggests this extension will enable Randomized results mirroring the Directus /items/:collection end

Oct 19, 2022

Text Engraving & Extrusion demo based on Three.js is implemented with Typescript and webpack5. Used THREE-CSGMesh as the core tech to achieve engraving and extrusion results

Text Engraving & Extrusion Text Engraving & Extrusion demo is implemented using Three.js, with Typescript and webpack5. Used THREE-CSGMesh as the core

Oct 12, 2022

Scrape tweets from Twitter search results based on keywords and date range using Playwright. Save scraped tweets in a CSV file for easy analysis

Tweet Harvest (Twitter Crawler) Tweet Harvest is a command-line tool that uses Playwright to scrape tweets from Twitter search results based on specif

Aug 9, 2023

Manage and monitorize your notification using only your terminal :3

Notifications Monitor Monitor your notifications and get a temporary list of the notifications. Dependencies Node.js (to run the program; by default,

Apr 12, 2022

Adds a notification to hydrate yourself!

Water Break This plugin simply puts a notification in the upper-left of the window. This will alert you to drink some water! Install ipm install water

Sep 24, 2022

Get a desktop notification every time a new correction slot is available for your 42 project.

42_slot_watcher A simple node.js corrections slots watcher for 42, working on Windows - MacOS - Linux. What is this I was bored of having to refresh t

Dec 20, 2022

Comments

Change date format

> new Date().toISOString().slice(0, 15).replace('T', '')
'2022-02-1401:2' // before
> new Date().toISOString().slice(0, 16).replace('T', ' ')
'2022-02-14 01:27' // after

opened by umemotoryo 0

Releases(v1.0.7)

v1.0.7(Feb 14, 2022)
What's Changed

Change date format by @umemotoryo in https://github.com/data-i-consulting/bq2slack-github-action/pull/5

New Contributors

@umemotoryo made their first contribution in https://github.com/data-i-consulting/bq2slack-github-action/pull/5

Full Changelog: https://github.com/data-i-consulting/bq2slack-github-action/compare/v1.0.6...v1.0.7
Source code(tar.gz)
Source code(zip)
v1.0.6(Feb 11, 2022)
What's Changed

message formatting by @varadiz in https://github.com/data-i-consulting/bq2slack-github-action/pull/3

Create README.md by @varadiz in https://github.com/data-i-consulting/bq2slack-github-action/pull/4

Full Changelog: https://github.com/data-i-consulting/bq2slack-github-action/compare/v1.0.5...v1.0.6
Source code(tar.gz)
Source code(zip)
v1.0.5(Feb 10, 2022)

Full Changelog: https://github.com/data-i-consulting/bq2slack-github-action/compare/v1.0.4...v1.0.5
Source code(tar.gz)
Source code(zip)
v1.0.4(Feb 10, 2022)

Full Changelog: https://github.com/data-i-consulting/bq2slack-github-action/compare/v1.0.3...v1.0.4
Source code(tar.gz)
Source code(zip)
v1.0.3(Feb 10, 2022)

Full Changelog: https://github.com/data-i-consulting/bq2slack-github-action/compare/v1.0.2...v1.0.3
Source code(tar.gz)
Source code(zip)
v1.0.2(Feb 10, 2022)
What's Changed

text by @varadiz in https://github.com/data-i-consulting/bq2slack-github-action/pull/2

Full Changelog: https://github.com/data-i-consulting/bq2slack-github-action/compare/v1.0.1...v1.0.2
Source code(tar.gz)
Source code(zip)
v1.0.1(Feb 10, 2022)
What's Changed

Fix BQ by @varadiz in https://github.com/data-i-consulting/bq2slack-github-action/pull/1

New Contributors

@varadiz made their first contribution in https://github.com/data-i-consulting/bq2slack-github-action/pull/1

Full Changelog: https://github.com/data-i-consulting/bq2slack-github-action/compare/v1.0.0...v1.0.1
Source code(tar.gz)
Source code(zip)
v1.0.0(Feb 10, 2022)

kinda works
Source code(tar.gz)
Source code(zip)

Owner

Data-i Consulting

GitHub

Start building admin tools on Slack without going into complex slack syntax and flows.

Slackmin Slackmin helps in easy integration with slack to use slash commands, interactive components, format and send messages, design and use modals.

49 Jan 2, 2023

An example implementation of the slack-gpt starter which ingests confluence pages to create a helpful slack bot

Slack-GPT (HR bot example implementation) Table of Contents Introduction Prerequisites Creating and installing the application Configuration Starting

17 Jul 31, 2023

This repository contains a basic example on how to set up and run test automation jobs with CircleCI and report results to Testmo.

CircleCI test automation example This repository contains a basic example on how to set up and run test automation jobs with CircleCI and report resul

2 Dec 23, 2021

Example-browserstack-reporting - This repository contains an example of running Selenium tests and reporting BrowserStack test results, including full CI pipeline integration.

BrowserStack reporting and Selenium test result example This repository contains an example of running Selenium tests and reporting BrowserStack test

1 Jan 1, 2022

Elections in Russia, Saint Petersburg, 2021: results, turnout, and commission data. With image charts and brief introduction to election fraud methods used.

2021 Elections in Saint Petersburg, Russia ???? Переключиться на русский ?? Jump to charts ?? Telegram bot In Russia, Saint Petersburg from 17th to 19

11 Dec 26, 2022

Send slack notification with BQ results

Related tags

Overview

bq2slack-github-action

How to use

Sample github actions workflow yaml

Sample output

Development

Build

You might also like...

Comments

Releases(v1.0.7)

v1.0.7(Feb 14, 2022)

What's Changed

New Contributors

v1.0.6(Feb 11, 2022)

What's Changed

v1.0.5(Feb 10, 2022)

v1.0.4(Feb 10, 2022)

v1.0.3(Feb 10, 2022)

v1.0.2(Feb 10, 2022)

What's Changed

v1.0.1(Feb 10, 2022)

What's Changed

New Contributors

v1.0.0(Feb 10, 2022)

Owner

Data-i Consulting

Start building admin tools on Slack without going into complex slack syntax and flows.

An example implementation of the slack-gpt starter which ingests confluence pages to create a helpful slack bot

This repository contains a basic example on how to set up and run test automation jobs with CircleCI and report results to Testmo.

Example-browserstack-reporting - This repository contains an example of running Selenium tests and reporting BrowserStack test results, including full CI pipeline integration.

Elections in Russia, Saint Petersburg, 2021: results, turnout, and commission data. With image charts and brief introduction to election fraud methods used.

A landing page, as well as a results page, that utliize both Yelp API and Google Maps API.

Show a helpful summary of test results in GitHub Actions CI/CD workflow runs

📈 AI powered web scraper that let's you scrape anything you want from the web including google search results

Perform queries on the current graph and batch process on the results.

A self-hosted Thumbnail generator/finder which creates thumbnails based on folder names and google search results.