CHANGELOG.md

v0.72.0 [2022-08-15]

What's new?

• New tables added
  • aws_ses_domain_identity (#1206) (Thanks to @janritter for the contribution!)

Enhancements

• Re-enabled name and type optional list key columns in aws_route53_record table. (#1190)
• Updated the following tables to use AWS SDK Go v2: (#1186)
  • aws_acm_certificate
  • aws_api_gateway_api_authorizer
  • aws_api_gateway_api_key
  • aws_api_gateway_rest_api
  • aws_api_gateway_stage
  • aws_api_gateway_usage_plan
  • aws_api_gatewayv2_api
  • aws_api_gatewayv2_domain_name
  • aws_api_gatewayv2_integration
  • aws_api_gatewayv2_stage
  • aws_dynamodb_backup
  • aws_iam_access_advisor
  • aws_iam_access_key
  • aws_iam_account_password_policy
  • aws_iam_account_summary
  • aws_iam_credential_report
  • aws_iam_group
  • aws_iam_policy
  • aws_iam_policy_attachment
  • aws_iam_policy_simulator
  • aws_iam_role
  • aws_iam_saml_provider
  • aws_iam_server_certificate
  • aws_iam_user
  • aws_iam_virtual_mfa_device
  • aws_s3_bucket
  • aws_sns_topic

Bug fixes

• aws_backup_vault table now returns no rows instead of an error when querying a vault that does not exist. (#1163)
• aws_neptune_db_cluster table now only lists Neptune DB clusters. (#1204)
• aws_rds_db_cluster table now only lists RDS Aurora DB clusters. (#1204)

v0.71.0 [2022-07-20]

What's new?

• New tables added
  • aws_networkfirewall_firewall_policy (#1171)

Enhancements

• Added the following new columns to aws_sns_topic table: (#1176)
  • application_failure_feedback_role_arn
  • application_success_feedback_role_arn
  • application_success_feedback_sample_rate
  • firehose_failure_feedback_role_arn
  • firehose_success_feedback_role_arn
  • firehose_success_feedback_sample_rate
  • http_failure_feedback_role_arn
  • http_success_feedback_role_arn
  • http_success_feedback_sample_rate
  • lambda_failure_feedback_role_arn
  • lambda_success_feedback_role_arn
  • lambda_success_feedback_sample_rate
  • sqs_failure_feedback_role_arn
  • sqs_success_feedback_role_arn
  • sqs_success_feedback_sample_rate
• Added support for us-iso and us-isob regions. (#1168)

Bug fixes

• Fixed the typo in column name to use health_check_target instead of heath_check_target in aws_ec2_classic_load_balancer table. (#1179)
• Fixed the settings column in the aws_ecs_cluster table to correctly return data instead of null. (#1175)

v0.70.0 [2022-07-14]

What's new?

• New tables added
  • aws_waf_rule_group (#1160)
  • aws_waf_web_acl (#1151)

Enhancements

• Added column associated_resources to aws_wafv2_web_acl table. (#1158)

v0.69.0 [2022-07-12]

Enhancements

• Recompiled plugin with steampipe-plugin-sdk v3.3.2. (#1150)
• Recompiled plugin with aws-sdk-go v1.44.49. (#1142)
• Added timestamps to example queries in aws_cloudtrail_trail_event, aws_cloudwatch_log_event and aws_vpc_flow_log_event table documents. (#1136)
• Added column url_config to aws_lambda_alias and aws_lambda_function tables. (#1146)

Bug fixes

• Fixed inconsistent table names in the aws_ebs_volume_metric_write_ops, aws_ebs_volume_metric_write_ops_hourly and aws_vpc_flow_log tables. (#1149)

v0.68.0 [2022-07-06]

What's new?

• New tables added
  • aws_cloudfront_response_headers_policy (#1128)
  • aws_iam_saml_provider (#1125)
  • aws_pricing_service_attribute (#1137) (#1141)

Enhancements

• Added column certificate to aws_rds_db_instance table. (#1126)

Bug fixes

• Fixed the aws_backup_framework table to return an empty row for the unsupported ap-northeast-3 region instead of returning an error. (#1131)

v0.67.0 [2022-07-01]

What's new?

• New tables added
  • aws_amplify_app (#1112)
  • aws_cloudfront_function (#1120)
  • aws_glue_connection (#1102)
  • aws_glue_data_catalog_encryption_settings (#1114)
  • aws_glue_job (#1118)
  • aws_glue_security_configuration (#1106)

Enhancements

• Recompiled plugin with steampipe-plugin-sdk v3.3.1. (#1129)
• Added information about STS and IAM API limitations with aws-vault temporary credentials in the docs/index.md file.
• Added column vpcs to aws_route53_zone table. (#1085)
• Added column vpc_endpoint_service_permissions to aws_vpc_endpoint_service table. (#1121)

Bug fixes

• Fixed the No such host issue in audit manager tables. (#1122)
• Fixed the MaxResults parameter issue in list API for aws_eks_identity_provider_config table. (#1119)
• Fixed the Unsupported region issue in aws_media_store_container table. (#1117)
• Fixed the BdRequestException issue in the aws_guardduty_member table. (#1116)

v0.66.0 [2022-06-24]

What's new?

• New tables added
  • aws_backup_framework (#1099)
  • aws_elasticache_reserved_cache_node (#1092)
• Added s3_force_path_style config argument to allow S3 path-style addressing. (#1082) (Thanks to @srgg for the contribution!)

Enhancements

• Recompiled plugin with steampipe-plugin-sdk v3.3.0. (#1108)

v0.65.0 [2022-06-16]

What's new?

• New tables added
  • aws_rds_reserved_db_instance (#1087)

Enhancements

• Added column pending_maintenance_actions to aws_rds_db_cluster and aws_rds_db_instance tables. (#1083)
• Updated the .gitignore file to include all VS Code user settings. (#1078)

Bug fixes

• Fixed the snapshot_create_time column in aws_redshift_snapshot table to be of timestamp data type instead of string. (#1071)

v0.64.0 [2022-06-09]

What's new?

• New tables added
  • aws_elasticache_redis_metric_engine_cpu_utilization_daily (#1063)
  • aws_glue_dev_endpoint (#1057)
  • aws_ssm_inventory (#1054)

Enhancements

• Updated aws_route53_record table to temporarily disable name and type list key quals in order to fix duplicate rows issue. (#972)

Bug fixes

• Fixed aws_elasticsearch_domain, aws_opensearch_domain, and aws_s3_bucket tables to not panic when ignoring errors. (#1064)

v0.63.0 [2022-06-03]

What's new?

• Added endpoint_url config arg to provide users the ability to set a custom endpoint URL when making requests to AWS services. For more information, please see AWS plugin configuration. (#1053) (Thanks to @srgg for the contribution!)

v0.62.0 [2022-06-02]

What's new?

• New tables added
  • aws_route53_traffic_policy_instance (#1047)

Enhancements

• Added column administrator_account to aws_securityhub_hub table. (#1046)

Bug fixes

• Fixed the is_logging column of aws_cloudtrail_trail table to return true instead of null for shadow trails when the source trail has logging enabled. (#986)

v0.61.0 [2022-05-30]

What's new?

• New tables added
  • aws_route53_health_check (#1045)

Bug fixes

• Fixed the inline_policies column in aws_iam_role, aws_iam_group and aws_iam_user tables to correctly return results instead of an error. (#1048)

v0.60.0 [2022-05-25]

What's new?

• Added ignore_error_codes config arg to provide users the ability to set a list of additional AWS error codes to ignore while running queries. For instance, to ignore some common access denied errors, which is helpful when running with limited permissions, set the argument ignore_error_codes = ["AccessDenied", "AccessDeniedException"]. For more information, please see AWS plugin configuration (#992)
• New tables added
  • aws_config_aggregate_authorization (#1025)
  • aws_dlm_lifecycle_policy (#1016)
  • aws_guardduty_filter (#1029)
  • aws_guardduty_member (#1028)
  • aws_guardduty_publishing_destination (#1030)
  • aws_inspector_assessment_run (#1036)
  • aws_inspector_exclusion (#1038)
  • aws_inspector_finding (#1040)
  • aws_ram_resource_association (#1009)
  • aws_ram_principal_association (#1009)
  • aws_securityhub_action_target (#1012)
  • aws_securityhub_finding (#1017)
  • aws_securityhub_finding_aggregator (#1031)
  • aws_securityhub_insight (#1011)
  • aws_securityhub_member (#1022)
  • aws_securityhub_standards_control (#1010)

Enhancements

• Added column shared_directories to aws_directory_service_directory table. (#1024)
• Added column vpc_id to aws_ec2_network_interface table. (#990)
• Added column master_account to aws_guardduty_detector table. (#1023)
• Added column architectures to aws_lambda_function table. (#991)
• Updated all tables to use IgnoreConfig instead of ShouldIgnoreError in GetConfig function. (#992)

Bug fixes

• Fixed the handling for unsupported regions in aws_inspector_assessment_target and aws_inspector_assessment_template tables. (#1039

v0.59.0 [2022-05-11]

What's new?

• New tables added
  • aws_glue_catalog_table (#963)
  • aws_opensearch_domain (#984)
  • aws_pinpoint_app (#968)
  • aws_route53_traffic_policy (#983)
  • aws_sagemaker_app (#977)
  • aws_ses_email_identity (#978)

Enhancements

• Improved the example descriptions in aws_iam_credential_report table document.

Bug fixes

• Fixed aws_cloudtrail_trail_event, aws_cloudwatch_log_event, and aws_vpc_flow_log_event tables not returning correct results for consecutive queries when using the filter list key column. (#981)

v0.58.0 [2022-05-05]

What's new?

• New tables added
  • aws_neptune_db_cluster (#966)
  • aws_sagemaker_domain (#974)

Enhancements

• Added the environment_variables column to aws_lambda_function and aws_lambda_version tables. (#973)
• Updated the aws_organizations_account table's id column description and document for account ID clarifications. (#975)
• Removed the use of chalk package in aws_iam_credential_report table for dashboard compatibility.

Bug fixes

• Updated the column name from date-created to date_created in the aws_elastic_beanstalk_environment table (#965)

v0.57.0 [2022-04-27]

Enhancements

• Recompiled plugin with steampipe-plugin-sdk v3.1.0 and Go version 1.18. (#953)
• Added support for native Linux ARM and Mac M1 builds. (#958)
• Added column package_type to aws_lambda_function table. (#956)

v0.56.0 [2022-04-13]

What's new?

• New tables added
  • aws_cost_by_record_type_daily (#950)
  • aws_cost_by_record_type_monthly (#950)
  • aws_wafregional_rule (#931)
• Added optional config arguments max_error_retry_attempts and min_error_retry_delay to allow customization of the error retry timings. For more information please see AWS plugin configuration. (#914)

Enhancements

• Added column event_notification_configuration to aws_s3_bucket table. (#946)
• Added column login_profile to aws_iam_user table. (#947)

v0.55.0 [2022-04-06]

Enhancements

• Added image_scanning_findings column to aws_ecr_repository table (#937)

v0.54.0 [2022-04-01]

• New tables added
  • aws_networkfirewall_rule_group (#944)

v0.53.0 [2022-03-30]

Enhancements

• Added table_class column to aws_dynamodb_table table (#936)
• Added additional optional key quals ('!=') to aws_cost_by_service_daily, aws_cost_by_service_monthly, aws_cost_by_service_usage_type_daily and aws_cost_by_service_usage_type_monthly tables and context cancellation to aws_cost_forecast_daily and aws_cost_forecast_monthly tables (#917)

Bug fixes

• Fixed aws_s3_bucket queries failing for buckets created in the EU (eu-west-1) region through the CLI or API (#927)

v0.52.0 [2022-03-23]

Enhancements

• Recompiled plugin with steampipe-plugin-sdk v2.1.1 (#933)

v0.51.0 [2022-03-17]

Enhancements

• Added column standards_status_reason_code to aws_securityhub_standards_subscription table (#930)

v0.50.1 [2022-03-10]

Bug fixes

• Fixed the aws_ebs_snapshot table to correctly handle InvalidParameterValue error (#919)

v0.50.0 [2022-03-04]

Enhancements

• Added sqs_managed_sse_enabled column to aws_sqs_queue table (#922)
• Added additional optional key quals to aws_cost_by_service_daily, aws_cost_by_service_monthly, aws_cost_by_service_usage_type_daily and aws_cost_by_service_usage_type_monthly tables (#912)

Bug fixes

• Fixed the title column of aws_vpc_security_group_rule table to correctly evaluate if a security group rule is either ingress or egress (#924)

v0.49.0 [2022-02-17]

What's new?

• New tables added
  • aws_servicequotas_service_quota_change_request (#889)

Enhancements

• Recompiled plugin with steampipe-plugin-sdk v2.0.3 (#901)

Bug fixes

• Fixed pagination issues in aws_ecs_service table (#908)
• Fixed the aws_iam_access_advisor table to handle the errors when steampipe is running on multi-account connections by using an aggregator connection in the configuration file (#905)

v0.48.0 [2022-02-14]

What's new?

• New tables added
  • aws_cloudwatch_metric (#880)

Enhancements

• Added context cancellation handling to the following tables (#896)

  • aws_auditmanager_control
  • aws_auditmanager_framework
  • aws_backup_recovery_point
  • aws_backup_vault
  • aws_cloudfront_cache_policy
  • aws_cloudtrail_trail
  • aws_cloudtrail_trail_event
  • aws_cloudwatch_log_event
  • aws_cloudwatch_log_resource_policy
  • aws_ec2_reserved_instance
  • aws_guardduty_finding
  • aws_iam_action
  • aws_kinesis_video_stream
  • aws_lambda_alias
  • aws_lambda_function
  • aws_serverlessapplicationrepository_application
  • aws_ssm_patch_baseline
  • aws_vpc_security_group_rule

• Updated default max records parameter value and lower limit for the following tables (#896)

  • aws_api_gateway_api_authorizer
  • aws_api_gatewayv2_stage
  • aws_config_conformance_pack
  • aws_directory_service_directory
  • aws_ecs_container_instance
  • aws_ecs_service

Bug fixes

• Fixed the aws_codecommit_repository table to correctly list out all the repositories (#894)

v0.47.0 [2022-02-09]

What's new?

• New tables added
  • aws_glue_crawler (#882)
  • aws_servicequotas_default_service_quota (#887)
  • aws_servicequotas_service_quota (#884)

v0.46.0 [2022-02-02]

Enhancements

• Added additional optional key quals, filter support, and context cancellation handling to Redshift, Route 53, S3, SageMaker, Secrets Manager, Security Hub, Serverless Application Repository, Step Functions, SNS, SSM, SSO, VPC, WAF and Well-Architected tables (#873)

Bug fixes

• Fixed the aws_dax_cluster table to skip unsupported regions (#869)
• Fixed the aws_wellarchitected_workload table to skip unsupported regions (#859)
• Fixed the aws_vpc_security_group_rule table to set the pair_group_name column to nil for cross-account referenced security group rules instead of returning an error (#875)
• Updated the column type of created_date and last_modified columns to TIMESTAMP in all Lambda tables (#871)

v0.45.0 [2022-01-28]

Enhancements

• Added additional optional key quals, filter support, and context cancellation handling to FSx, Glacier, GuardDuty, IAM, Identity Store, Inspector, Kinesis, KMS, Lambda, ElastiCache, Macie and RDS tables (#856)
• Added the following columns to the aws_vpc_security_group_rule table (#860)
  • cidr_ipv4
  • description
  • group_owner_id
  • is_egress
  • referenced_group_id
  • referenced_peering_status
  • referenced_user_id
  • referenced_vpc_id
  • referenced_vpc_peering_connection_id
  • security_group_rule_id
• Added assignment_status column to aws_iam_virtual_mfa_device table (#856)
• Recompiled plugin with steampipe-plugin-sdk v1.8.3 (#865)

Bug fixes

• Fixed the aws_workspaces_workspace table to skip the unsupported regions (#862)

Deprecated

• The following columns of aws_vpc_security_group_rule table have been deprecated to stay consistent with the API response data. These columns will be removed in the next major version. We recommend updating any scripts or workflows that use these deprecated columns to use the equivalent new columns in the table instead.
  • cidr_ip (replaced by cidr_ipv4)
  • group_name
  • owner_id (replaced by group_owner_id)
  • pair_group_id (replaced by referenced_group_id)
  • pair_group_name
  • pair_peering_status (replaced by referenced_peering_status)
  • pair_user_id (replaced by referenced_user_id)
  • pair_vpc_id (replaced by referenced_vpc_id)
  • pair_vpc_peering_connection_id (replaced by referenced_vpc_peering_connection_id)
  • vpc_id

v0.44.0 [2022-01-12]

Enhancements

• Recompiled plugin with aws-sdk-go-v1.42.25 (#851)
• Added additional optional key quals, filter support, and context cancellation handling to ACM, API Gateway, EBS, EC2, ECR, ECS, EFS, EKS, Elastic Beanstalk, ElastiCache, Elasticsearch, EMR, EventBridge and RDS tables (#850)

v0.43.0 [2021-12-21]

What's new?

• New tables added
  • aws_iam_policy_attachment (#824)

Enhancements

• Updated default max records parameter value and lower limit for Access Analyzer, ACM, API Gateway, Application Auto Scaling, Audit manager, Backup, Cloud Control, CloudFormation, CloudFront, CloudWatch, CodePipeline, Config, DAX, DMS and DynamoDB tables (#829)

Bug fixes

• Fixed the aws_workspaces_workspace table to return an empty row for unsupported regions instead of throwing an error (#835)
• Querying the aws_ebs_snapshot table will now correctly return snapshot(s) details instead of an empty row (#842)
• The image_owner_alias column of aws_ec2_ami_shared table will now correctly display the AWS account alias (for example, amazon, self) or the AWS account ID of the AMI owner (#841)
• The image_owner_alias column of aws_ec2_ami table is now set to self by default (#841)

v0.42.2 [2021-12-14]

Bug fixes

• Fixed default max records parameter value and lower limit for aws_cloudwatch_alarm table

v0.42.1 [2021-12-14]

Bug fixes

• Queries no longer fail when using a wildcard in the region config argument due to the release of ap-southeast-3 region

v0.42.0 [2021-12-08]

What's new?

• New tables added
  • aws_ec2_managed_prefix_list (#813)
  • aws_vpc_peering_connection (#814)

Enhancements

• Added column prefix_list_id to aws_vpc_security_group_rule table (#801)
• Added column compliance_by_config_rule to aws_config_rule table (#817)
• Added column project_visibility to aws_codebuild_project table (821)
• Added additional optional key quals, filter support, and context cancellation handling to Access Analyzer, ACM, API Gateway, Application Auto Scaling, Audit manager, Backup, Cloud Control, CloudFormation, CloudFront, CloudWatch, CodeBuild, CodeCommit, CodePipeline, Config, DAX, Directory Service, DMS, DynamoDB and EBS tables (754)
• Added an example query for listing SQL server instances with SSL disabled in the aws_rds_db_instance table document (#806)
• README.md and docs/index.md files now have updated Slack channel links

Bug fixes

• Fixed the string field contains invalid UTF-8 error in the aws_ec2_instance table (#812)

v0.41.0 [2021-11-23]

What's new?

• New tables added
  • aws_elasticache_redis_metric_cache_hits_hourly (#753)
  • aws_elasticache_redis_metric_curr_connections_hourly (#753)
  • aws_elasticache_redis_metric_engine_cpu_utilization_hourly (#753)
  • aws_elasticache_redis_metric_get_type_cmds_hourly (#753)
  • aws_elasticache_redis_metric_list_based_cmds_hourly (#753)
  • aws_elasticache_redis_metric_new_connections_hourly (#753)
  • aws_serverlessapplicationrepository_application (#751)

Enhancements

• Recompiled plugin with steampipe-plugin-sdk v1.8.2 (#741)
• Added filter example queries in aws_cloudwatch_log_event table (#748)
• Added few more example queries in aws_iam_role table (#685)

Bug fixes

• aws_ec2_application_load_balancer table will no longer return ValidationError in get call (#792)
• aws_dax_cluster table will no longer return an error when we try to query for unsupported regions (#787)
• aws_lambda_alias table will now need name, function_name and region to perform get call (#781)

v0.40.0 [2021-11-17]

What's new?

• New tables added
  • aws_cloudwatch_log_resource_policy (#747)
  • aws_media_store_container (#749)

Enhancements

• Updated: Add policy_std column to the aws_ecrpublic_repository table (#778)
• Updated: Add policy_std column to the aws_ecr_repository table (#780)
• Updated: Add columns policy and policy_std to the aws_lambda_alias table (#774)
• Updated: Add columns policy and policy_std to the aws_lambda_version table (#776)
• Updated: Add columns policy and policy_std to the aws_secretsmanager_secret table (#745)

Bug fixes

• Fixed: aws_kinesis_firehose_delivery_stream table now includes better error handling (#769)
• Fixed: Remove duplicate data from the aws_backup_plan table (#767)
• Fixed: aws_ecrpublic_repository table will now return an empty row instead of an error when we try to query for any region other than us-east-1 (#770)

v0.39.1 [2021-11-15]

Bug fixes

• Fixed: Queries will no longer panic when encountering an error due to invalid references in the ShouldRetry function (#763)

v0.39.0 [2021-11-12]

What's new?

• New tables added
  • aws_eventbridge_bus (#737)
  • aws_lambda_layer (#740)
  • aws_lambda_layer_version (#743)

Enhancements

• Updated: Add policy_std column to aws_backup_vault table (#746)
• Updated: Increase the golangci-lint workflow timeout to 10 mins (#750)

Bug fixes

• Fixed: Queries will no longer hang if no credentials are provided or an invalid profile is specified (#713)

v0.38.2 [2021-11-08]

Enhancements

• Recompiled plugin with steampipe-plugin-sdk v1.7.3 (#741)

v0.38.1 [2021-11-05]

Bug fixes

• Updated data type of the column platform_version from int to string in aws_ssm_managed_instance table (#732)

v0.38.0 [2021-11-03]

What's new?

• New tables added
  • aws_ecs_task (#715)
  • aws_sfn_state_machine (#714)
  • aws_sfn_state_machine_execution (#724)
  • aws_sfn_state_machine_execution_history (#728)

Enhancements

• Updated: Recompiled plugin with steampipe-plugin-sdk v1.7.1 (#729)

v0.37.0 [2021-10-27]

What's new?

• New tables added
  • aws_backup_protected_resource (#704)
  • aws_backup_recovery_point (#705)
  • aws_fsx_file_system (#693)
  • aws_identitystore_user (#675)

Enhancements

• Updated: Recompiled plugin with steampipe-plugin-sdk v1.7.0 (#695)

Bug fixes

• Queries for global tables, e.g., aws_iam_user, will no longer return an error if no regions are specified for a connection (#690)
• Fixed the ecs_service table to correctly return the tags instead of returning null (#710)

v0.36.0 [2021-10-12]

What's new?

• New tables added
  • aws_ssoadmin_managed_policy_attachment (#664)
  • aws_workspaces_workspace (#681)

v0.35.1 [2021-10-08]

Bug fixes

• Fixed: Increase number of retries from 3->8 for Cloud Control service sessions to better handle throttling
• Fixed: Examples for aws_cloudcontrol_resource table are now correct

v0.35.0 [2021-10-08]

What's new?

• New tables added
  • aws_cloudcontrol_resource (#680)
  • aws_ssoadmin_permission_set (#659)

Enhancements

• Updated: Parliament IAM permissions to the latest (#676)
• Updated: Add additional optional key quals, filter support, and context cancellation handling to aws_ec2_instance, aws_iam_policy, aws_rds_db_cluster_snapshot tables (#638)
• Recompiled plugin with steampipe-plugin-sdk v1.6.2

v0.34.0 [2021-09-30]

What's new?

• New tables added
  • aws_identitystore_group (#663)

Bug fixes

• Add pagination to list and list tags functions in several tables (#660)

v0.33.0 [2021-09-22]

What's new?

• New tables added
  • aws_organizations_account (#650)
  • aws_ssoadmin_instance (#658)

Bug fixes

• When the macie service is not enabled in a particular region, aws_macie2_classification_job table will now return nil instead of error (#661)

v0.32.1 [2021-09-13]

Enhancements

• Recompiled plugin with steampipe-plugin-sdk v1.5.1 (#653)

v0.32.0 [2021-09-09]

What's new?

• New tables added
  • aws_ec2_transit_gateway_route (#637)

Enhancements

• Added customized exponential back-off retry logic to optimize retry mechanism (#635)

Bug fixes

• Fixed: Implemented pagination in aws_config_rule and aws_config_conformance_pack table (#646)
• Fixed: Improved documentations (#639)

v0.31.0 [2021-08-25]

What's new?

• New tables added
  • aws_ec2_capacity_reservation (#619)
  • aws_ec2_reserved_instance (#612)
  • aws_lambda_function_metric_duration_daily (#624)
  • aws_lambda_function_metric_errors_daily (#625)
  • aws_lambda_function_metric_invocations_daily (#627)
  • aws_tagging_resource (#628)

v0.30.0 [2021-08-20]

What's new?

• New tables added
  • aws_directory_service_directory (#572)
  • aws_ec2_application_load_balancer_metric_request_count_daily (#605)
  • aws_ec2_network_load_balancer_metric_net_flow_count (#527)
  • aws_ec2_application_load_balancer_metric_request_count (#527)
  • aws_ec2_network_load_balancer_metric_net_flow_count_daily (#604)
  • aws_rds_db_event_subscription (#609)
  • aws_redshift_cluster_metric_cpu_utilization_daily (#606)
  • aws_securityhub_standards_subscription (#286)

Enhancements

• Updated: Global services like IAM, S3, Route 53, etc. will now connect to us-gov-west-1 and cn-northwest-1 when creating service connections in GovCloud and China respectively (#613)
• Updated: Add column scheduled_actions to aws_redshift_cluster table (#523)
• Updated: Add column log_publishing_options to aws_elasticsearch_domain table (#593)
• Updated: Add column instance_lifecycle to aws_ec2_instance table (#617)

Bug fixes

• Fixed: aws_ec2_ssl_policy table will no longer generate duplicate values with multi-region setup (#594)
• Fixed: If no regions are set in the config file, the region will now correctly be determined from the AWS_DEFAULT_REGION or AWS_REGION environment variables if set (#598)

v0.29.0 [2021-08-06]

What's new?

• New tables added
  • aws_eks_identity_provider_config (#571)

Bug fixes

• Fixed: arn column data now contain the correct regions in regional resource tables (#590)
• Fixed: Querying columns dnssec_key_signing_keys and dnssec_status in aws_route53_zone table for private hosted zones no longer causes errors (#589)

v0.28.0 [2021-08-05]

What's new?

• New tables added
  • aws_emr_cluster_metric_is_idle (#570)

Bug fixes

• Fixed: aws_cloudtrail_trail table is now smarter when hydrating data for shadow trails (global and organization) (#578)
• Fixed: Route tables with IPv6 routes no longer cause queries to fail in the aws_vpc_route table (#581)

v0.27.0 [2021-07-31]

What's new?

• New tables added
  • aws_cloudtrail_trail_event (#564)
  • aws_cloudwatch_log_event (#564)
  • aws_ecs_cluster_metric_cpu_utilization (#563)
  • aws_ecs_cluster_metric_cpu_utilization_daily (#563)
  • aws_ecs_cluster_metric_cpu_utilization_hourly (#563)
  • aws_emr_instance_group (#562)
  • aws_vpc_flow_log_event (#564)

Bug fixes

• Fixed: aws_ec2_instance table should not panic when hydrating state_transition_time column if there is no state transition reason (#574)

v0.26.0 [2021-07-22]

What's new?

• New tables added
  • aws_codecommit_repository (#515)
  • aws_ecs_service (#555)

Enhancements

• Updated: Add column arn in aws_vpc_nat_gateway table (#540)
• Updated: Add multi-account connection information and examples to index doc (#565)
• Updated: Improve error message when connection config regions are not valid (#558)
• Updated: Cleanup region selection in connection creation code for table modules (#566)
• Recompiled plugin with steampipe-plugin-sdk v1.4.1

Bug fixes

• Fixed: Connection creation is now retried when receiving reset by peer errors (#557)
• Fixed: Fix plugin sometimes incorrectly selecting the wrong region from connection config (#561)
• Fixed: Hydration now works for created_at, name, title, updated_at, and version columns in aws_codepipeline_pipeline table (#537)
• Fixed: Several column descriptions in aws_ecs_task_definition table (#541)

v0.25.0 [2021-07-08]

What's new?

• New tables added
  • aws_auditmanager_evidence (#450)
  • aws_config_rule (#417)
  • aws_dynamodb_metric_account_provisioned_read_capacity_util (#518)
  • aws_dynamodb_metric_account_provisioned_write_capacity_util (#518)

Enhancements

• Updated: Add wildcard support when defining regions in plugin connection configuration (#530)
• Updated: Improve docs/index.md with expanded credential options and examples (#535)

Bug fixes

• Fixed: Fix various failing integration tests (#534)
• Fixed: Removed invalid key column definitions in various tables

v0.24.0 [2021-07-01]

What's new?

• New tables added
  • aws_codebuild_source_credential (#511)
  • aws_macie2_classification_job (#479)

Enhancements

• Updated: Rename column file_system_arn to arn in aws_efs_file_system table (#494)
• Updated: Rename column table_arn to arn in aws_dynamodb_table table (#495)
• Updated: Improve error message in aws_iam_credential_report table when no credential report exists (#510)
• Updated: Remove use of deprecated function ItemFromKey from aws_redshift_cluster table (#514)

v0.23.0 [2021-06-24]

What's new?

• New tables added
  • aws_auditmanager_evidence_folder (#435)
  • aws_backup_selection (#501)
  • aws_codepipeline_pipeline (#498)
  • aws_route53_domain (#360)

Bug fixes

• Fixed: Typo in description for common cloudwatch_metric timestamp column (#505)

v0.22.0 [2021-06-17]

What's new?

• New tables added
  • aws_ec2_ssl_policy (#362)
  • aws_eks_addon_version (#482)
  • aws_guardduty_finding (#488)
  • aws_ssm_managed_instance_compliance (#484)
  • aws_vpc_vpn_connection (#486)

Enhancements

• Updated: Add column arn to aws_api_gateway_stage table (#447)
• Updated: Add column arn to aws_ec2_classic_load_balancer table (#475)
• Updated: Add column event_subscriptions to aws_inspector_assessment_template table (#467)
• Updated: Add column logging_configuration to aws_wafv2_web_acl table (#470)
• Updated: Add columns dnssec_key_signing_keys and dnssec_status to aws_route53_zone table (#439)

Bug fixes

• Fixed: Cache key in ElasticsearchService function and update various cache keys to be more consistent (#500)
• Fixed: Tags hydrate call should not fail in aws_sagemaker_notebook_instance table (#372)

v0.21.0 [2021-06-10]

What's new?

• New tables added
  • aws_ec2_ami_shared (#456)
  • aws_ec2_regional_settings (#403)
  • aws_eks_addon (#478)
  • aws_sagemaker_endpoint_configuration (#477)

Enhancements

• Updated: Shadow trails are now included in aws_cloudtrail_trail table query results (#441)
• Updated: Add columns replication_group_id, snapshot_retention_limit, and snapshot_window to aws_elasticache_cluster table (#458)
• Updated: Add columns dead_letter_config_target_arn and reserved_concurrent_executions to aws_lambda_function table (#474)
• Updated: Rename column alarm_arn to arn in aws_cloudwatch_alarm table (#489)
• Recompiled plugin with steampipe-plugin-sdk v0.2.10

Bug fixes

• Fixed: GetCommonColumns function should only get STS caller identity once per account instead of per region (#490)

v0.20.0 [2021-06-03]

What's new?

• New tables added
  • aws_auditmanager_assessment (#430)
  • aws_auditmanager_control (#425)
  • aws_auditmanager_framework (#415)
  • aws_cloudfront_cache_policy (#431)
  • aws_cloudfront_origin_access_identity (#427)
  • aws_cloudfront_origin_request_policy (#432)

Enhancements

• Updated: Add column arn to aws_redshift_cluster table (#462)
• Updated: Add column arn to aws_vpc_network_acl table (#457)
• Updated: Add column object_lock_configuration to aws_s3_bucket table (#464)
• Updated: Add column state_transition_time to aws_ec2_instance table (#344)
• Updated: Bump urllib3 in /scripts/generate_parliament_iam_permissions (#471)
• Updated: Getting tags for clusters in 'creating' state should not error in aws_elasticache_cluster table (#454)
• Updated: Rename column replication_instance_arn to arn in aws_dms_replication_instance table (#455)

Bug fixes

• Fixed: Rename table_ aws_elasticsearch_domain.go to table_aws_elasticsearch_domain.go

v0.19.0 [2021-05-27]

What's new?

• Updated plugin license to Apache 2.0 per turbot/steampipe#488
• New tables added
  • aws_api_gatewayv2_integration (#346)
  • aws_cloudfront_distribution (#388)
  • aws_cost_by_account_daily (#437)
  • aws_cost_by_account_monthly (#437)
  • aws_cost_by_service_daily (#437)
  • aws_cost_by_service_monthly (#437)
  • aws_cost_by_service_usage_type_daily (#437)
  • aws_cost_by_service_usage_type_monthly (#437)
  • aws_cost_forecast_daily (#437)
  • aws_cost_forecast_monthly (#437)
  • aws_cost_usage (#437)
  • aws_ebs_volume_metric_read_ops (#437)
  • aws_ebs_volume_metric_read_ops_daily (#437)
  • aws_ebs_volume_metric_read_ops_hourly (#437)
  • aws_ebs_volume_metric_write_ops (#437)
  • aws_ebs_volume_metric_write_ops_daily (#437)
  • aws_ebs_volume_metric_write_ops_hourly (#437)
  • aws_ec2_instance_metric_cpu_utilization (#437)
  • aws_ec2_instance_metric_cpu_utilization_daily (#437)
  • aws_ec2_instance_metric_cpu_utilization_hourly (#437)
  • aws_efs_mount_target (#426)
  • aws_kinesisanalyticsv2_application (#358)
  • aws_rds_db_instance_metric_connections (#437)
  • aws_rds_db_instance_metric_connections_daily (#437)
  • aws_rds_db_instance_metric_connections_hourly (#437)
  • aws_rds_db_instance_metric_cpu_utilization (#437)
  • aws_rds_db_instance_metric_cpu_utilization_daily (#437)
  • aws_rds_db_instance_metric_cpu_utilization_hourly (#437)
  • aws_rds_db_instance_metric_read_iops (#437)
  • aws_rds_db_instance_metric_read_iops_daily (#437)
  • aws_rds_db_instance_metric_read_iops_hourly (#437)
  • aws_rds_db_instance_metric_write_iops (#437)
  • aws_rds_db_instance_metric_write_iops_daily (#437)
  • aws_rds_db_instance_metric_write_iops_hourly (#437)
  • aws_sagemaker_training_job (#384)
  • aws_ssm_managed_instance (#436)
  • aws_waf_rate_based_rule (#289)
  • aws_wafv2_rule_group (#281)

Enhancements

• Updated: Base64 data in the user_data column is now decoded in the aws_ec2_instance and aws_ec2_launch_configuration tables (#363)
• Updated: Add arn column to aws_account table (#418)
• Updated: Add arn column to aws_guardduty_detector table (#408)
• Updated: Add arn column to aws_ssm_association table (#404)

v0.18.0 [2021-05-20]

What's new?

• New tables added
  • aws_glue_catalog_database (#337)

Enhancements

• Updated: Add arn column to aws_ebs_snapshot table (#405)
• Updated: Add arn column to aws_vpc_eip table (#407)
• Updated: Improve availability zone count example in aws_lambda_function table doc (#413)

Bug fixes

• Fixed: Getting key rotation status for external keys should not error in aws_kms_key table (#398)

v0.17.0 [2021-05-13]

What's new?

• New tables added
  • aws_dms_replication_instance (#357)
  • aws_ecs_container_instance (#340)
  • aws_sagemaker_model (#371)
  • aws_waf_rule (#287)
  • aws_wafv2_ip_set (#255)
  • aws_wafv2_regex_pattern_set (#276)

Enhancements

• Updated: README.md and docs/index.md now contain links to our Slack community (#411)
• Updated: Add logging_status column to aws_redshift_cluster table (#350)
• Updated: Add missing columns available in the hydrate data to aws_ssm_association table (#356)
• Updated: Bump lodash from 4.17.20 to 4.17.21 in /aws-test (#389)

Bug fixes

• Fixed: Querying the aws_iam_account_password_policy table should not error if no password policy exists (#382)

v0.16.0 [2021-05-06]

What's new?

• New tables added
  • aws_accessanalyzer_analyzer (#341)
  • aws_appautoscaling_target (#353)
  • aws_wafv2_web_acl (#245)

Enhancements

• Updated: Add arn column to aws_config_configuration_recorder table (#380)
• Updated: Add arn column to aws_ebs_volume table (#368)
• Updated: Add arn column to aws_ec2_instance table (#367)
• Updated: Add arn column to aws_vpc_security_group table (#377)
• Updated: Add arn column to aws_vpc table (#378)
• Updated: Add automatic_backups column to aws_efs_file_system table (#351)

Bug fixes

• Fixed: Handling of pending subscriptions in aws_sns_topic_subscription table (#349)

v0.15.0 [2021-04-29]

What's new?

• New tables added
  • aws_dax_cluster (#328)
  • aws_ecrpublic_repository (#336)
  • aws_s3_access_point (#318)

Enhancements

• Updated: Parliament IAM permissions for Parliament v1.4.0 (#216)

Bug fixes

• Fixed: The aws_guardduty_threat_intel_set table should not throw an rpc error while trying to list threat intel sets (#343)

v0.14.0 [2021-04-22]

What's new?

• New tables added
  • aws_codebuild_project (#319)
  • aws_elasticsearch_domain (#327)
  • aws_sagemaker_notebook_instance (#324)
  • aws_secretsmanager_secret (#330)

Bug fixes

• Fixed: Replace hardcoded ARN references in aws_ec2_instance_type, aws_iam_policy, and aws_s3_bucket tables (#331)

v0.13.0 [2021-04-15]

What's new?

• New tables added
  • aws_elasticache_subnet_group (#247)
  • aws_guardduty_detector (#251)
  • aws_guardduty_ipset (#259)
  • aws_guardduty_threat_intel_set (#271)
  • aws_inspector_assessment_template (#248)
  • aws_redshift_snapshot (#238)

Enhancements

• Updated: Add arn column to aws_s3_bucket table (#313)

Bug fixes

• Fixed: Query example in aws_iam_server_certificate table docs (#309)

v0.12.0 [2021-04-08]

What's new?

• New tables added
  • aws_inspector_assessment_target (#234)

Enhancements

• Updated: Add metadata_options column to aws_ec2_instance table (#306)

v0.11.0 [2021-04-08]

What's new?

• New tables added
  • aws_backup_plan (#164)
  • aws_backup_vault (#163)
  • aws_elastic_beanstalk_application (#187)
  • aws_iam_server_certificate (#293)
  • aws_redshift_event_subscription (#230)
  • aws_securityhub_product (#207)
  • aws_wellarchitected_workload (#223)

Enhancements

• Updated: Add certificate_transparency_logging_preference, imported_at, renewal_eligibility, and type columns to aws_acm_certificate table (#299)
• Recompiled plugin with steampipe-plugin-sdk v0.2.7

Bug fixes

• Fixed: Rename column instance_profile_arn to instance_profile_arns and update data to be a list of ARNs (strings) in aws_iam_role table (#291)
• Fixed: Release dates in CHANGELOG no longer project versions out in the year 20201 (#284)

v0.10.1 [2021-04-02]

Bug fixes

• Fixed: Table definitions & examples link now points to the correct location (#282)

v0.10.0 [2021-04-01]

What's new?

• New tables added
  • aws_cloudwatch_alarm (#197)
  • aws_ecr_repository (#139)
  • aws_ecs_task_definition (#173)
  • aws_efs_access_point (#174)
  • aws_elastic_beanstalk_environment (#178)
  • aws_elasticache_replication_group (#246)
  • aws_glacier_vault (#165)
  • aws_kinesis_consumer (#222)
  • aws_redshift_subnet_group (#220)
  • aws_securityhub_hub (#166)

Enhancements

• Updated: Add canary_settings and method_settings columns to aws_api_gateway_stage table (#273)
• Updated: Add query_logging_configs column to aws_route53_zone table (#264)
• Updated: Example queries for aws_s3_bucket table to be more consistent with standards (#268)

Bug fixes

• Fixed: Remove unnecessary engine and region compatibility check when describing instances in the aws_rds_db_instance table (#263)
• Fixed: The aws_vpc table should ignore InvalidVpcID.NotFound errors (#270)

v0.9.0 [2021-03-25]

What's new?

• New tables added
  • aws_config_conformance_pack (#170)
  • aws_ecs_cluster (#140)
  • aws_efs_file_system (#144)
  • aws_elasticache_parameter_group (#176)
  • aws_emr_cluster (#152)
  • aws_kinesis_video_stream (#182)
  • aws_route53_resolver_endpoint (#137)
  • aws_route53_resolver_rule (#148)

Enhancements

• Updated: Add flow_log_status column to aws_vpc_flow_log table (#233)
• Updated: Add launch_time column to aws_ec2_instance table (#227)
• Recompiled plugin with steampipe-plugin-sdk v0.2.6

v0.8.0 [2021-03-18]

What's new?

• New tables added
  • aws_cloudtrail_trail (#34)
  • aws_eks_cluster (#131)
  • aws_elasticache_cluster (#130)
  • aws_eventbridge_rule (#135)
  • aws_kinesis_stream (#125)
  • aws_redshift_cluster (#204)
  • aws_ssm_association (#114)
  • aws_ssm_document (#110)

Enhancements

• Recompiled plugin with steampipe-plugin-sdk v0.2.4

Bug fixes

• Fixed: Various examples for aws_iam_access_advisor, aws_iam_policy_simulator, and aws_route53_record tables (#186)
• Fixed: Multi-region queries now work properly for the aws_lambda_version table (#192)
• Fixed: aws_availability_zone and aws_ec2_instance_availability tables now check region opt-in status to avoid AuthFailure errors (#168)
• Fixed: region column in aws_region table now shows the correct region instead of global (#133)

v0.7.0 [2021-03-11]

What's new?

• New tables added
  • aws_cloudwatch_log_stream
  • aws_config_configuration_recorder
  • aws_iam_virtual_mfa_device
  • aws_ssm_maintenance_window
  • aws_ssm_patch_baseline

Bug fixes

• Removed use of deprecated ItemFromKey function from all tables

v0.6.0 [2021-03-05]

What's new?

• Plugin now supports authentication through AWS SSO.
• New tables added
  • aws_ec2_gateway_load_balancer
  • aws_vpc_flow_log

Enhancements

• Updated: Added tags_src and tags columns to aws_iam_policy table.

v0.5.3 [2021-03-02]

Bug fixes

• Recompiled plugin with latest steampipe-plugin-sdk to resolve issue:
  • Fix tables failing with error similar to Error: pq: rpc error: code = Internal desc = get hydrate function getS3Bucket failed with panic interface conversion: interface {} is nil, not *s3.Bucket(#89).

v0.5.2 [2021-02-25]

Bug fixes

• Recompiled plugin with latest steampipe-plugin-sdk to resolve SDK issues:
  • Fix error for missing required quals #40.
  • Queries fail with error socket: too many open files #190

v0.5.1 [2021-02-22]

Bug fixes

• Ensure aws_account and aws_region table work when regions argument is specified in connection config (#70)

v0.5.0 [2021-02-18]

What's new?

• Added support for connection configuration. You may specify aws profiles, credentials, and regions for each connection in a configuration file. You can have multiple aws connections, each configured for a different aws account.
• Added multi-region support. A single connection can query multiple AWS regions, via the regions connection argument.

Enhancements

• Updated: Updated tag_list columns to tags_src for below RDS service tables.

  • aws_rds_db_cluster
  • aws_rds_db_cluster_parameter_group
  • aws_rds_db_cluster_snapshot
  • aws_rds_db_instance
  • aws_rds_db_option_group
  • aws_rds_db_parameter_group
  • aws_rds_db_snapshot
  • aws_rds_db_subnet_group

• Updated: added inline_policies_std column to aws_iam_group, aws_iam_role and aws_iam_user table with canoncialized inline policies.

v0.4.0 [2021-02-11]

What's new?

• New tables added to plugin

  • aws_iam_access_advisor (#42)
  • aws_route53_record (#43)
  • aws_route53_zone (#43)

Enhancements

• Updated: aws_iam_credential_report table to have password_status column (#48)

v0.3.0 [2021-02-04]

What's new?

• New tables added to plugin(#40)

  • aws_iam_account_password_policy
  • aws_iam_account_summary
  • aws_iam_action
  • aws_iam_credential_report
  • aws_iam_policy_simulator

Enhancements

• Updated: aws_ssm_parameter table to have value, arn, selector and source_result fields (#22)

• Updated: aws_iam_user table to have mfa_enabled and mfa_devices columns (#28) ​

Bug fixes

• Fixed: Now bucket_policy_is_public column for aws_s3_bucket will display the correct status of bucket policy (#36)

Notes

• The lifecycle_rules column of the table aws_s3_bucket has been updated to return an array of lifecycle rules instead of a object with key Rules holding lifecycle rules (#29)

v0.2.0 [2021-01-28]

What's new? ​

• Added: aws_ssm_parameter table ​
• Updated: aws_ec2_autoscaling_group to have policies field which contains the details of scaling policy.
• Updated: aws_ec2_instance table. Added instance_status field which includes status checks, scheduled events and instance state information. ​

Bug fixes ​

• Fixed: aws_s3_bucket table to list buckets even if the region is not set.