All Apps and Add-ons

ERROR-LIMIT-MAX-ROWS-DBCONNECT

amelbahrouni
Explorer

Hello,
The question is about DB-Connect, actually I’m already connected to a DB-Connect (Version 3.1.4) ) but when I’am fetching on that SQL DB using SQL query on SPLUNK , this search displays only results 100000 rows ( the limit for DB Connect to display results ) .But, my search normally displays more than 100000 rows. Cause, I need that result to make a mathematical operation ! How can I obtain all the rows of my DB Table !! The table on this DB is composed by data.
Thanks in advance and cooperation

0 Karma

wmyersas
Builder

Are you hitting the row limitation in the DB COnnect preview screen?

Or when running searches against the data after you import?

I've imported DB tables with upwards of 500,000 entries, no problems (other than it takes a while to complete, of course)

And I've done "nothing special" - just run the query, and let it import

0 Karma

amelbahrouni
Explorer

Hello , Sorry i did a mistake so i delete all my previous questions ,so at first thanks for your response ! so my DB Table contain 23935964 rows , For your question , yes Both !! DB COnnect preview screen and when i run the search ! (Just in SQL server i obtain all the rows that i need to make my operation ) !!
Please can you tell me how you did that ! i mean how did you import all the data that you need !! ( with your DB table 500.000) !!
Thanks in advance .

0 Karma

wmyersas
Builder

I don't really know what to say here: regardless of how many rows I've imported (and it's been as many a million plus), it's Just Worked™

0 Karma

amelbahrouni
Explorer

Hello Again , at first thanks for your response , very good !! you did that with a millions rows ! can you tell me about how you did that please ! i count on you to help me !
Thanks in advance .

0 Karma

wmyersas
Builder

Please reread my last comment: I didn't "do" anything - running the dbconnect Just Worked™

0 Karma
Get Updates on the Splunk Community!

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...

Splunkbase | Splunk Dashboard Examples App for SimpleXML End of Life

The Splunk Dashboard Examples App for SimpleXML will reach end of support on Dec 19, 2024, after which no new ...

Understanding Generative AI Techniques and Their Application in Cybersecurity

Watch On-Demand Artificial intelligence is the talk of the town nowadays, with industries of all kinds ...