2 Respostas
- Mais recentes
- Mais votos
- Mais comentários
1
Hi,
Did you consider using Athena instead of S3 select - the Athena GUI is much more user friendly and also you can setup defined governance/access. Please refer: https://aws.amazon.com/blogs/aws/amazon-athena-interactive-sql-queries-for-data-in-amazon-s3/
Alternatively, you could consider using the AWS SDK for Pandas which can provide a visual & a repeatable way to use S3 select using a notebook. Please refer: https://aws-sdk-pandas.readthedocs.io/en/stable/tutorials/029%20-%20S3%20Select.html
Thanks
respondido há um ano
Thanks Rama-I will look into AWS SDK for Pandas - just looking for a swift, cost effective (but user friendly) querying method to process json files into a bucket
You can also query using S3 Select against individual objects using the AWS Console, which can be useful for trying out S3 Select queries.