URL_EXTRACT_PARAMETER (Lakehouse v2)

Extracts the value of a query parameter from a URL string.

Analyze Syntax

func.url_extract_parameter(<url>, <param>)

Analyze Examples

func.url_extract_parameter('https://example.com?page=1&size=10', 'page')

┌─────┐
│ '1'  │
└─────┘

SQL Syntax

URL_EXTRACT_PARAMETER(<url>, <param>)

SQL Examples

SELECT URL_EXTRACT_PARAMETER('https://example.com?page=1&size=10', 'page');

┌───┐
│ 1  │
└───┘