Skip to main content

Create Dummy File

Should the Staging process copy a placeholder.dummy file to accommodate the PolyBase limitation when no files exist.

PolyBase fails when an external table points at a location that contains no files. When enabled, the generated AzCopy staging flow uploads a placeholder.dummy file to the object's folder in the stage container so the external table always has a file to read.

When to Change This Setting​

Enable this for PolyBase-based staging when a load can legitimately produce no extract files, for example sources that are frequently empty on incremental loads.

SettingInteraction
Create External On StageRecreates the external table over the staged files before the staging procedure runs
Stage ContainerThe container the placeholder file is uploaded to

Notes​

  • This setting is part of the Azure settings category.
  • The default value for this setting is N.