The Slate SFTP Explorer is a browser-based client for interacting with the SFTP server attached to your Slate instance. The SFTP explorer can be used to perform certain operations supported by external clients such as WinSCP or FileZilla directly in the Slate web application, including:

• creating, renaming, and deleting SFTP folders

• uploading, downloading, and deleting files stored in SFTP folders

Permissions and considerations

To access SFTP Explorer, the user must have the SFTP User Access role.

By default, a Slate SFTP server contains two folders: incoming and outgoing. Exported queries are stored in the outgoing folder.

📝 In test environments, you won’t see the incoming folder until Slate picks up at least one file for import.

Limiting access to particular SFTP file paths

The SFTP Explorer is path-restriction aware. Add path restrictions to a user’s SFTP Access settings In Database → User Permissions → Select a user → Roles.

📖 Further reading: Path restriction

File viewing limit

​By default, the SFTP Explorer will show up to 500 files within a given directory, and while it is not possible to change this setting, the 500 file limit only applies to what is shown on the screen: you can search a directory that contains more than 500 files, but you will only see up to 500 matching results.

File expiration

The Slate SFTP server does not delete files when you hit a certain number of files. Instead, files older than 30 days may be removed from the SFTP servers at any time, as the SFTP servers are intended for file delivery only and not for permanent data storage.

Using the SFTP Explorer

Creating a folder

To create an SFTP folder in SFTP Explorer:

1. Go to Database → SFTP Explorer.

2. Select New Folder.

3. Enter a name, like folder1.

4. Select Create.

Renaming or deleting a folder

1. Go to Database → SFTP Explorer.

2. Hover over a folder and select the pencil icon:

   

3. Enter a new name.

4. Select Save.

   

5. To delete the folder, select Delete.
   

Uploading a file

To upload a file to the SFTP server:

1. Go to Database → SFTP Explorer.

2. Navigate to a folder.

3. Select Upload.
   

4. Select Add Files.
   

5. Use your file browser to select a file.

6. Select Upload.
   

Using a third-party client

Third-party SFTP clients such as WinSCP or FileZilla can be also used to perform the operations supported by the SFTP Explorer.

See SFTP Connection Validation to connect to your Slate SFTP instance and the documentation for your third-party client.