Blog
Latest stories, tutorials and intersting articles to help on your Query Stash journey.
Getting Started with BigQuery SQL Persistent Functions
Persistent user-defined functions (UDFs) allow users to create custom functions that can be used across multiple queries and shared amongst users.
Blakey
—
How can I share my SQL queries?
Sharing is fundamental to QueryStash, the goal is to create an environment where the community of users can help each other develop and share knowledge.
Blakey
—
Search Your Stash
The main purpose behind QueryStash is to help you organize you SQL code. Anything from a simple snippet, full analytics query or some useful examples. If you have already been through the process of creating your first query, you will have learnt that we capture extra metadata to help you later retrieve your queries in a simple manner.
Blakey
—
Your First Query
Getting started with QueryStash, doesn't need to fill daunting. The only question you have to answer is what gets stashed first. Some might want to start with useful snippets, things you might use on a regular basis, others could jump right in through the project route and start organizing their own analytics work.
Blakey
—
Welcome to QueryStash!
Firstly, thank you for your time in reading this today and visiting my new project. Hopefully you have stumbled upon QueryStash with the goal of solving some of the very same problems I wanted to solve by building this product in the first place.
Blakey
—
Explore some example SQL queries...
QUALIFY by ROW_NUMBER for cleaner queries
Using QUALIFY you can greatly simplify your query when dealing with RANK and ROW_NUMBER, and avoid having multiple sub queries.
Spike Detection for Website Visits
To demonstrate one approach to spike detection, we are exploring website visitor data from the BigQuery Public Google Analytics sample data.
Merge Statements BigQuery
The combination of insert and update in a merge statement simplifies data processing where we don't know if a record already exists.
Create a Persistent Function on BigQuery
Persistent user-defined functions allow users to create custom functions that can be used across multiple queries and shared amongst users.
BigQuery Create ML Regression Model
Creating ML models has become even easier with BigQuery ML, create a new model in a few lines of SQL.
BigQuery Create Array of Structs
Working with flattened data might not always be the optimal way to work with data in BigQuery, use arrays to group data together into a single field.
