Skip to content

OneLake path syntax

The Microsoft OneLake Connector node accepts paths in UNIX-like format. This page describes the rules for specifying paths.

Format rules

  • Use forward slashes (/) as separators.
  • Do not use drive letters (such as C:).
  • All path components are case-sensitive: Data.csv and data.csv are treated as different files.

Absolute paths

Absolute paths begin with a leading slash (/) and define the full location from the root of the file system.

text
/example.Lakehouse/Files/MyFolder/file.csv
/example.Warehouse/Files/myfolder/

Relative paths

Relative paths are resolved from the current working directory.

text
Files/MyFolder/file.csv
Files/myfolder/

For a general overview of absolute and relative paths in KNIME, see Path syntax in the KNIME File Handling Guide.

Folder restrictions

Not all operations are permitted in all folders. The Tables folder contains Delta Lake files managed by Fabric and must not be modified directly. Write operations are generally only allowed in the Files folder, depending on the data store type.

See Work with Microsoft OneLake for details on the error triggered by unsupported write operations.