All Products
Search
Document Center

PolarDB:ST_AKID

Last Updated:Mar 28, 2026

Queries the AccessKey ID used to access the Object Storage Service (OSS) bucket where a trajectory object's data is stored.

Note This function is not supported in later versions. Use Cold data tiered storage instead.

Syntax

text ST_AKID(trajectory traj);

Parameters

ParameterDescription

traj

The trajectory object.

Description

If the trajectory data is stored in an OSS bucket, this function returns the AccessKey ID used to access that bucket. If the trajectory data is not stored in OSS, it returns null.

To read trajectory data from an OSS bucket, provide an AccessKey pair. An AccessKey pair consists of an AccessKey ID and an AccessKey secret. The AccessKey ID identifies the account, similar to a username, and the AccessKey secret authenticates the request, similar to a password.

Examples

SELECT ST_AKID(traj) FROM trajs;
         st_akid          
--------------------------
 $(OSS_USER)
 $(OSS_USER)
 $(OSS_USER)