GROUPS

Group configuration records.

GROUPS contains the latest available group configuration records for the current SORACOM Query request context. Use it to inspect settings shared by SIMs and devices that belong to the same group.

The CONFIGURATION column contains service-specific settings such as SORACOM Beam, Harvest, Funk, and Funnel configuration.

Public Contract

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

Data Freshness

Updated daily.

Columns

Column	Type	Description
SNAPSHOT_DATE	DATE	Date of the group configuration snapshot.
GROUP_ID	TEXT	Group identifier.
CONFIGURATION	VARIANT	Group service configuration as JSON.
CREATED_AT	TIMESTAMP_NTZ	When the group was created.
LAST_MODIFIED_AT	TIMESTAMP_NTZ	When the group was last modified.

JSON / VARIANT Fields

CONFIGURATION is a JSON object whose fields vary by the services configured on the group. Top-level keys commonly correspond to SORACOM service names.

Common fields include:

Field	Type	Description
SoracomBeam	object	SORACOM Beam group settings.
SoracomHarvest	object	SORACOM Harvest group settings.
SoracomFunk	object	SORACOM Funk group settings.
SoracomFunnel	object	SORACOM Funnel group settings.

Example:

SELECT
  GROUP_ID,
  CONFIGURATION:SoracomBeam AS beam_configuration
FROM GROUPS
WHERE CONFIGURATION:SoracomBeam IS NOT NULL;

Common Queries

Count groups:

SELECT COUNT(*) AS group_count
FROM GROUPS;

Find groups with SORACOM Beam settings:

SELECT
  GROUP_ID,
  CONFIGURATION:SoracomBeam AS beam_configuration
FROM GROUPS
WHERE CONFIGURATION:SoracomBeam IS NOT NULL;

Recently modified groups:

SELECT
  GROUP_ID,
  LAST_MODIFIED_AT
FROM GROUPS
ORDER BY LAST_MODIFIED_AT DESC
LIMIT 100;