Big Query Archives - Feral Cat - Software Development

Pull A Domain From A Full Website Path In BigQuery

November 12, 2024February 15, 2024 by Carlos

This post will show you how to pull a domain from a full website path in BigQuery. So let’s set the stage for a hypothetical. You own a URL shortener company. You want to partner with a website for whatever reason. You decide that you want to do analysis over the data you’ve streamed or … Read more

Set An Existing Table’s Partition Expiration In Big Query

January 4, 2023January 3, 2023 by Carlos

Why Might I need A Partition Expiration? Partition expirations can be leveraged for several use cases. Some countries have laws pertaining to how long PII can be held. Storage is very expensive, maybe your company wants to save some money? The list can and will go on. But it gets a little harder when the … Read more