stackql  >>select a.name rg_name, 
stackql  >>       b.name vmss_name,
stackql  >>       c.id vm_name
stackql  >>  from
stackql  >>    azure.resources.resource_groups a
stackql  >>    inner join azure.compute.virtual_machine_scale_sets b 
stackql  >>    on a.name = b.resourceGroupName
stackql  >>    inner join azure.compute.virtual_machine_scale_set_vms c
stackql  >>    on  b.name = c.virtualMachineScaleSetName  
stackql  >>where subscriptionId = 'bb00d6d4-b2ad-4499'
stackql  >>and a.name = c.resourceGroupName  ;
data flow: cannot accomodate table dependencies of this complexity: supplied = 2, max = 1
stackql  >>select a.name rg_name, 
stackql  >>       b.name vmss_name, 
stackql  >>       split_part(b.id,'/',5) as id
stackql  >>  from
stackql  >>    azure.resources.resource_groups a
stackql  >>    inner join azure.compute.virtual_machine_scale_sets b 
stackql  >>    on a.name = b.resourceGroupName
stackql  >>    inner join azure.compute.virtual_machine_scale_set_vms c
stackql  >>    on  b.name = c.virtualMachineScaleSetName  
stackql  >>    and split_part(b.id,'/',5) = c.resourceGroupName 
stackql  >>where subscriptionId = 'bb00d6d4-b2ad-4499';
data flow: cannot accomodate table dependencies of this complexity: supplied = 2, max = 1
stackql  >>select a.name rg_name, 
stackql  >>       b.name vmss_name,
stackql  >>       c.id vm_name
stackql  >>  from
stackql  >>    azure.resources.resource_groups a
stackql  >>    inner join azure.compute.virtual_machine_scale_sets b 
stackql  >>    on a.name = b.resourceGroupName
stackql  >>    inner join azure.compute.virtual_machine_scale_set_vms c
stackql  >>    on  b.name = c.virtualMachineScaleSetName
stackql  >>    and a.name = c.resourceGroupName    
stackql  >>where subscriptionId = 'bb00d6d4-b2ad-4499'
stackql  >>;
data flow: too complex for now; 2 dependencies detected when max allowed = 1