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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

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

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...