Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
SHOW CREATE LINK
On this page
Shows the CREATE LINK
command used to create a link.
Syntax
SHOW CREATE LINK <link_name>
Argument
link_
: Name of the link.
Remarks
-
The
SHOW CREATE LINK
command does not support links to theHTTP
sources (CREATE LINK .
).. . AS HTTP -
Password and other sensitive information is masked in the
SHOW CREATE LINK
output. -
Refer to Permissions Matrix for the permissions required to run this command.
Example
The following example shows that sensitive information is hidden from the output:
CREATE LINK pLink AS MYSQLCONFIG '{"database.hostname": "svchost","database.exclude.list": "dbTest","database.port": 3306,"database.ssl.mode":"required"}'CREDENTIALS '{"database.password": "pa55w0rd","database.user": "s2user"}';SHOW CREATE LINK pLink \G
Link Name: pLink
Create Link: CREATE LINK `pLink` AS MYSQL
CONFIG "{\n \"database.hostname\": \"svchost\", \n
\"database.exclude.list\": \"dbTest\", \n
\"database.port\": 3306, \n
\"database.ssl.mode\":\"required\"}"
CREDENTIALS <CREDENTIALS REDACTED>
The output is formatted for readability.
Last modified: June 5, 2025