Using the step: "Derived Column" where I can use SQL functions to derive new columns I found SUBSTRING works but CHARINDEX it doesn't. And as usual with AWS documentation, there's no place or indication which functions are available in this particular kind of glue node.
AWS 공식업데이트됨 3년 전
The goal is to use "Derived Column" and not dabble with the script itself.
Actually that list is correct. Thanks, @acmanjon
Yes, that node allows using SparkSQL functions based on the Glue version you are using (3.3.0 for Glue 4 and 3.1.1 for Glue 3)