Jason Kao

AWS released APIs to AWS Identity Center (formerly known as AWS SSO) that will permit us to pull the proper data from AWS Identity Center. https://aws.amazon.com/blogs/security/announcing-new-aws-iam-identity-center-apis-to-manage-users-and-groups-at-scale/ We should pull this...

Query was provided in Discord here: https://discord.com/channels/872925471417962546/1016576453988601946 `SELECT AWS_EC2_SECURITY_GROUPS.*, AWS_EC2_INSTANCES.instance_id, AWS_EC2_INSTANCES.arn as instance_arn FROM AWS_EC2_INSTANCES CROSS JOIN jsonb_array_elements(security_groups) ec2_json RIGHT JOIN AWS_EC2_SECURITY_GROUPS on ec2_json.value ->> 'GroupId' = AWS_EC2_SECURITY_GROUPS.group_id;` This will...

We can go straight to v2.0.0

Hi @valerioj, here are a few more recent threads: * https://discord.com/channels/872925471417962546/1071081863105495178 * https://discord.com/channels/872925471417962546/1074100996474675240

Hey @bbernays this issue is for Route Table Routes and not just the route table. The actual routes which are currently not included in TGW Route Tables.

This is blocked for now. There's no clean way in AWS to pull Account Settings across the account for all IAM Principals. While it's possible to pull Account Settings at...

I'm ok leaving it as only launchPermissions for now to finish this issue. Description, sriovNetSupport, imdsSupport, bootMode, tmpSupport, productCodes, kernel, ramdisk are all included in aws_ec2_images. (Also blockDeviceMapping) That leaves...

Somewhat related to https://github.com/cloudquery/cloudquery/issues/1736. New queries could look something like (without using view): Query was provided in Discord here: https://discord.com/channels/872925471417962546/1016576453988601946 SELECT AWS_EC2_SECURITY_GROUPS.*, AWS_EC2_INSTANCES.instance_id, AWS_EC2_INSTANCES.arn as instance_arn FROM AWS_EC2_INSTANCES CROSS JOIN...

Lower priority since DBT will build necessary views.

Interesting, I didn't know it was included in `gcp_serviceusage_services --> Config --> Quota`. I haven't run a sync on `gcp_serviceusage_services`, can you confirm the Quota data in that table?