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.
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. |