VALIDATE CONNECTION
VALIDATE CONNECTION validates the connection and authentication parameters
provided in a CREATE CONNECTION statement against the target external
system.
Syntax
| Field | Use |
|---|---|
| connection_name | The identifier of the connection you want to validate. |
Description
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 CREATE SINK
statement. A successful connection and authentication attempt returns
successfully with no rows. If an issue is encountered, the command will return
a validation error.
Privileges
The privileges required to execute this statement are:
USAGEprivileges on the containing schema.USAGEprivileges on the connection.