Question

A data engineer creates a OneLake shortcut in a Fabric lakehouse that points to an external Amazon S3 bucket. Reports built on this data intermittently show outdated values even though the source files in S3 were updated hours ago. The engineer confirms the source data is correct and the shortcut path is valid. What is the most likely cause of the stale results?

Accepted Answer

OneLake shortcut caching is enabled, so previously retrieved files are served from cache until the cache retention period expires.

Answer

The shortcut authentication token has expired, preventing new data from being read.

Answer

The lakehouse SQL analytics endpoint requires a manual metadata sync before new shortcut files are visible in tables.

Answer

S3 cross-region replication is delaying propagation of the updated files to the shortcut.