Hi Thor,
I have tried , it gives me below error:
“Invalid file system path: Illegal char <:> at index 2: s3://pathofjson”
when I paste the URL- “s3://pathofjson” and I have tried giving the full URL-https://s3.console.aws.amazon.com/s3/buckets/jsonpath, but in this case it is reading some XML and not the JSON object . I have updated my user variables in environemnt variabled with AWS_Access_key_ID and SECRET_ACCESS_KEY_ID. Am I missing some configuration? or is there any other way to read json file from S3 location.
Thanks in advance:)