Implement semantic search using text embeddings for more relevant results than keyword matching.
Read more →Tag: SQL
Tips and Tricks – Use dbt for Maintainable Data Transformations
Build modular, tested, documented data transformations with dbt.
Read more →Tips and Tricks – Partition Large Tables for Query Performance
Use table partitioning to dramatically speed up queries on large datasets.
Read more →Tips and Tricks – Use Window Functions for Running Calculations
Calculate running totals, rankings, and moving averages efficiently with SQL window functions.
Read more →BigQuery Unleashed: Building Enterprise Data Warehouses That Scale to Petabytes
Introduction: BigQuery stands as Google Cloud’s crown jewel—a serverless, petabyte-scale data warehouse that has fundamentally changed how enterprises approach analytics. This comprehensive guide explores BigQuery’s enterprise capabilities, from columnar storage and slot-based execution to advanced features like BigQuery ML, BI Engine, and real-time streaming. After architecting data platforms across all major cloud providers, I’ve found […]
Read more →Tips and Tricks – Use Span for Zero-Allocation String Parsing
Eliminate heap allocations when parsing strings by using Span