CREATE FILE

You can execute the CREATE FILE statement to create a file. After a file is created, the file is uploaded and persisted in CelerData. In a database, only an admin user can create and delete files, and all users who have permission to access the database can use the files that belong to the database.

Basic concepts

File: refers to the file that is created and saved in CelerData. After a file is created and stored in CelerData, CelerData assigns a unique ID to the file. You can find a file based on the database name, catalog, and file name.

Syntax

CREATE FILE "file_name" [IN database]
[properties]

Parameters

Configuration items of properties

Examples

• Create a file named test.pem under the category named kafka.

CREATE FILE "test.pem"
PROPERTIES
(
    "url" = "https://starrocks-public.oss-cn-xxxx.aliyuncs.com/key/test.pem",
    "catalog" = "kafka"
);

• Create a file named client.key under the category named my_catelog.

CREATE FILE "client.key"
IN my_database
PROPERTIES
(
    "url" = "http://test.bj.bcebos.com/kafka-key/client.key",
    "catalog" = "my_catalog",
    "md5" = "b5bb901bf10f99205b39a46ac3557dd9"
);