How to set up scheduled queries in BigQuery and send the results to Slack 

In this video you'll learn how to set up scheduled queries in Google BigQuery and send the results to a specific channel in your Slack account using Zapier.
This flow is great for limiting the chance of duplications appearing in key data sources.
You could also use this flow to achieve the following:
1. Get a list of problematic accounts that need to be addressed.
2. Get a count of the number of tickets opened in the last 24 hours.
3. Get a count of the number of refunds requested in the last 24 hours.
4. Get a list of tasks which are overdue, grouped by owner.
-----------------------------------------------------------------------------------------
Subscribe to The Analyst's Playbook newsletter - analystsplaybo...