Connection management

Connection management#

Stored procedures for creating and managing connections (linked servers) to data sources.

Stored procedure name

Description

qua_add_external_ai_model

Registers an external generative AI model for the AI functions.

qua_drop_external_ai_model

Removes an external AI model registration; the provider-side model is untouched.

sp_addlinkedserver

Creates a connection to a data source. A connection allows for access to a single data source (endpoint).

sp_addlinkedsrvlogin

Creates or updates a mapping between a connection on the local instance of Querona and a security account on a remote data source.

sp_dropserver

Removes a connection from the list of known connections on the instance of Querona.

sp_linkedservers

Returns a list of connections (aka. linked servers) accessible by the current user.

sp_testlinkedserver

Tests the connection to a data source.

sp_updatelinkedserver

Updates a connection to a data source.