Getting Data In

Need to change the table with timestamp to unix epoch time for RISING column in DB Connect

jugalkinariwala
Explorer

I need to ingest the data from DB to Splunk via DBCONNECT.

Need to choose a column for a RISING column which has a data and time field in it with below format :

starttime=2020-06-16 01:26:35.595026665

How shall I convert the above time format at the query level so that it is used for checkpoint as a primary key to use it as a RISING Column .

Labels (1)
0 Karma

jugalkinariwala
Explorer

If the table generates 1000 rows every 10mins

 

And if I am using Batch mode 

 

So shall I opt for DESC or ASC to retrieve the last rows that are generated from the table ?

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...