Can DB Connect Run Multiple Queries At Once?

[proitllc]

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?

[dwaddle]

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.

[jcoates_splunk]

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

[BP9906]

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

[lukejadamec]

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.

[jcoates_splunk]

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.