SPLIT_TO_MAP()

Concepts: sqlSplitToMap

Basic Syntax Parsing Query Strings URL query strings are the most common use case. They contain parameters in key=value format separated by ampersands: Parsing Config Strings Delimiter Format Variants The same function handles different delimiter conventions. The key is matching the delimiters to your data format. Common patterns include URL-style (&/=), config-style (,/:), and pipe-style (|/=). Advanced Usage Filtering by Map Values This query finds all requests where the action parameter equals "delete". The map extraction happens inline, turning a text search problem into a structured data query. Best Practices When to Use SPLIT_TO_MAP() Understanding the execution model helps you predict behavior with duplicate keys and malformed input. This function is heavily used in analytics pipeli