StringSimilarity ( ON { table | view | (query) } [ PARTITION BY ANY ] USING ComparisonColumnPairs ('comparison_type (column1,column2[,constant])[ AS output_column]' [,...]) [ CaseSensitive ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}[,...]) ] [ Accumulate ({ 'accumulate_column' | accumulate_column_range }[,...]) ] )
You can call this function from:
- The FROM clause of a SELECT statement
- As part of a CREATE TABLE statement
- As part of a CREATE VIEW statement