The SQLAudit table includes the following columns.

Name Type Description
ID Long An auto-increment, primary key column
SessionID Char(16) A unique Hybrid Data Pipeline connection identifier
SQLStatement VarChar(2000) The SQL statement executed against the data store
TimestampBegin Long A standard Java UTC epoch in milliseconds that indicates the time at which the SQL statement was made
TimestampEnd Long A standard Java UTC epoch in milliseconds that indicates the time at which the SQL statement ended
RowsFetched Long The number of rows that were returned
RowsUpdated Long The number of rows that were deleted, inserted, or updated
UserName VarChar(128) The internal authUserName associated with the authentication service. When using internal authentication, the UserName is the same as the LoginName. When using external authentication, these values may be different. See Authentication for details.
LoginName VarChar(250) The name supplied by the user when logging into Hybrid Data Pipeline
DatasourceName VarChar(128) The name of the Hybrid Data Pipeline data source
RemoteAddress VarChar(128) The IP address of the user
Status Integer The success or failure status of the query. 0 indicates failure. 1 indicates success.