Skip to main content

policy_tests

Creates, updates, deletes, gets or lists a policy_tests resource.

Overview

Namepolicy_tests
TypeResource
Idcloudflare.zero_trust.policy_tests

Fields

The following fields are returned by SELECT queries:

Get an Access policy test update response.

NameDatatypeDescription
idstringThe UUID of the policy test. (example: f1a8b3c9d4e5f6789a0b1c2d3e4f5678a9b0c1d2e3f4a5b67890c1d2e3f4b5a6)
percent_approvedintegerThe percentage of (processed) users approved based on policy evaluation results.
percent_blockedintegerThe percentage of (processed) users blocked based on policy evaluation results.
percent_erroredintegerThe percentage of (processed) users errored based on policy evaluation results.
percent_users_processedintegerThe percentage of users processed so far (of the entire user base).
statusstringThe status of the policy test. (blocked, processing, exceeded time, complete) (example: complete)
total_usersintegerThe total number of users in the user base.
users_approvedintegerThe number of (processed) users approved based on policy evaluation results.
users_blockedintegerThe number of (processed) users blocked based on policy evaluation results.
users_erroredintegerThe number of (processed) users errored based on policy evaluation results.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectaccount_id, policy_test_idFetches the current status of a given Access policy test.
createinsertaccount_idStarts an Access policy test.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
account_idstringThe Cloudflare account ID.
policy_test_idstring

SELECT examples

Fetches the current status of a given Access policy test.

SELECT
id,
percent_approved,
percent_blocked,
percent_errored,
percent_users_processed,
status,
total_users,
users_approved,
users_blocked,
users_errored
FROM cloudflare.zero_trust.policy_tests
WHERE account_id = '{{ account_id }}' -- required
AND policy_test_id = '{{ policy_test_id }}' -- required
;

INSERT examples

Starts an Access policy test.

INSERT INTO cloudflare.zero_trust.policy_tests (
policies,
account_id
)
SELECT
'{{ policies }}',
'{{ account_id }}'
RETURNING
errors,
messages,
result,
success
;