The connector models the data in SFTP as a list of tables in a relational database that can be queried using standard SQL statements.

The depth of folders to list can be controlled by the TableDepth connection property. By default it is 1, so only directories directly in the Root will be listed.

Files may also be retrieved and listed recursively, although only from the Root table. Use the FileRetrievalDepth connection property to control this behavior.

Inserts, updates, and deletes are supported directly from tables. Inserts of files can be accomplished with the LocalFile pseudo column. An example of each of the operations is shown below:

INSERT INTO Root (IsDirectory, LocalFile) VALUES (false, 'C:\\testfolder\\myfile.txt')
INSERT INTO Root (IsDirectory, FileName) VALUES (true, 'MyFolder')
UPDATE Root SET FileName='NewName.txt' WHERE FilePath='/home/test/CDataFTPTest/myfile.txt'
UPDATE Root SET FileName='NewFolder' WHERE FilePath='/home/test/CDataFTPTest/MyFolder' AND IsDirectory=true
DELETE FROM Root WHERE FilePath='/home/test/CDataFTPTest/myfile.txt'
DELETE FROM Root WHERE FilePath='MyFolder' AND IsDirectory=true

CData Tableau Connector for SFTP Tables