VALIDATE CONNECTION validates the connection and authentication parameters
provided in a
CREATE CONNECTION statement against the target external
|connection_name||The identifier of the connection you want to validate.|
Upon executing the
VALIDATE CONNECTION command, Materialize initiates a
connection to the target external system and attempts to authenticate in the
same way as if the connection were used in a
CREATE SOURCE or
statement. A successful connection and authentication attempt returns
successfully with no rows. If an issue is encountered, the command will return
a validation error.
The privileges required to execute this statement are:
USAGEprivileges on the containing schema.
USAGEprivileges on the connection.