PUT
The PUT
function addresses the need to transfer data files stored in a user’s local file system to the database’s internal staging area.
Syntax
PUT <'local-file-path'> INTO <'SQDB-cluster-relative-file-path'> [OVERWRITE];
Parameters
Parameter |
Description |
---|---|
|
Source File path - on the executing client machine. |
|
Destination File path - relative to the defined SQDB cluster staging area. |
|
When used existing files will be overridden. |
Important Considerations
File size may be up to 25MB.
The SQDB cluster staging area’s root path is configured using the
stagingAreaRootPath
flag. By default, this area is created within the definedstorageClusterPath
as a subdirectory named staging_area. Thisstaging_area
directory contains two subdirectories:content
, intended for user-uploaded data, andtemp
, reserved for internal system operations.The command is limited to a single file copy per execution.
File extensions are limited to supported FDWs.
The command execution is CPU based and does not use GPU Workers.
Up to 50 concurrent
PUT
/GET
/REMOVE
operation are supported per SQDB cluster.The feature is supported for the following drivers: PySQream, JDBC, ODBC
Permissions
The role must have the SUPERUSER
privilege.