SFTP Operation failed for host [host] failed on error: Net::SFTP::StatusException (2, "no such file")

Knowledge Drop

Last tested: Mar 31, 2020
 

A common point of confusion in SFTP deliveries is that the path you give to Looker always has to be the fully qualified path from the root directory, while some other SFTP tools don’t have that requirement. SFTP servers are sometimes configured to drop users in the home directory rather than root. So if you input a path relative to root, and it's not in the root directory itself, it will reference a root folder that doesn't exist.

We can figure out the full SFTP path relative to root by using the PWD command.

Also, check for a / in the name of the Look or Dashboard.

This can also occur if there is a file that already exists in the SFTP server that has the same name as the delivery path. This creates an invalid path to write to that location. Removing this file should resolve the issue.

This content is subject to limited support.                

Version history
Last update:
‎05-25-2021 08:49 PM
Updated by: