URL_EXTRACT_PARAMETER
Learn how to use the URL_EXTRACT_PARAMETER string function in PlaidCloud Lakehouse. Extracts the value of a query parameter from a URL string.
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 │
└───┘