Skip to content

Functions

Functions

See functions and test_functions, example:

age('start', 'end')       # age(start, end)
json_keys('column_name')  # json_keys(column_name)

# json_keys(column_name, '$.ducks.country')
json_keys('column_name', '$.ducks.country')

# json_extract(column_name, '$.ducks.country[0]')
json_extract('column_name', '$.ducks.country[0]')

# regexp_extract_all(column_name, '(\\w+):\\s*(\\d+)')
regexp_extract_all('column_name', r'(\w+):\s*(\d+)')

# entropy(category) OVER (PARTITION BY user_id ORDER BY ts)
entropy('category').over(partition_by=['user_id'], order_by=['ts'])

# kurtosis(category) OVER (PARTITION BY user_id ORDER BY ts)
kurtosis('category').over(partition_by=['user_id'], order_by=['ts'])