github.com/turbot/steampipe

Bug fixes

• Update FDW to 1.11.2 to remove unnecessary NOTICE level log messages. (#469)

Bug fixes

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

Whats new

• Add support for connection key columns. (#768)

A ConnectionKeyColumn defines a column that has a value which 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.

• Add support for pushing down sort order. (#447)
• Update limit pushdown logic to push down the limit if all sort clauses are pushed down. (#458)
• Add support for WHERE column=val1 OR column=val2 OR column=val3...
• Adds support for verbose timing information. (#4244)
• Migrate from plugin registry from GCP to GHCR. (#4232)

Bug fixes

• Fix hang when timing disabled. (#4237)
• Add signal handler for signal 16 to avoid FDW crash. (#457)

Breaking changes

• JSON query output has changed from a JSON array of result rows to a JSON object with a rows property containing the result rows, and (optionally) a metadata property containing timing information.

Bug fixes

• Fix issue where daily update check message showed a <nil> when there was no message to show. (#4206)
• Fix issue where local plugins are not being loaded. (#4196)
• Re-add support for 'implicit' local plugins (i.e. the plugin binary exists but there is no entry in the versions.json). (#4223)
• Add support for nested dashboards. (#4208)

Whats new

• Improve startup performance with high plugin count - parallelize plugin startup. (#4183)
• Add database SSL password support for encrypted private key in order to handle your own certificates. (#4149)

Bug fixes

• Fix issue where plugin list cannot re-create top-level versions.json file if the file has been corrupted or empty. (#4191)

Steampipe unbundled, introducing Powerpipe

Powerpipe is now the recommended way to run dashboards and benchmarks!

Mods still work as normal in Steampipe for now, but they are deprecated and will be removed in a future release:

• Steampipe unbundled →
• Powerpipe for Steampipe users →

Whats new

• Added version column to steampipe_plugin table. (#4141)
• Direct all errors and warnings to standard error (stderr). (4162)

Bug fixes

• Fixed the issue where search_path_prefix set in database options does not alter the search path. (#4160)
• Fix issue where asff output was always missing the first row. (#4157)

Deprecations and migrations

• Steampipe mods and dashboards are now separately available in Powerpipe, a new open-source project. The steampipe mod, check and dashboard commands have been deprecated and will be removed in a future version. Migration guide.
• Deprecated cloud-host and cloud-token CLI args, and replaced them with pipes-host and pipes-token respectively. (#4137)
• Deprecated STEAMPIPE_CLOUD_HOST and STEAMPIPE_CLOUD_TOKEN env vars, replaced with PIPES_HOST and PIPES_TOKEN respectively. (#4137)
• Deprecated cloud_host and cloud_token workspace args, replaced with pipes_host and pipes_token respectively. (#4137)
• Removed support for deprecated terminal options. (#3751)
• Removed support for deprecated max_parallel property in general options. (#4132)
• Removed support for deprecated connection options. (#4131)
• Removed deprecated version property from the mod require block. (#3750)

Bug fixes

• Fix growing memory usage following file watching events when running dashboard server. (#4150)

Bug fixes

• Fix variables not being reloaded after file watch event. (#4123)
• Fix modfile being left invalid after mod uninstall. Fix variables not being reloaded after file watch event. (#4124)

Bug fixes

• Fix HomeDirectoryModfileCheck returning false positive, causing errors when executing steampipe out of the home directory. (#4118)

Bug fixes

• Fix dependency variable validation - was failing if dependency variable value was set in the vars file. (#4110)
• Fix UI freeze when prompting for workspace variables. (#4105)

Bug fixes

• Fixed schema clone function failing if table has an LTREE column. (#4079)
• Maintain the order of execution when running multiple queries in batch mode. (#3728)
• Fixes issue where using any meta-command would load connection state even if not required. (#3614)
• Fixes issue where plugin version backfilling would write versions.json to cwd if the plugin folder is not found. (#4073)
• Simplifies and fix available port check. (#4030)

Whats new

• Allow using pprof on FDW when STEAMPIPE_FDW_PPROF environment variable is set. (#368)

Bug fixes

• Set connection state to error if plugin load fails. (#4043)
• Fixes incorrect row count in timing output for aggregator connections. (#402)
• OpenTelemetry metric names must only contain [A-Za-z0-9_.-]. (#369)
• Maintain the order of execution when running multiple queries in batch mode. (#3728)

Whats new

• Add steampipe_plugin_column introspection table to the steampipe_internal schema. (#4003)

Bug fixes

• Fixes issue where a query would return 'null' for an empty result set when output is set to json. (#3955)
• Fix custom registries bugs
• Clean up apt temporary files in Dockerfile

Bug fixes

• Added support for the missing mod-location flag to the steampipe variable list command. (#3942)

Whats new?

• Define rate and concurrency limits for plugin execution. (#3746)
• Define multiple instances of a plugin version using a plugin connection config block. (#3807)
• The maximum memory used by plugins and the CLI can now be specified either in plugin instance definitions or the new plugin options block. (#3807)
• New introspection tables steampipe_plugin and steampipe_plugin_limiter containing all configured plugin instances and limiters. (#3746)
• New introspection table steampipe_server_settings populated with server settings data during service startup. (#3462)
• Running plugin install with no arguments installs all referenced plugins. (#3451)
• New --output flag for plugin list cmd allows selection between json and table output. (#3368)
• Each plugin directory ncontains a version.json which can be used to recompose the global plugin versions.json if it is missing or corrupt. (#3492)
• Typing .cache in interactive prompt shows the current value of cache. (#2439)
• Steampipe commands bypass plugin requirement check if installed plugin is locally built. (#3643)
• New skip-config flag disables writing of default plugin config during plugin installation. (#3531, #2206)
• Logs are now written to file instead of console. (#2916)
• When plugin startup fails, report useful message in the CLI. (#3732)
• Users are warned to not have mod.sp files in home directory. (#2321)
• Updated messaging when service is started on an unavailable port. (#623)
• Log files are rotated if the process is active across date boundaries. (#125, #3825)
• Listen hosts may be selected when starting steampipe service. (#3505)
• Initialisation behaviour for the sample options has been changed: always copy a sample file (default.spc.sample), but only overwrite the default.spc file with the sample content if the existing file has not been modified. (#3431)
• Validation for the workspace profile cache settings. (#3646)
• Support OCI registries requiring authentication. (#2819)
• Compiled with Go 1.21. (#3763)

Bug fixes

• Plugin manager shutdown stalling intermittently due to deadlocks. (#3818)
• Temporary tables dropped in interactive prompt when pool connections recycled. (#3781,#3543)
• service start was not listening on network by default. (#3593)
• Multi line logs from plugins not rendered correctly in plugin logs. (#3678)
• .inspect panicking for long column descriptions. (#3709)
• Interactive prompt crashing when there is a code panic. (#3713)
• Incorrect zsh completion instructions.
• Steampipe should not create export files for cancelled control runs. (#3578)
• BuildFullResourceName not validating non empty arguments. (#3601)
• Spinner not showing when exporting check results. (#3577)
• stdin was consumed by query command even if there are arguments. (#1985)
• When exporting multiple benchmarks, results now merged the results into a single export. (#2380)
• Raise warning when pseudo-resources are ignored because of named HCL resources. (#1328)
• Database reinstalled unnecessarily if any FDW files were missing. (#2040)
• Improved error message when steampipe fails to parse a mod definition file because mod block does not exist. (#1198)
• Only install-dir and workspace flags should be global flags. All other flags should only apply to specific command. (#3542)
• Passing an empty list for list variables was not working. (#2094)
• Show deprecation warning for version field in require block of mod definition.
• Temporary directories were not always being cleaned up after plugin commands.
• plugin list returned nothing if no plugins were installed. (#3927)

Deprecations and migrations

• Table steampipe_connection_state renamed to steampipe_connection
• Removed migration and backward compatibility of data files from v0.13.0. (#3517)
• Removed deprecated workspace-chdir flag. (#3925)
• Migrated from cloud.steampipe.io to pipes.turbot.com. (#3724)
• Removed support for plugins which do not support multiple connections (i.e. using SDK < v4.0.0).
• Deprecated terminal options.

Whats new?

• Updated help outputs for steampipe mod commands. (#1817)

Bug fixes

• Fixes issue where expired root and server SSL certificates were not getting rotated. (#3596)
• Fixes issue where steampipe was returning an index out of range error when the children property of a benchmark contains an invalid name. (#3563)
• Steampipe should not validate locally installed plugins when connecting to remote database. (#3516)

Bug fixes

• Fix validation error for input blocks using base inheritance. (#3755)
• Fix support for mixed case schema names. (#3753)
• If the SQL file passed as an argument to steampipe query does not exist, display the file does not exist error. (#1752)

Bug fixes

• Fixes issue where CAPITAL arguments to '.cache' meta command were not getting recognised. (#3670)
• Fixes issue where port property in dashboard options was not respected. (#3664)
• Fixes issue where using a bad workspace-database with a valid token gives invalid token as the error. (#3610)
• Fixes timing issue where refresh connections was sometimes not run when starting service. (#3734)
• Fixes issue where db connections are not closed after sending postgres notification. (#3744)

Bug fixes

• Fix aggregator connections being dropped intermittently when refreshing connections. (#3664)
• Ensure dynamic aggregator schema is updated if connections are added. (#3645)

Bug fixes

• Fixes issue where setting cache ttl from the CLI results in cache being disabled for that session. (#3639)