Running DML Queries

After adding a database to the DbRunner application and creating a project for a schema of the database, you can now run DML queries. To do this, click the relevant project on the Project page and click the New Deploy button. A screen like the one below will appear.

From this page, you can directly upload the queries you want to run, write them using an online text editor, or complete the file upload by selecting one of the predefined scripts. Click the Save & Continue button to access the summary page.

You can find information about the queries to be run on the summary page. The "request number" field in the image below was added from the Fields tab in the project settings.

From this page, you can run queries immediately or schedule them to run at a specific time. If you have authorization, the queries will run; otherwise, the query will run only after approval by authorized individuals.

After running the query, you can view the results of the executed query by clicking the result link below the file. If you ran a select query, you can view the output in CSV, XLSX, or HTML format. It's important to note that each file must contain a single select query; otherwise, you'll only be able to access the output in log format.