Viewing Usage Information in the Data Warehouse

Elastic Access usage data is sent to the data warehouse immediately after any transaction has completed. It may occasionally take a minute or two for usage to become available in the data warehouse, but generally it will be available in a small number of seconds.

If you are using FlexNet Operations, the data can be accessed from the data warehouse either using the Data Access APIs, or using a Snowflake Data Share. Please see the documentation about the Data Access APIs for how to make use of these access approaches.

If you are using your own custom back office you can access the data using a Snowflake Data Share.

Information Sent to the Data Warehouse

The following fields are populated in the data warehouse usage table:

Field Name	Description
CORRELATION_ID	A value that associates the row in the usage with a specific access request, automatic charge, or refund operation.
TENANT_ID	Your tenant identifier.
USAGE_TIME	The time that the usage occurred in Elastic Access.
WRITE_TIME	The time that the usage was written to the Data Warehouse.
CONSUMER_ID	The value field in the Requester object in the access request.
CONSUMER_TYPE	The type field in the Requester object in the access request.
ACCOUNT_ID	The ID of the customer account that the Elastic Access instance was set up for.
INSTANCE_ID	The ID of the Elastic Access instance that the access request was sent to.
ACTIVATION_ID	The ID of the line item that was charged or refunded to. If the access request failed (due to insufficient tokens or invalid items) then no line item will have been charged and this field will be blank.
MAPPED_ENTITLED_COUNT	The number of the entitled count in the line item that is mapped to the stated instance of Elastic Access. For Elastic Access line items, this is the entire quantity of the line item.
USED	The total number of tokens used from the line item as a result of all access requests successful issue to date.
ITEM	The subject of the access request, which is an item in a rate table that has been requested.
ITEM_VERSION	The version of the item requested, which is an optional field and so might be blank.
ITEM_QUANTITY	The count of items requested.
SESSION_ID	The UUID of the session that the access request was made in, which might be blank if the access request was a one-off request.
SESSION_STATE	The state of the session after the request or activity completed, which might be blank if the access request was a one-off request.
REQUEST_RESPONSE	The result of the access request, which can be 101 if it was successfully granted, or some other value if denied.
METER_TYPE	The type of monetization approach that this row is entered for, which will always be "elastic" for Elastic Access.
METER	The entity being counted, which for Elastic Access is always "elastic token".
METER_COST_LIST	The rate table used for this usage entry, which consists of a JSON object with the series and version of the rate table, such as {"series":"PublicationApps","version":1"}.
METER_COST	The charge for the item defined in the rate table.
METER_QUANTITY	The amount charged for the number of the item requested calculated by the METER_COST x ITEM_QUANTITY.
META_DATA	Extra information that the client can have sent in the access request, in the form of a valid JSON object using the metadata field in the access request.