From the course: Build a No-Code ETL Pipeline with Google BigQuery
Join today to access over 24,800 courses taught by industry experts.
Schedule query and manage issues - BigQuery Tutorial
From the course: Build a No-Code ETL Pipeline with Google BigQuery
Schedule query and manage issues
- [Narrator] Now that we've seen how we can create the analytics table and then insert fresh rows into the analytics table, let us see how we can automate this process. The first step in automating this process is to assemble our commands into a BigQuery script. A BigQuery script is simply a collection of BigQuery commands that run in a certain order. To create a BigQuery script, you can simply take all of your commands and write them in order where each command is separated by a semicolon. So in this script, the first command is the one that creates the analytics table, and it is delimited by semicolon. And the second command is the one that inserts only fresh rows into the analytics table. And at the end of this command, we also have a semi-colon. And if I now run this script, you will see that each command will run in turn. And here are my two commands. And at the end, I can see the results of each command in turn. Now in my case, the first command didn't do anything because the…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.