All Products
Search
Document Center

PolarDB:ST_AKID

Last Updated:Aug 20, 2026

Returns the AccessKey ID of an externally stored trajectory.

Note

This function is expected to be deprecated in a later version. Use Cold data tiered storage for a better experience.

Syntax

text ST_AKID(trajectory traj);

Parameters

Parameter name

Description

traj

The trajectory object.

Description

If the trajectory is stored externally, this function returns the AccessKey ID used to store the trajectory. Otherwise, it returns null.

To read a trajectory from OSS external storage, you must provide an AccessKey pair. Each AccessKey pair consists of an AccessKey ID and an AccessKey secret, which can be understood as a username and a password.

Example

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