|
You are here |
janik6n.net | ||
| | | | |
saeedesmaili.com
|
|
| | | | | I came across this Linkedin post from a Google engineer, on a new (in preview) and very interesting BigQuery syntax: GROUP BY ALL. This will save time when writing and specially modifying complex SQL queries on BigQuery. The GROUP BY ALL clause groups rows by inferring grouping keys from the SELECT items. It will exclude expressions with aggregate and window functions, constants, and query parameters for a smart GROUP BY. So instead of GROUP BY name, city, device, browser, date or GROUP BY 1, 2, 3, 4, 5 you would use GROUP BY ALL. | |
| | | | |
pliutau.com
|
|
| | | | | Software Engineering Lead with a passion for APIs, Web, Cloud, Microservices, DevOps, Kubernetes etc. Engineering Lead at solsten.io | |
| | | | |
sookocheff.com
|
|
| | | | | Sometimes you have a data analysis problem that is just too big for your desktop or laptop. The limiting factor here is generally RAM. Thankfully, services like Google Compute Engine allow you to lease servers with up to 208GB of RAM, large enough for a wide variety of intensive tasks. An ancillary benefit of using a service like Compute Engine is that it allows you to easily load your data from a Cloud Storage Bucket, meaning you don't need to keep a copy of the large dataset locally at all times. | |
| | | | |
jreypo.io
|
|
| | | Welcome to the next article in the Azure DevOps Server series. In this article, we'll dive into what Variable Groups are, how they can be used securely in Azure DevOps Server, and walk through some practical examples. | ||