I am getting errors while running Azure queries. Please see the highlighted ones; those are throwing errors. I even have the azure_policy_results table in my PostgreSQL database. Please kindly help.
Hi Ravi,
Can you please provide the link in GitHub that this screenshot is from?
Also, can you post details of the error you are seeing?
Many thanks.
Hi,
I’m having an issue with the following query:
Secure Transfer to Storage Accounts Should Be Enabled
Please see the error details. I have the azure_policy_results table, but the data is not being inserted into the table when I execute the Azure queries. This isn’t just happening for a single query; it’s occurring for all Azure queries. I’m sure I am missing something.
Any help would be appreciated!
I posted in the other thread, but essentially I would like to see your CloudQuery configuration for the Azure source plugin to see what tables you are attempting to sync. If you could post the configuration here with any sensitive information redacted. Thank you.
@inspired-monkfish - To execute the policies, you have to do it with the psql utility as it is documented here.
When executing the policies with the psql utility, the variables :'execution_time', :check_id, and :framework are set automatically.