Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

CREATE LINK

Info

The SingleStore Managed Service does not support this command.

Create a new connection link to S3, Azure, GCS, HDFS, or Kafka for a permitted user.

Syntax

CREATE LINK [db_name.]connection_name AS
{ S3 | AZURE | GCS | HDFS | KAFKA }
CREDENTIALS 'credentials_json'
[ CONFIG 'configuration_json' ]
[ DESCRIPTION 'description' ]

Remarks

  • db_name is the name of the SingleStore DB database. It is an optional parameter. If not specified, the connection link is created in the current (context) database.
  • connection_name is the name of the connection link.
  • Only users with the CREATE LINK permission can create a connection link.
  • Commands such as BACKUP,RESTORE, CREATE PIPELINE, and SELECT support connection links. Refer to any command for details on the credentials_json and configuration_json clauses.
  • description specifies the details related to the connection link.

Example

The following example demonstrates how to create an S3 connection link product_S3 to the database Orderdb.

CREATE LINK Orderdb.product_S3 AS S3
CREDENTIALS '{"aws_access_key_id":"your_access_key_id","aws_secret_access_key":"your_secret_access_key"}'
CONFIG '{"region":"us-east-1"}'
DESCRIPTION 'Products ordered in December';