📄️ 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 StarRocks. 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.
📄️ DROP FILE
Use the DROP FILE statement to delete a file. When you use this statement to delete a file, the file is deleted both in frontend (FE) memory and in Berkeley DB Java Edition (BDBJE).
📄️ SHOW FILE
You can execute the SHOW FILE statement to view the information about a file stored in a database.