ST_AKID - PolarDB - Alibaba Cloud Documentation Center

You can use this function to query the AccessKey ID that is used to access the Object Storage Service (OSS) bucket in which the data of a trajectory object is stored.

Syntax

text ST_AKID(trajectory traj);

Parameters


Parameter	Description
traj	The trajectory object.

Description

If the data of a specified trajectory is stored in an OSS bucket, this function returns the AccessKey ID that is used to access the bucket. Otherwise, this function returns null.

When you read trajectory data from a file in an OSS bucket, you must provide the AccessKey pair information to access the OSS bucket. An AccessKey pair consists of an AccessKey ID and an AccessKey secret. An AccessKey ID is similar to a username and an AccessKey secret is similar to a password.

Examples

select ST_AKID(traj) from trajs;
         st_akid          
--------------------------
 $(OSS_USER)
 $(OSS_USER)
 $(OSS_USER)