Big Query SQL Tutorial - Scheduled Queries How To (Part #10)

preview_player
Показать описание
View is one of the coolest things in BigQuery. It allows you to pre-save your SQL instead of re-writing is all the time and access the data any time.

View doesn't require any additional storage for it, because BQ doesn't store the table itself, only the SQL. So each time you access the view, the result will be recalculated.
_______
00:00 Rewind
00:28 Scheduled Query vs. View
03:20 Creating Scheduled Query
09:10 Running Scheduled Query
11:10 Checking result of the Query

Useful links:

📌 Want to discuss your project?

  1. Marketing Watch House
  2. google ads bigquery
  3. google ads big query
  4. big query
  5. bigquery tutorial
  6. bigquery tutorial 2019
Рекомендации по теме
Intuitive SQL For 11:00:16

Intuitive SQL For Data Analytics - Tutorial

Google BigQuery Tutorial 0:15:01

Google BigQuery Tutorial

SQL Bootcamp - 2:07:10

SQL Bootcamp - Learn SQL in 2 Hours | Beginners | GCP | BigQuery | [Full Course]

BigQuery Tutorial for 1:06:46

BigQuery Tutorial for Beginners | Google BigQuery Tutorial

Google Big Query 3:07:04

Google Big Query Full Tutorial 2021

Advanced SQL Tutorial 0:08:37

Advanced SQL Tutorial | Subqueries

RIP SQL? Use 0:11:50

RIP SQL? Use BigQuery with ChatGPT!

Full Google Analytics 0:30:16

Full Google Analytics + BigQuery tutorial for beginners | GA4 + BigQuery with SQL examples

Big Query - 0:00:59

Big Query - DATE_DIFF

Como aprender SQL 0:08:52

Como aprender SQL FÁCILMENTE con Google BigQuery

BigQuery ML in 0:01:41

BigQuery ML in a minute

Strategies for optimizing 0:07:10

Strategies for optimizing your BigQuery queries

How to use 0:08:06

How to use SQL JOINS to merge data from multiple tables | BigQuery

BigQuery ML: Machine 0:06:08

BigQuery ML: Machine Learning with Standard SQL

Big Query Live 1:02:05

Big Query Live Training - A Deep Dive into Data Pipelining

Learn Basic SQL 0:17:40

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

What is BigQuery? 0:04:39

What is BigQuery?

Google BigQuery Tutorial 0:46:02

Google BigQuery Tutorial for beginners | Load Dataset and Run SQL queries for Data Analysis

Practical AI 010a: 0:09:18

Practical AI 010a: Using BigQuery ML

Google BigQuery Tutorial 0:48:09

Google BigQuery Tutorial | Analyze Data in BigQuery | Google Cloud Platform Training | Edureka

Top 3 Google 0:00:58

Top 3 Google Big Query Tips

Partitioning and Clustering 0:04:47

Partitioning and Clustering with BigQuery

BigQuery ML - 0:03:43

BigQuery ML - Machine Learning using SQL in BigQuery

Using UNNEST & 0:06:22

Using UNNEST & STRUCT with ARRAYS to create dynamic tables in SQL | BigQuery

Комментарии
Автор

Hi,
Thanks for this series. Appreciate if you could post some theory videos on the Google Ads Schema within Big Query, how are these tables linked, etc.

sethuramalingamsubramaniam
Автор

Hi, Will you be or can you make a video based on triggering schedule queries via pub/sub trigger? I am basically asking because we need data transfers to happen when new day data is available in BQ which happens at unprecedented times. Thanks :)

RahulSingh-wnyh
Автор

Hey, great video! How do I schdule a query to run on the first day of each quarter? Is that possible? Thanks.

zackallred
Автор

i think you touched the ''user defined key' toggle by accident when you scheduled the job..

jessli
Автор

How to do DDL statements in scheduled query ? getting this error: Cannot set write disposition in jobs with DDL statements

souravthakur
Автор

Hi, I have a requirement now which I am thinking to use Scheduled Queries. But I need to query across multiple datasets and tables in a loop ( dynamically) and store the result in bq. This should happen daily once a day. It is basically the metadata which I need to query across multiple datasets and how can I do it using scheduled queries?

pashashaik