Error when trying to guess schema: /temp/TempGuessSchemaDelimitedFile.csv (No Such File or directory)


Components such as tPostgreSQLInput, tSQLiteInput, tMSSQLInput all have the option/button for Guess Schema and Guess Query.

When selected, these options generate a temporary TempGuessSchemaDelimitedFile.csv file to a top level /temp directory.


When trying to guess schema, the following error is given: /temp/TempGuessSchemaDelimitedFile.csv (No Such File or directory)


Screen Shot 2017-10-25 at 3.19.27 PM.png



This error can be caused if the temp folder is not created in the root of the system.

The problem is that on macOS, the option for Guess Schema is attempting to write the top level /temp/ folder, and it can't do it due to lacking permissions to create the folder.



To resolve this issue:

  1. From the Go menu in the Finder, select Go to Folder.
  2. Enter / for the path.
  3. If prompted for the Admin password, enter it to authenticate.
  4. Create a folder called temp (it will ask to authenticate again).
  5. Now try using the Guess Schema option, and it should work as expected.
Version history
Revision #:
5 of 5
Last update:
‎09-29-2018 12:18 AM
Updated by:
Labels (3)