SELECT `justfunctions.eu.surrogate_key_str`("python")
/*--Output--
2065202487608477923
*/
CREATE OR REPLACE FUNCTION `your_project_id.your_dataset_id.surrogate_key_str`(`string` STRING)
RETURNS STRING AS (CAST(FARM_FINGERPRINT(string) AS STRING))
OPTIONS ( description = '''Creates a hashed value of multiple field <string>. Use CONCAT to create <string> to include multiple fields.''')
SQL User Defined Function (SQL UDF)
See something wrong? Contact us or report an issue on Github.