sshfs

INSTALL sshfs FROM community;
LOAD sshfs;

-- Install & load the extension
INSTALL sshfs FROM community;
LOAD sshfs;

-- Authenticate with SSH key file
CREATE SECRET my_hetzner_storagebox (
    TYPE SSH,
    USERNAME 'user',
    KEY_PATH '/Users/' || getenv('USER') || '/.ssh/storagebox_key',
    PORT 23
    SCOPE 'sshfs://u123456.your-storagebox.de'
);

-- or with password
CREATE SECRET my_server (
  TYPE SSH,
  USERNAME 'user',
  PASSWORD 'password',
  SCOPE 'sshfs://your-server.example.com'
);

-- Write data to remote server
COPY (SELECT * FROM large_table)
TO 'sshfs://your-server.example.com/data.parquet';

-- Read The uploaded parquet file using WebDAV
SELECT * FROM 'sshfs://your-server.example.com/data.parquet';