turbot / steampipe-plugin-aws

Use SQL to instantly query AWS resources across regions and accounts. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/aws
Apache License 2.0
188 stars 97 forks source link

Select glue/lakeformation tables with lakeformation tags #1973

Closed JohannesKonings closed 6 months ago

JohannesKonings commented 10 months ago

Is your feature request related to a problem? Please describe. Lakeformation has it's own concept of tags: https://docs.aws.amazon.com/lake-formation/latest/dg/tag-based-access-control.html I'd like to select the assigned tags wit a selct for the glue/lakeformation tables. The tables get get selected via aws_glue_catalog_table

Describe the solution you'd like The assigned tags should be added as a own column

Describe alternatives you've considered Maybe the information of table and assigned tags can get the other way around with this APIs: https://awscli.amazonaws.com/v2/documentation/api/latest/reference/lakeformation/list-lf-tags.html https://awscli.amazonaws.com/v2/documentation/api/latest/reference/lakeformation/search-tables-by-lf-tags.html

Additional context The tags can be retrieved via https://awscli.amazonaws.com/v2/documentation/api/latest/reference/lakeformation/get-resource-lf-tags.html

github-actions[bot] commented 8 months 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.

bigdatasourav commented 6 months ago

Hey @JohannesKonings, if I understand correctly, you're looking to retrieve the lakeFormation tags associated with Glue tables. Please let me know if this isn't accurate.

bigdatasourav commented 6 months ago

Hey @JohannesKonings, we're closing this issue as we haven't heard back from you yet, please feel free to reopen if you want to share anything. Thanks!

JohannesKonings commented 6 months ago

@bigdatasourav yes, the tags, which I can get with via this API: https://awscli.amazonaws.com/v2/documentation/api/latest/reference/lakeformation/get-resource-lf-tags.html