azure_storage_account > virtual_network_rules does not work

[rajlearner17]

Even if we have data available as mentioned in the screen the query below does not show any data.

select virtual_network_rules from azure_storage_account where name = 'anothertesting'

We can extend azure_storage_account to add additional data in virtual_network_rules field to include the data for Firewalls and virtual networks

[rajlearner17]

FYI
This works

select name from azure_storage_account
+----------------+
| name |
+----------------+
| anothertesting |
+----------------+

[Subhajit97]

@rajmohanty17 I am not able to reproduce the above issue. The above mentioned query is working for me.
I am using the following configuration

> steampipe --version
steampipe version 0.3.3

> steampipe plugin list
+-----------------------------------------------------+---------+-----------------+
| NAME                                                | VERSION | CONNECTIONS     |
+-----------------------------------------------------+---------+-----------------+
| hub.steampipe.io/plugins/turbot/azure@latest        | 0.3.1   | azure           |
+-----------------------------------------------------+---------+-----------------+

I have created the resource with following configuration

> select jsonb_pretty(virtual_network_rules) from azure_storage_account
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| jsonb_pretty                                                                                                                                                       |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| [                                                                                                                                                                  |
|     {                                                                                                                                                              |
|         "id": "/subscriptions/********-****-****-****-************/resourcegroups/turbot_rg/providers/Microsoft.Network/virtualnetworks/test-net/subnets/default", |
|         "state": "Succeeded",                                                                                                                                      |
|         "action": "Allow"                                                                                                                                          |
|     }                                                                                                                                                              |
| ]                                                                                                                                                                  |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+
>
>
> select jsonb_pretty(network_ip_rules) from azure_storage_account
+------------------------------------+
| jsonb_pretty                       |
+------------------------------------+
| [                                  |
|     {                              |
|         "value": "182.71.32.0/20", |
|         "action": "Allow"          |
|     }                              |
| ]                                  |
+------------------------------------+
>

Can you please try with the latest plugin?

[cbruno10]

@debabrat-git can you please take a look at @Subhajit97 's comment above?

[rajlearner17]

closing this based on the workable comment.