SQL Pipe

Create, edit, and analyze spreadsheet files (.xlsx, .xlsm, .csv, .tsv) with formulas, formatting, and financial modeling conventions.

Design database schemas, plan data migrations, optimize queries, and model data relationships using expert analysis and automated tools.

Run machine learning and generative AI tasks directly in BigQuery SQL using built-in functions for forecasting, anomaly detection, key driver analysis, and text generation.

Define, track, and interpret product metrics across discovery, growth, and mature product stages using frameworks like AARRR, North Star, and HEART.

Perform CRUD operations, run queries, and manage containers on Azure Cosmos DB NoSQL API using the Python SDK.

Ingest and process high-throughput event streams using Azure Event Hubs SDK for Python, with support for producers, consumers, and checkpointing.