steampipe icon indicating copy to clipboard operation
steampipe copied to clipboard

Tables from Azure and AWS returns this invalid memory address or nil pointer dereference

Open jeffreymp17 opened this issue 9 months ago • 8 comments

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.

jeffreymp17 avatar May 21 '24 19:05 jeffreymp17