Bug fixes

• Fixed an issue where Steampipe failed to create a new connection if it was outside the defined search path. (#4353)

Whats new

• Recompiled CLI with Go v1.22. (#4340)

Bug fixes

• Fixed query error message to not include internal function names. (#4335)

What's new?

• New tables added
  • prismacloud_account
  • prismacloud_alert
  • prismacloud_alert_rule
  • prismacloud_compliance_breakdown_requirement_summary
  • prismacloud_compliance_breakdown_statistic
  • prismacloud_compliance_breakdown_summary
  • prismacloud_compliance_requirement
  • prismacloud_compliance_standard
  • prismacloud_iam_permission
  • prismacloud_iam_role
  • prismacloud_iam_user
  • prismacloud_inventory_api_endpoint
  • prismacloud_inventory_asset_explorer
  • prismacloud_inventory_asset_view
  • prismacloud_inventory_workload
  • prismacloud_inventory_workload_container_image
  • prismacloud_inventory_workload_host
  • prismacloud_permission_group
  • prismacloud_policy
  • prismacloud_prioritized_vulnerabilitiy
  • prismacloud_report
  • prismacloud_resource
  • prismacloud_trusted_alert_ip
  • prismacloud_vulnerabilitiy_asset
  • prismacloud_vulnerabilitiy_burndown
  • prismacloud_vulnerabilitiy_overview

What's new?

• New tables added
  • linode_firewall
  • linode_node_balancer

Enhancements

• The euuid column has now been assigned as a connection key column across all the tables which facilitates more precise and efficient querying across multiple Linode accounts. (#56)
• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package. (#60)
• Added the version flag to the plugin's Export tool. (#65)

Dependencies

• Recompiled plugin with linode-sdk-for-go v1.37.0. (#56)
• Recompiled plugin with steampipe-plugin-sdk v5.10.1 which ensures that QueryData passed to ConnectionKeyColumns value callback is populated with ConnectionManager. (#55)

Bug fixes

• Fixed the okta_factor table to correctly return data instead of a nil pointer dereference error. (#137)
• Fixed the caching issue in the standalone plugin FDW extensions. (#480)

Enhancements

• Added the GetConfig in the github_repository_content table. (#445)

Bug fixes

• Fixed the caching issue in the standalone plugin FDW extensions. (#480)

Enhancements

• Added Reader and Data Access role assignment information to the docs/index.md file. (#811)

Bug fixes

• Fixed the azure_compute_virtual_machine table to correctly populate the guest_configuration_assignments column across all Azure environments. (#816)
• Fixed the azure_role_assignment table to correctly return the result while using any mode of plugin authentication. (#809)
• Fixed the paging issue in the azure_monitor_activity_log_event table. (#810)
• Fixed the caching issue in the standalone plugin FDW extensions. (#480)

Enhancements

• Added location_type column as an optional qual to the aws_ec2_instance_availability table and 6 new columns to the aws_ec2_instance_type table. (#2078)
• Updated docs for aws_appautoscaling_policy and aws_appautoscaling_target tables to add information on required quals. (#2247)
• Added the type column as an optional qual to the aws_auditmanager_control table. (#2254)

Bug fixes

• Fixed the GetConfig definition of the aws_auditmanager_control table to correctly return data instead of an error. (#2254)
• Fixed the aws_kms_key_rotation table to correctly return nil whenever an AccessDeniedException error is returned by the API. (#2253)
• Fixed the caching issue in the standalone plugin FDW extensions. (#480)

Breaking changes

• Removed the following columns in gcp_cloudfunctions_function table to align with the new API response structure: (#612)
  • environment_variables
  • source_upload_url
  • version_id

What's new?

• Added the impersonate_access_token config argument to support plugin authentication by using a pre-generated temporary access token. (#621)

Enhancements

• Added 17 new columns to the gcp_cloudfunctions_function table. (#612)

Bug fixes

• Fixed the cache key issue in the SecretManager service client creation. (#624)

Enhancements

• Added column create_time to gcp_sql_database_instance table. (#615)

Bug fixes

• Fixed the gcp_alloydb_cluster and gcp_alloydb_instance tables to correctly return values for project column instead of null. (#617)

What's new?

• New tables added
  • azure_resource (#803)

Bug fixes

• Fixed the power_state column of the azure_compute_virtual_machine table to correctly return data instead of a nil pointer dereference error. (#804)

Bug fixes

• Fixed plugin loading issues by eliminating the need for manual caching, ensuring smoother and more reliable plugin installations. (#50)

What's new?

• Added the insecure_skip_verify connection config argument to support bypassing the SSL/TLS certificate verification while querying the tables. (#48)

Enhancements

• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package.

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.1 that adds support for connection key columns. (#49)

Bug fixes

• Fixed issue where local Docker config for the credential store was used when installing plugins from GHCR, enabling installation from GHCR to work even if docker-credential-desktop is not in PATH. (#4323)
• Fixed issue where Steampipe returned a 0 exit code even if it failed to export a snapshot. (#4276)
• Fixed issue where the query command did not support the legacy 'true' and 'false' values for the --timing flag. (#4282)
• Fixed issue where SPS output was not working. (#4297)
• Fixed issue where loading connection plugins did not return successfully created connections if some connections failed due to the configuration not being available. (#474)
• Fixed issue where scan info in query JSON output was shown even when the timing configuration was not set to verbose. (#4292)

What's new?

• New tables added
  • okta_device (#50)

Enhancements

• The domain column has now been assigned as a connection key column across all the tables which facilitates more precise and efficient querying across multiple Okta organizations. (#120)
• Added support to specify the time period in .spc file for max retries, request timeout, and max backoff time as required. (#112)
• Added profile column to the okta_factor table. (#130)

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.1 which ensures that QueryData passed to ConnectionKeyColumns value callback is populated with ConnectionManager. (#120)

Enhancements

• The organization_id column has now been assigned as a connection key column across all the tables which facilitates more precise and efficient querying across multiple Linear accounts. (#34)

Bug fixes

• Fixed the plugin to correctly check for a valid Personal Access token. (#33)

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.1 which ensures that QueryData passed to ConnectionKeyColumns value callback is populated with ConnectionManager. (#34)

Enhancements

• Added column power_state to the azure_compute_virtual_machine_scale_set_vm table. (#800) (Thanks @pdepdecatcat for the contribution!)

Bug fixes

• Fixed the azure_log_alert table to correctly return values for actions, condition, description, enabled, and scopes columns instead of null. (#796)

What's new?

• New tables added
  • aws_rds_db_recommendation (#2238)

Bug fixes

• Fixed the caching issue in aws_organizations_account table. (#2236)
• Fixed typo (missing comma) in an example query of aws_health_affected_entity table document. (#2237) (Thanks @tieum for the contribution!)

Bug fixes

• Fixed the export tool of the plugin to return a non-zero error code instead of 0 whenever an error occurred. (#79)

Enhancements

• Added column public_network_access to the azure_storage_account table. (#794)

Bug fixes

• Fixed the export tool of the plugin to return a non-zero error code instead of 0 whenever an error occurred. (#79)

Enhancements

• Added 16 new columns to the aws_lambda_version table. (#2229)

Bug fixes

• Fixed the export tool of the plugin to return a non-zero error code instead of 0 whenever an error occurred. (#79)

Bug fixes

• Reverted the export CLI behavior to return <nil> for null values instead of "". (#77)

Bug fixes

• Reverted the export CLI behavior to return <nil> for null values instead of "". (#77)

Bug fixes

• Reverted the export CLI behavior to return <nil> for null values instead of "". (#77)

What's new

• New tables added
  • aws_codestar_notification_rule (#2217)

Enhancements

• Added 9 new columns to the aws_elasticache_cluster table. (#2224)

Bug fixes

• Fixed the aws_s3_object table not returning any rows due to panic error. (#2221)
• Fixed no rows being returned from the ``` table if an unqualified query is run before one with parent_id specified.
• Fixed data type for configuration_endpoint column in aws_elasticache_cluster table to be json. (#2214)

What's new?

• New tables added
  • terraform_variable (#97)

Enhancements

• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package. (#101)
• Added the version flag to the plugin's Export tool. (#65)

Bug fixes

• Fixed the arguments column of terraform_resource table to correctly return the type field. (#99) (#92)

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.1 that adds support for connection key columns. (#92)

What's new?

• New tables added
  • github_repository_ruleset (#440)

Bug fixes

• Improved the error messaging for file parsing in the github_workflow table. (#438)

Dependencies

• Recompiled plugin with github.com/cloudflare/circl v1.3.7. (#418)

What's new?

• New tables added
  • azure_data_protection_backup_job (#786)
  • azure_lighthouse_assignment (#785)
  • azure_lighthouse_definition (#785)

Enhancements

• Added column tags to the azure_subscription table. (#784)
• Added the following columns to the azure_network_interface table: (#779)
  • auxiliary_mode
  • disable_tcp_state_tracking
  • dscp_configuration
  • migration_phase
  • nic_type
  • private_endpoint
  • private_link_service
  • vnet_encryption_supported
  • workload_type

Bug fixes

• Fixed the issue of missing and inconsistent columns in Kubernetes CRD tables. (#229) (Thanks @dongho-jung for the contribution!!)

What's new?

• New tables added
  • aws_route53_vpc_association_authorization (#2199) (Thanks @jramosf for the contribution!)

Enhancements

• Updated aws_s3_bucket, aws_s3_bucket_intelligent_tiering_configuration, aws_s3_object and aws_s3_object_version tables to use HeadBucket API instead of GetBucketLocation to fetch the region that the bucket resides in. (#2082) (Thanks @pdecat for the contribution!)
• Added column create_time to aws_ec2_key_pair table. (#2196) (Thanks @kasadaamos for the contribution!)
• Added instance_type column as an optional qual to the aws_ec2_instance_type table. (#2200)

Bug fixes

• Fixed the akas column in aws_health_affected_entity table to correctly return data instead of an error by handling events that do not have any ARN. (#2189)
• Fixed cname and endpoint_url columns of aws_elastic_beanstalk_environment table to correctly return data instead of null. (#2201)
• Fixed the aws_api_gatewayv2_* tables to correctly return data instead of an error by excluding support for the new unsupported il-central-1 region. (#2190)

What's new?

• New tables added
  • pipes_tenant (#35)
  • pipes_tenant_member (#35)

Enhancements

• The login_id column has now been assigned as a connection key column across all the tables which facilitates more precise and efficient querying across multiple Jira connections. (#119)
• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package. (#128)
• Added the version flag to the plugin's Export tool. (#65)

Bug fixes

• Fixed pagination in the jira_board table to correctly return all the data instead of partial results. (#127)

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.1 that adds support for connection key columns. (#119)

What's new?

• New tables added
  • azure_cdn_frontdoor_profile (#777)
  • azure_data_protection_backup_vault (#776)
  • azure_log_analytics_workspace (#767)
  • azure_private_endpoint (#775)

Bug fixes

• Fixed the public_network_access_for_ingestion and the public_network_access_for_query columns of the azure_application_insight table to be of String data type instead of JSON. (#769)
• Fixed the azure_role_assignment table to correctly return values for principal_id and principal_type columns instead of null. (#763)
• Fixed the web_application_firewall_configuration column of the azure_application_gateway table to correctly return data instead of null. (#770)

What's new?

• Added support for the profile connection config argument. (#409)

Bug fixes

• Fixed the alicloud_cs_kubernetes_cluster table to ensure it correctly returns data when querying clusters without tags. (#426)

What's new?

• New tables added
  • gcp_alloydb_cluster (#597)
  • gcp_alloydb_instance (#597)
  • gcp_secret_manager_secret (#593)

Bug fixes

• Fixed the gcp_sql_database table to skip SQL database instances that are not in the running state. (#586)
• Fixed the gcp_kubernetes_node_pool table to skip clusters that have autopilot mode enabled. (#591)

Enhancements

• The user_id column has now been assigned as a connection key column across all the tables which facilitates more precise and efficient querying across multiple Pipes connections. (#27)
• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package. (#32)
• Added the version flag to the plugin's Export tool. (#65)

Bug fixes

• Fixed the plugin to correctly authenticate against a custom tenant in Pipes instead of returning a 401 error. (#30)

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.1 that adds support for connection key columns. (#27)

What's new?

• New tables added
  • github_blob (#430) (Thanks @rmhartog for the contribution!)
  • github_repository_content (#317)

Enhancements

• The login_id column has now been assigned as a connection key column across all the tables which facilitates more precise and efficient querying across multiple Github connections. (#422)
• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package. (#219)
• Added the version flag to the plugin's Export tool. (#65)

Bug fixes

• Fixed the plugin support for Github OAuth Access token to work correctly. (#432)

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.1 that adds support for connection key columns. (#422)

Bug fixes

• Updated Postgres FDW to v1.11.2 to remove unnecessary NOTICE level log messages. (#469)

Enhancements

• The tenant_id column has now been assigned as a connection key column across all the tables which facilitates more precise and efficient querying across multiple Microsoft 365 subscriptions. (#50)
• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package. (#55)
• Added the version flag to the plugin's Export tool. (#65)

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.1 which ensures that QueryData passed to ConnectionKeyColumns value callback is populated with ConnectionManager. (#50)

Enhancements

• The tenant_id column has now been assigned as a connection key column across all the tables which facilitates more precise and efficient querying across multiple Azure subscriptions. (#175)
• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package. (#180)
• Added support for China cloud endpoint and scope based on the environment. (#174)
• Added the version flag to the plugin's Export tool. (#65)

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.1 which ensures that QueryData passed to ConnectionKeyColumns value callback is populated with ConnectionManager. (#175)

• New tables added
  • oci_database_exadata_infrastructure (#582)

Enhancements

• The tenant_id column has now been assigned as a connection key column across all the tables which facilitates more precise and efficient querying across multiple OCI tenants. (#606)
• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package. (#614)
• Added the version flag to the plugin's Export tool. (#65)

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.0 that adds support for connection key columns. (#606)
• Recompiled plugin with github.com/hashicorp/go-getter v1.7.4. (#611)

Enhancements

• The project column has now been assigned as a connection key column across all the tables which facilitates more precise and efficient querying across multiple GCP projects. (#564)
• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package. (#580)
• Added the version flag to the plugin's Export tool. (#65)****

Bug fixes

• Fixed the table gcp_cloudfunctions_function to list gen2 cloud functions. (#568) (Thanks @ashutoshmore658 for the contribution!)

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.0 that adds support for connection key columns. (#564)
• Recompiled plugin with github.com/hashicorp/go-getter v1.7.4. (#570)

Enhancements

• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package. (#756)

Bug fixes

• Fixed the server_properties column in the azure_postgresql_flexible_server table to correctly return data instead of nil. (#754)

Dependencies

• Recompiled plugin with azure-sdk-for-go v68.0.0+incompatible. (#747)
• Recompiled plugin with steampipe-plugin-sdk v5.10.1 which ensures that QueryData passed to ConnectionKeyColumns value callback is populated with ConnectionManager. (#755)

Enhancements

• The account_id column has now been assigned as a connection key column across all the tables which facilitates more precise and efficient querying across multiple Alibaba Cloud accounts. (#406)
• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package. (#419)
• Added the version flag to the plugin's Export tool. (#65)

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.0 that adds support for connection key columns. (#406)
• Recompiled plugin with github.com/hashicorp/go-getter v1.7.4. (#412)

Bug fixes

• Updated FDW to 1.11.1 to fix bad Linux Arm build. (#4271)
• Updated hydrates count in timing verbose mode to use integer formatting(e.g. 119,138). (#4270)

Enhancements

• The context_name column has now been assigned as a connection key column across all the tables which facilitates more precise and efficient querying across multiple Kubernetes connections. (#217)
• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package. (#219)
• Added the version flag to the plugin's Export tool. (#65)

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.0 that adds support for connection key columns. (#217)
• Recompiled plugin with github.com/hashicorp/go-getter v1.7.4. (#218)

v0.138.0 [2024-05-09]

Enhancements

• The Plugin and the Steampipe Anywhere binaries are now built with the netgo package for both the Linux and Darwin systems. (#219) (#2180)

Bug fixes

• Fixed the aws_ebs_snapshot table to correctly return data instead of an empty row. (#2185)

Dependencies

• Recompiled plugin with github.com/hashicorp/go-getter v1.7.4. (#2178)

Whats new

• Added support for connection key columns: (#768)

  A connection key column defines a column whose value maps 1-1 to a Steampipe connection and so can be used to filter connections when executing an aggregator query. These columns are treated as (optional) KeyColumns. This means they are taken into account in the query planning.

• Added support for verbose timing information. (#4244)

• Added support for pushing down sort order. (#447)

• Updated limit pushdown logic to push down the limit if all sort clauses are pushed down. (#458)

• Added support for WHERE column=val1 OR column=val2 OR column=val3...

• Migrated from plugin registry from GCP to GHCR. (#4232)

Bug fixes

• Fixed hang when timing is disabled. (#4237)
• Added a signal handler for signal 16 to avoid FDW crash. (#457)

Bug fixes

• Ensured QueryData passed to connection key column value callback is populated with ConnectionManager. (#797)

What's new?

• New tables added
  • azure_backup_policy (#739)

Enhancements

• The subscription_id column has now been assigned as a connection key column across all the tables which facilitates more precise and efficient querying across multiple Azure subscriptions. (#740)
• Added the version flag to the plugin's Export tool. (#65)

Bug fixes

• Fixed the plugin's Postgres FDW Extension crash issue.

Dependencies

• Recompiled plugin with steampipe-plugin-sdk v5.10.0 that adds support for connection key columns. (#745)