turbot / steampipe-plugin-csv

Use SQL to instantly query data from CSV files. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/csv
Apache License 2.0
19 stars 4 forks source link

Enable CSV plugin to access files stored in an S3 bucket #37

Closed michaelgraff closed 1 year ago

michaelgraff commented 2 years ago

Describe the solution you'd like I absolutely love the power of the CSV plugin but it would be great if you could use this plugin to access files stored in an S3 bucket. I currently get various reports delivered to S3 buckets and I'd love to be able to perform joins of the data stored in these CSV files with live data from the AWS plugin. This would a) eliminate the extra step required to download files to my local machine for access via the CSV plugin and b) enable interesting use cases where CSV files could be leveraged to build dashboards on an server running in AWS and/or in Steampipe cloud.

the way I'd envision this working is you could configure your csv.spc to point to an S3 URL or ARN, and the credentials steampipe is using would need to be granted access to the bucket.

cbruno10 commented 2 years ago

Hey @michaelgraff , we're actually working on adding a new capability to the Steampipe SDK to use go-getter in https://github.com/turbot/steampipe-plugin-sdk/pull/439, which is still undergoing some changes and review.

With this feature, you'll be able to add S3 bucket URLs into the paths config arg, and then the CSV plugin will render these.

I'll update this issue again once the new version is released, but if you have any questions in the meantime, please let us know!

github-actions[bot] commented 1 year ago

'This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.'

github-actions[bot] commented 1 year ago

'This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.'