Returns the AccessKey ID used to access the Object Storage Service (OSS) bucket where a trajectory object's data is stored. Returns null if the trajectory data is not stored in OSS.
Syntax
text ST_AKID(trajectory traj)Parameters
| Parameter | Description |
|---|---|
traj | The trajectory object. |
Usage notes
Trajectory data stored externally requires an AccessKey pair to access the OSS bucket. An AccessKey pair consists of an AccessKey ID and an AccessKey secret — the AccessKey ID identifies the caller (similar to a username) and the AccessKey secret authenticates the request (similar to a password).
Examples
Query the AccessKey ID for each trajectory in the trajs table:
SELECT ST_AKID(traj) FROM trajs;Expected output:
st_akid
--------------------------
$(OSS_USER)
$(OSS_USER)
$(OSS_USER)