Classifying Device Categories from User Agent String in SQL with Regex
So you have a User Agent string field to transform into Device category, but you want to do it using least resource on…
Author: siliconra admin
GA4 Ecommerce Implementation Review
SiliconRA have recently been involved in an end-to-end GA4 (Google Analytics 4) implementation. GA4 is a massive booster Companies can: Focus on core…
PII (Personal Identifiable Information) Redact Regex Pattern
In order to redact PII (Personal Identifiable Information) like name, numbers, a company name or an email from text strings such as comments…
Supercharging Apache Superset – Chart Caching
Great tips for supercharging superset that we are following – caching charts in dashboards for improved performance. Eureka of sorts! – using the…
Tidy URLs for aggregation in Presto SQL
The longer tittle includes the text – “with regexp_replace and regexp_extract”. This is the important bit and since we love Regular Expressions we…