Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

aws_servicequotas_service_quota queries fail when querying multiple regions with the same service_code #2313

Closed
sbldevnet opened this issue Sep 25, 2024 · 0 comments · Fixed by #2314
Assignees
Labels
bug Something isn't working

Comments

@sbldevnet
Copy link

Describe the bug
Running a query using the aws_servicequotas_service_quota table and filtering by service_code column fails if there is more than one region configured.

As an example the following query fails:

> select * from aws_servicequotas_service_quota WHERE quota_code = 'L-0263D0A3' and service_code = 'ec2' 
Error: get call returned 17 results - the key column is not globally unique (SQLSTATE HV000)

But the following one, filtering by a single region, works as expected.

> select * from aws_servicequotas_service_quota WHERE quota_code = 'L-0263D0A3' and service_code = 'ec2' and region = 'us-east-1'

Steampipe version (steampipe -v)
Example: v0.24.2

Plugin version (steampipe plugin list)
hub.steampipe.io/plugins/turbot/aws@latest: 0.147.0

To reproduce

select * from aws_servicequotas_service_quota WHERE quota_code = 'L-0263D0A3' and service_code = 'ec2' 

Expected behavior
The query should return all rows without raising an error.

Additional context
The GetConfig key colums are service_code and quota_code. In the query, for each region, service_code and quota_code columns have the same value.

@sbldevnet sbldevnet added the bug Something isn't working label Sep 25, 2024
ParthaI added a commit that referenced this issue Sep 25, 2024
…iple regions with the same service_code Closes #2313
@ParthaI ParthaI self-assigned this Sep 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
2 participants