You might like
When working with data that has multiple records associated with an item, it may be better to group them together into a single row, using arrays and structs on BigQuery makes this super simple. querystash.com/query/bigquery…
Using ROW_NUMBER as a filtering method can be tricky on very large datasets, this method is much more efficient. querystash.com/query/alternat…
If you need to update a table in BigQuery via SQL, you might want to consider MERGE statements. Particularly if you need to INSERT, UPDATE or DELETE. querystash.com/query/merge-st…
Creating persistent functions on BigQuery is simple. querystash.com/query/bigquery…
How to use BigQuery persistent functions querystash.com/blog/getting-s…
REGEXP_CONTAINS is a useful alternative to avoid messing around with LIKE and IN for multiple string searches in one.
Persistent Functions on BigQuery are great for creating reusable logic to be shared across queries and users.
Learn more about creating BigQuery persistent functions in SQL. querystash.com/blog/getting-s…
Learn more about the ways you can search your own SQL stash with targeted queries and tags. querystash.com/blog/search-yo…
If you often use ROW_NUMBER to filter data by ordering you might find QUALIFY incredibly useful to help simplify your queries. #bigquery #SQL querystash.com/query/e41e8e07…
MERGE satements ae great for dealing with lots of inserts and upates in SQL. querystash.com/query/62cf5109…
A guide to using our advanced search and the new tag filters. querystash.com/blog/search-yo…
Having issues with ROW_NUMBER on very large data sets, try this instead. querystash.com/query/e94834f4…
Little sneak peak of the UI refresh for @QueryStash, felt embarrassed with the current site. I built over a year ago while on parental leave (hence the look), was in need of a good overhaul.
Simple approach to time series spike detection with the @googleanalytics public sample data. app.querystash.com/query/d72aac44… #bigquery #Analytics
United States Trends
- 1. #CARTMANCOIN 1,791 posts
- 2. Broncos 67K posts
- 3. yeonjun 237K posts
- 4. Raiders 66.6K posts
- 5. Bo Nix 18.4K posts
- 6. Geno 18.9K posts
- 7. daniela 50.8K posts
- 8. Sean Payton 4,835 posts
- 9. #criticalrolespoilers 5,119 posts
- 10. Kehlani 10.4K posts
- 11. #iQIYIiJOYTH2026xENGLOT 427K posts
- 12. #TNFonPrime 4,054 posts
- 13. #Pluribus 2,927 posts
- 14. Danny Brown 3,166 posts
- 15. Kenny Pickett 1,517 posts
- 16. Chip Kelly 1,999 posts
- 17. TALK TO YOU OUT NOW 29.1K posts
- 18. Tammy Faye 1,449 posts
- 19. Vince Gilligan 2,603 posts
- 20. Jalen Green 7,846 posts
Something went wrong.
Something went wrong.