🔥 Transform¶
Function Categories¶
🧠 AI (7 functions)¶
ask_ai: Ask Anything!ask_appstore_reviews: Ask AI what your app users think.ask_my_data: Ask your data anyquestionin natural language.categorize: Categorizeitemsin categories and subcategories.generate_categories: Returncategoriesofitems.generate_face_embedding: Detect Face on image and Generate its Embeddinggenerate_sql: Transformquestionto a SQL query.
🧠 Machine Learning (7 functions)¶
precision_recall_auc: Returns the Area Under the Precision Recall Curve (a.k.a. AUC PR)precision_recall_curve: Returns the Precision-Recall Curveprophet: Return Time Series Forecast as json using prophetprophet_table: Return Time Series Forecast as table using prophetroc_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 ofcontent
📶 GA4 (1 functions)¶
create_ga4_views: Create views to help querying GA4 Data
🌐 Graph (1 functions)¶
connected_components: Compute the connected components of a non-directed graph.
🌐 Transform Geo Data (5 functions)¶
geocode: Getaddressdetails from Google Mapsgeocode_fr: Getaddressdetails from api-adresse.data.gouv.frh3: Wrapper around Uber H3reverse_geocode: Get address details atlatitude,longitudevalidate_address: Validateaddressusing Google Maps
{...} Transform Json (10 functions)¶
create_materialized_view_w_flattened_json_column: Create a Materialized view of a table withjson_columnflatteneditems2json: Returnsjsonobject from array ofkey_value_itemsjson_column_schema: Returns the schema of a json columnjson_items: Extractkey_value_itemsfromjson_stringjson_keys: Extractkeysfromjson_stringjson_merge: Mergejson_string1andjson_string2json_query: Extract data fromjson_stringusing advanced json queryingjson_schema: Returns the schema ofdatajson_values: Extractvaluesfromjson_stringsql_to_flatten_json_column: Generate the SQL to flatten a jsoncolumn
🔨 Convert Data Format (5 functions)¶
html2pdf: Converthtmltopdfjson2excel: Dump data to excel filejson2xml: Returns XML for given JSON stringmarkdown2html: Convertmarkdowntohtmlxml2json: Returns JSON as a string for given XML string
Transform Ip (6 functions)¶
ip2asn: Getasnofipip2continent: Getcontinent_codeofipip2continent_name: Getcontinentofipip2country: Getcountry_codeofipip2country_name: Getcountry_nameofipip_range2ip_networks: Convert an IP range into a json list of IP networks in CIDR notation
📆 Transform Date (7 functions)¶
date_sub_isoyear: Returns same dayyearsbeforegenerate_dates: Generate a table of datesgregorian2hijri: Convert Gregorian Date to Hijri Date (taken from here)is_public_holiday: Return true ifdatecorresponds to a public holiday incountry_codeparse_date: Parse date with automatic format detectiontranslated_month_name: Gettranslated_month_nametranslated_weekday_name: Gettranslated_weekday_name
✨ Transform String (21 functions)¶
camel2snake: Convertstringfrom camelCase to snake_caseconvert_non_ascii_characters_to_unicode_escape_sequences: Replace all non ASCII characters with escape unicodedeidentify: Masks sensitive information of typeinfo_typesintextdetect_language: Detectstextlanguagedetect_sensitive_info: Detect sensitive information intextis_email_valid: Return true ifemailis validis_phone_number_valid: Return ifphone_numberis validngram_frequency_similarity: Calculates n-gram similarity between two stringsparse_url: Returnurlpartsparse_user_agent: Parses User Agent strings into several componentsphone_number_info: Getphone_numberinforemove_accents: Remove accentsremove_extra_whitespaces: Remove unwanted whitespacesremove_strings: Remove any string ofstrings_to_removefromstringremove_words: Remove any word ofwords_to_removefromstringrender_handlebars_template: Render template with context using handlebars.js templating libraryrender_template: Render template with context using nunjucks.js templating libraryreplace_special_characters: Replace most common special characters in astringwithreplacementtranslate: Translatetextintotarget_languageurl_decode: Decodeurl_encoded_stringxml_extract: Returns content extracted from XML from given XPATH
[...] Transform Array (23 functions)¶
are_arrays_equal: Return true ifarray1=array2array_contains: Returnstrueifvalueis in arrayarrelse returnsfalsearray_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 givenvalues.distinct_values: Return distinct valuesfind_greater_value: Return theoffset(zero-based index) of the firstvalueinarrwherevalue >= xfind_lower_value: Return theoffset(zero-based index) of the firstvalueinarrwherevalue <= xfind_value: Return the firstoffset(zero-based index) ofvaluein arrayarrfrequent_values: Returnsfrequent_valuesamong array ofvaluesget_value: Return the firstvaluewith a keysearch_keyfromkey_value_itemslast_value: Return last value of arraymax_value: Return max value of arraymedian_value: Return median value of arraymin_max_scaler: Performs min-max scaling on an array.min_value: Return min value of arraypercentile_value: Returns percentile of an array with percentile a float in range [0, 1].rare_values: Returnsrare_valuesamong array ofvaluesremove_value: Return an array with all values exceptvalue.sort_values: Return sorted array (ascending)sort_values_desc: Return sorted array (descending)sum_values: Return the sum of array valuesz_scores: Computez_scores
1️⃣ Transform Numeric (7 functions)¶
compute_linear_regression_coefficients: Returns linear regression coefficients fromx,ycolumns.format_percentage: Returnfirst_number / second_numberas a formatted percentagenps: Returns the NPS (Net Promoter Score)quantize_into_bins: Get thebin_rangein which belongsvaluequantize_into_bins_with_labels: Get thelabelof the bin in which belongsvaluequantize_into_fixed_width_bins: Get thebin_rangein which belongsvalueweighted_average: Returns the weigthed average elements.