SIM_PEERS

SIM traffic peer summary records with FQDN and IP peer lists.

SIM_PEERS summarizes traffic peers observed for SIM activity. Use it to find frequently contacted domains or IP addresses and to compare peer activity by SIM.

Public Contract

• Rows are limited to the current SORACOM Query request context.

Data Freshness

Updated multiple times per day.

Columns

Column	Type	Description
VERSION	TEXT	Record version.
IMSI	TEXT	IMSI used by the SIM.
OPERATOR_ID	TEXT	Operator identifier associated with the row.
SIM_ID	TEXT	SIM identifier.
CREATED_TIME	TIMESTAMP_NTZ	Record creation time.
UE_IP_ADDRESS	TEXT	User equipment IP address.
UPLINK_PKTS	NUMBER	Total packets uploaded.
UPLINK_BYTES	NUMBER	Total bytes uploaded.
DOWNLINK_PKTS	NUMBER	Total packets downloaded.
DOWNLINK_BYTES	NUMBER	Total bytes downloaded.
LAST_ACTIVE_TIME	TIMESTAMP_NTZ	Last activity time.
VPG_ID	TEXT	VPG identifier associated with the traffic when available.
TIMESTAMP	TIMESTAMP_NTZ	When the peer summary was recorded.
FQDN_PEERS	ARRAY	Domain-name peers observed for the SIM.
IP_PEERS	ARRAY	IP address peers observed for the SIM.

JSON / VARIANT Fields

FQDN_PEERS and IP_PEERS are arrays. Flatten them when you need one row per peer value.

Example:

SELECT
  SIM_ID,
  fqdn.value::STRING AS fqdn_peer
FROM SIM_PEERS,
  LATERAL FLATTEN(INPUT => FQDN_PEERS) fqdn;

Common Queries

Top SIMs by peer traffic:

SELECT
  SIM_ID,
  IMSI,
  SUM(DOWNLINK_BYTES + UPLINK_BYTES) AS total_bytes
FROM SIM_PEERS
GROUP BY SIM_ID, IMSI
ORDER BY total_bytes DESC
LIMIT 100;

Most common domain peers:

SELECT
  fqdn.value::STRING AS fqdn_peer,
  COUNT(*) AS records
FROM SIM_PEERS,
  LATERAL FLATTEN(INPUT => FQDN_PEERS) fqdn
GROUP BY fqdn_peer
ORDER BY records DESC
LIMIT 100;