Is it possible to set any data types to each column of data to be captured on Splunk and change the amount of license usage?

[yutaka1005]

In database, data size is affected by data types.

Also when inputs data from database by using DB_connect, I think Splunk is understanding data types(int,char,timedata...etc) of each column.
*This is because data types are displayed when selecting columns to be used as timestamps.

So when Splunk inputs data from database by using DB_connect, is license usage affected by data types?

Or since Splunk recognizes and inputs data as a character string, the data types not be related to license usage?

Also, if the former is correct, is it possible to set any data types to each column of data to be captured on Splunk and change the amount of license usage?

If someone knows about it and tells me, it would be greatly appreciated.

[xpac · Accepted solution]

DB Connect recognizes data types in the columns, however data in Splunk is always indexed as a string, therefore the original data type doesn't matter. The string "123" uses as much space/license as the integer 123.
Only when data is ingested into one of the new metrics indexes, it's saved as a numeric value, as metrics indexes only allow for numbers. The license usage on metrics indexes however is fixed on 150 bytes per event, therefore the stored data size doesn't matter for license usage.

Hope that helps - if it does I'd be happy if you would upvote/accept this answer, so others could profit from it. 🙂

[yutaka1005]

Thank you for answer!

It is very helpful!

By the way, the amount of license usage of metric data is 150 bytes per event.

http://docs.splunk.com/Documentation/Splunk/latest/Admin/HowSplunklicensingworks

[xpac]

Yeah, my brain is already asleep. Thanks, I updated my answer 🙂