Use the SQL connector to write, save, and automate SQL queries to any database Mitto has connectivity to.
The queries need to be written in the syntax of the database they are being sent to.
Standard use cases include creating tables, views, and stored procedures.
Mitto does not validate SQL queries when creating a job. Best practice is to write your SQL queries in another tool (ie Datagrip) to test the SQL, and then when you are ready to save and automate the SQL, drop it into a Mitto job.
Instructions for creating a SQL job in Mitto:
Choose the SQL connector:
Simply type the SQL into the "Enter Statement" window.
Then specify the
Title of the job and the
Type of database you are sending the query to.
Standard practice for a SQL job
- Local Database - the internal Mitto PostgreSQL database
- Custom - specify the connection string of the destination database.
Example SQL job:
Title: [SQL] public.test
Type: Local Database
Note: Mitto only accepts multi-line comments.
DON'T do this: