This article presents links to and descriptions of built-in operators and functions for strings and binary types, numeric scalars, aggregations, windows, arrays, maps, dates and timestamps, casting, ...

Learn how borderless Lakehouse federates queries across Databricks, Snowflake, and AWS Glue with Apache Iceberg for in-place conversational analytics.

The lakeflow system tables record job and pipeline activity in your account. These tables include records from all workspaces in your account deployed in the same cloud region. To see records from ...

A data warehouse is a central repository of information that can be analyzed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and ...

Software Engineer - backend & AI/ML. First-Class BSc Computing. I write about backend, AI/LLM engineering and what I ship. A 15-minute FPV flight is 9,000 GPS points. My ingest path ran 40 million ...

The numbers were old. Emails weren't arriving. Characters were garbled. Even though they were supposed to be looking at the ...

Snowflake DCM (Database Change Management) Projects let you declare the Snowflake objects you want in SQL files, then let Snowflake work out how to get there. That is the whole idea, and it is worth ...

Microsoft Copilot Studio is a conversational AI platform that allows users to create and customize copilots, using a low-code, graphical interface, enabling them to build agents for various scenarios ...

Last time, I talked about how I organized the various documents I had on hand, and just when I thought the problem was mostly solved, the content that should have been in the knowledge base didn't ...

NRR is easy to inflate by accident. Runnable SQL for net and gross revenue retention, the retention bridge, a monthly trend, ...

Spatial SQL and spatial joins are now supported in Lakehouse//RT and can run up to 38x faster than traditional data ...