Missing columns in staging table if the column does not exist in the sample size


Description

This is specific to the scenario where a column is not getting created in the staging table when it exists outside of the sampling size for an import. This applies to JSON/XML data sources.

Cause

The reason for the missing column is because the sample size for creating the columns in the staging table is by default 20.

Resolution

To be able to parse the data in the missing columns, you can add the columns manually as follows: