VALIDATE CONNECTION

VALIDATE CONNECTION validates the connection and authentication parameters provided in a CREATE CONNECTION statement against the target external system.

Syntax

VALIDATE CONNECTION connection_name
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:

  • USAGE privileges on the containing schema.
  • USAGE privileges on the connection.
Back to top ↑