Open khushboo9024 opened 3 weeks ago
Hi @khushboo9024, As per my findings the APIs(List/Get) have a property named MaxThroughput
under SQLDatabaseGetProperties. However, the API is returning null value for this property all the time.
az cosmosdb sql database list --resource-group test7 --account-name test4446666
/az cosmosdb sql database show --resource-group test7 --account-name test4446666 --name test5353
) is also not returning any result for autoscaling settings.azure_cosmosdb_sql_container
Thanks!
@khushboo9024, I have pushed a rough code into the issue-772
branch that adds a new table called azure_cosmosdb_sql_container
. With this, I am able to retrieve the throughput details for the containers.
> select name,account_name, database_name, jsonb_pretty(throughput_settings) from azure_cosmosdb_sql_container
+--------+--------------+---------------+---------------------------+
| name | account_name | database_name | jsonb_pretty |
+--------+--------------+---------------+---------------------------+
| test53 | test93 | test63 | <null> |
| Items | tes-acc33 | ToDoList | { |
| | | | "Resource": { |
| | | | "throughput": 400 |
| | | | } |
| | | | } |
+--------+--------------+---------------+---------------------------+
Time: 5.4s. Rows returned: 2. Rows fetched: 2. Hydrate calls: 2.
Please give it a go in the PR branch and let me know if that helps. I will do some cleanup in the branch and raise the PR then.
Thanks!
Describe the bug The column autoscale_settings_max_throughput in the table azure_cosmosdb_sql_database is coming up as null even though we have data.
Steampipe version (
steampipe -v
) Example: v0.3.0Plugin version (
steampipe plugin list
) Example: v0.5.0To reproduce Steps to reproduce the behavior (please include relevant code and/or commands).
Expected behavior A clear and concise description of what you expected to happen.
Additional context Add any other context about the problem here.