11 Useful BigQuery Tricks (for Newbies)
Tricks Every New BigQuery User Should Know
My ability to write SQL has unlocked many doors for me. It’s allowed me to interact with some amazing tools and database systems. It’s led me to some smart people, interesting companies, and enabled me to solve problems for countless people.
It’s taught me a lot about logic and analytical thinking, not just with data but in life too — if you would believe that.
I’ve seen SQL used to build some pretty cool things. I’ve seen good SQL, bad SQL, and everything in between (no pun intended). SQL is the cornerstone of any solid data organization.
Long story short, it’s a must-have skill if you’re going to make it as a data person.
Over the years, I’ve seen my share of systems that use SQL: SQL Server, MySQL, PostgreSQL, MariaDB, Oracle, Amazon Aurora, SQLite, Snowflake, Databricks, and BigQuery. That’s off the top of my head. Some are darn good; others, well… aren’t.
The one I like playing with the most is BigQuery. It’s fun, and if you’re new at this SQL thing, a great place to stretch your wings. If you’re an old hand at this, then it will be fun and challenging too — I promise.
For me, I get a kick out of using it. Its solid integration with other GCP…
