In redshift i am using below code.but i am getting first special character position only. SELECT id,regexp_instr(id,',') ,regexp_instr(id,',',2)FROM test
I have ran a crawler on json S3 file for updating an existing external table. Once finished I checked the SVL_S3LOG to see the structure of the external table a