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!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

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 ...