topic Re: Can DB Connect Run Multiple Queries At Once? in Splunk Search

Can DB Connect Run Multiple Queries At Once?

proitllc — Sun, 23 Jun 2013 18:06:18 GMT

I'm trying to run a few complex queries in order to render a single output using DB Connect.

I cannot seem to get them all to run together on one line as if I were at the mysql console.

Query Example (won't go into detail, just the basic structure):

DROP....DROP....DROP....SELECT ... FROM ... WHERE... GROUP...;
CREATE TEMPORARY TABLE.....;
INSERT INTO... SELECT... INNER JOIN... LEFT JOIN...;
INSERT INTO... SELECT... INNER JOIN... LEFT JOIN...;
INSERT INTO... SELECT... INNER JOIN... LEFT JOIN...;
CREATE TEMPORARY TABLE.....;
DROP TABLE...;
DROP TABLE...;
SELECT....;

So we have 9 statements here, the total number and the structure of each doesn't really matter because they work just fine individually, just not together as one big query. They produce the desired output in the mysql console and through several other methods.

Can Splunk DB Connect execute multiple queries as one?

Re: Can DB Connect Run Multiple Queries At Once?

lukejadamec — Wed, 31 Jul 2013 20:58:31 GMT

Have you tried creating the query at the database and naming it, and then querying the name from DB Connect?

I know it is an extra step, but that is how we worked around it.

Re: Can DB Connect Run Multiple Queries At Once?

BP9906 — Tue, 10 Dec 2013 03:03:47 GMT

Im going to try it with the map command. You can probably use an inputlookup with map command to accomplish what you want.

Re: Can DB Connect Run Multiple Queries At Once?

jcoates_splunk — Mon, 27 Jan 2014 22:53:47 GMT

that's my advice as well -- something really long and complex should be written with native syntax highlighting and without worrying about escaping special characters.

Re: Can DB Connect Run Multiple Queries At Once?

dwaddle — Tue, 28 Jan 2014 01:18:46 GMT

This looks like a good job for a stored procedure to me. That is, of course, if DB connect can call a stored procedure. Let the procedure encapsulate the logic above.

Re: Can DB Connect Run Multiple Queries At Once?

jcoates_splunk — Mon, 28 Sep 2020 15:44:07 GMT

it can run stored procedures if you can call them from SQL. IOW, dbquery my_database "execute my_stored_procedure" works.