Connections

The connections system table includes information about the source and target data connections used by your organization.

From a worksheet within Upsolver, run the following query:

SELECT * 
FROM system.information_schema.connections;

The system.information_schema.connections table includes the following columns:

ColumnTypeDescription

comment

string

An optional comment to describe the connection.

created_at

datetime

The date and time when the connection was created.

created_by

string

The name of the user who created the connection.

id

string

The unique identifier for the connection.

modified_at

datetime

The date and time when the connection was modified.

modified_by

string

The name of the user who modified the connection.

name

string

The name of the connection.

For more information, please refer to the Connections SQL command reference.

Last updated