SQL

Use an IDE for testing SQL statements

Use an IDE like DataGrip to test your SQL statements prior to running them in Mitto SQL jobs.

Include the table schema in SQL statements

It is a good practice to fully qualify your tables by including the schema of the table.

For example if you want to mirror an entire table:

SELECT *
FROM <schema>.<table>;

SQL comments

Write comments in your SQL statements to document what they do.

Mitto only accepts multi-line comments due to job configurations being stored as JSON.

For example:

/* This is a comment. */
Select 1;