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, Karma 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, Karma would be appreciated.
Get Updates on the Splunk Community!

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...