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!

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud  In today’s fast-paced digital ...

Observability protocols to know about

Observability protocols define the specifications or formats for collecting, encoding, transporting, and ...

Take Your Breath Away with Splunk Risk-Based Alerting (RBA)

WATCH NOW!The Splunk Guide to Risk-Based Alerting is here to empower your SOC like never before. Join Haylee ...