Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Missing Columns & NULL Values

If you've noticed some missing columns or data from your data warehouse, the root cause may be NULL values.

When Stitch replicates your data, it uses the column's data type to determine how to correctly store the data in your data warehouse. If a column only contains NULLs Stitch won't be able to infer the correct data type or store the data properly.

In short: when a column only contains NULLs, it won't display inside Stitch or be replicated to your data warehouse.

Next Steps

If you notice some missing columns, we recommend checking to see if they contain only NULLs. If this is the case, should that column at any point contain non-NULL values in the future, the column will immediately be created in your data warehouse and populated with the non-NULL values.

If you check the columns and find they contain values that are non-null, please reach out to support.

RELATED

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!