troubleshooting

What could be causing NULL values in mixed-case columns in a source definition?

Malthe Borch shared a source definition where mixed-case columns were used with double-quoting but still resulted in NULL values. The issue was related to bracket wrapping. What could be causing NULL values in mixed-case columns in a source definition?

Ma

Malthe Borch

Asked on Dec 08, 2022

  • Using mixed-case column names without double-quoting in the source definition
  • Forgetting to wrap the data in [{ ... }] brackets
  • Incorrectly specifying the data format or structure in the source definition
Dec 12, 2022Edited by