All Apps and Add-ons

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

splunker67899
Engager

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 ? 

 

Labels (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

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

---
If this reply helps you, an upvote would be appreciated.
0 Karma

splunker67899
Engager

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 ?  

 

0 Karma

richgalloway
SplunkTrust
SplunkTrust

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.

---
If this reply helps you, an upvote would be appreciated.
*NEW* Splunk Love Promo!
Snag a $25 Visa Gift Card for Giving Your Review!

It's another Splunk Love Special! For a limited time, you can review one of our select Splunk products through Gartner Peer Insights and receive a $25 Visa gift card!

Review:





Or Learn More in Our Blog >>