🔥 Transform¶

[...] Transform Array (23 functions)¶

are_arrays_equal: Return true if array1 = array2
array_contains: Returns true if value is in array arr else returns false
array_intersect: Returns the intersection of two arrays.
array_union: Returns the union of two arrays.
benford_distance: Calculate the distance from Benford's Law for given values.
distinct_values: Return distinct values
find_greater_value: Return the offset (zero-based index) of the first value in arr where value >= x
find_lower_value: Return the offset (zero-based index) of the first value in arr where value <= x
find_value: Return the first offset (zero-based index) of value in array arr
frequent_values: Returns frequent_values among array of values
get_value: Return the first value with a key search_key from key_value_items
last_value: Return last value of array
max_value: Return max value of array
median_value: Return median value of array
min_max_scaler: Performs min-max scaling on an array.
min_value: Return min value of array
percentile_value: Returns percentile of an array with percentile a float in range [0, 1].
rare_values: Returns rare_values among array of values
remove_value: Return an array with all values except value.
sort_values: Return sorted array (ascending)
sort_values_desc: Return sorted array (descending)
sum_values: Return the sum of array values
z_scores: Compute z_scores

ip2asn: Get asn of ip
ip2continent: Get continent_code of ip
ip2continent_name: Get continent of ip
ip2country: Get country_code of ip
ip2country_name: Get country_name of ip
ip_range2ip_networks: Convert an IP range into a json list of IP networks in CIDR notation

precision_recall_auc: Returns the Area Under the Precision Recall Curve (a.k.a. AUC PR)
precision_recall_curve: Returns the Precision-Recall Curve
prophet: Return Time Series Forecast as json using prophet
prophet_table: Return Time Series Forecast as table using prophet
roc_auc: Returns the Area Under the Receiver Operating Characteristic Curve (a.k.a. ROC AUC)
roc_curve: Returns the Receiver Operating Characteristic Curve (a.k.a. ROC Curve)
sentiment_score: Compute sentiment score of content

create_materialized_view_w_flattened_json_column: Create a Materialized view of a table with json_column flattened
items2json: Returns json object from array of key_value_items
json_column_schema: Returns the schema of a json column
json_items: Extract key_value_items from json_string
json_keys: Extract keys from json_string
json_merge: Merge json_string1 and json_string2
json_query: Extract data from json_string using advanced json querying
json_schema: Returns the schema of data
json_values: Extract values from json_string
sql_to_flatten_json_column: Generate the SQL to flatten a json column

camel2snake: Convert string from camelCase to snake_case
convert_non_ascii_characters_to_unicode_escape_sequences: Replace all non ASCII characters with escape unicode
deidentify: Masks sensitive information of type info_types in text
detect_language: Detects text language
detect_sensitive_info: Detect sensitive information in text
is_email_valid: Return true if email is valid
is_phone_number_valid: Return if phone_number is valid
markdown2html: Convert markdown to html
ngram_frequency_similarity: Calculates n-gram similarity between two strings
parse_url: Return url parts
parse_user_agent: Parses User Agent strings into several components
phone_number_info: Get phone_number info
remove_accents: Remove accents
remove_extra_whitespaces: Remove unwanted whitespaces
remove_strings: Remove any string of strings_to_remove from string
remove_words: Remove any word of words_to_remove from string
render_handlebars_template: Render template with context using handlebars.js templating library
render_template: Render template with context using nunjucks.js templating library
replace_special_characters: Replace most common special characters in a string with replacement
translate: Translate text into target_language
url_decode: Decode url_encoded_string
xml_extract: Returns content extracted from XML from given XPATH

connected_components: Compute the connected components of a non-directed graph.

date_sub_isoyear: Returns same day years before
generate_dates: Generate a table of dates
gregorian2hijri: Convert Gregorian Date to Hijri Date (taken from here)
is_public_holiday: Return true if date corresponds to a public holiday in country_code
parse_date: Parse date with automatic format detection
translated_month_name: Get translated_month_name
translated_weekday_name: Get translated_weekday_name

compute_linear_regression_coefficients: Returns linear regression coefficients from x, y columns.
format_percentage: Return first_number / second_number as a formatted percentage
nps: Returns the NPS (Net Promoter Score)
quantize_into_bins: Get the bin_range in which belongs value
quantize_into_bins_with_labels: Get the label of the bin in which belongs value
quantize_into_fixed_width_bins: Get the bin_range in which belongs value
weighted_average: Returns the weigthed average elements.