onboarded teradata data in splunk via splunk db connect having empty columns

[splunker67899]

Hi ,
I have onboarded teradata data in splunk via splunk db connect. Since they have some columns as empty when we ingest in splunk only columns with data are being returning and empty columns are not onboarded and Some empty columns are having data in some rows  any suggestions please ? 

[richgalloway]

Suggestions for what?  What you describe sounds like normal behavior.  What results are you expecting?

[splunker67899]

Hi @richgalloway  ,

Terdata customer is expecting that data with empty columns should be also onboarded into splunk and some of the columns having data in some rows and some rows are empty shall also be onboarded into splunk ?  

[richgalloway]

DB Connect can't onboard what isn't in the database.  Modify the SQL query to ensure each column has a value or use Splunk's fillnull command.