steampipe
steampipe copied to clipboard
Tables from Azure and AWS returns this invalid memory address or nil pointer dereference
Describe the bug
There are some tables that returns this error invalid memory address or nil pointer dereference
when we execute a query
for example Azure tables
SELECT
scc.id,
sub.subscription_id,
sub.display_name,
scc.email,
scc.alert_notifications,
scc.alerts_to_admins
FROM
azure_security_center_contact AS scc
INNER JOIN azure_subscription AS sub ON sub.subscription_id = scc.subscription_id
WHERE
scc.alert_notifications = 'On';
and this one
select
sa.subscription_id,
sa.name,
sa.id as resource,
sa.network_rule_default_action,
resource_group,
sub.display_name as subscription
from
azure_storage_account sa,
azure_subscription sub
where
sub.subscription_id = sa.subscription_id and
sa.network_rule_default_action = 'Allow';
GCP queries
select
name,
cluster_name,
config ->> 'imageType' as image_type,
location,
project
from
gcp_kubernetes_node_pool
where
config ->> 'imageType' != 'COS_CONTAINERD';
select
name,
cluster_name,
initial_node_count,
version,
status,
project,
autoscaling -> 'enabled' as autoscaling_enabled,
location
from
gcp_kubernetes_node_pool
where
autoscaling ->> 'enabled' != 'true'
or autoscaling = '{}';
Steampipe version (steampipe -v
)
Example: v0.19.3
To reproduce Execute the queries added in the description
Expected behavior
Should not receive this error invalid memory address or nil pointer dereference
and return results
Additional context Add any other context about the problem here.