SQL queries are powerful by themselves, but, by automating queries as part of your data flow, you will unlock tons of potential in your data. In this post, we will show you how to automate your SQL queries for free, so that you can focus on the things that drive value for your business.
In this use case, we will explore using the SQL Runner engine to automate insert and update queries. There are a couple concepts related to this discussion, such as templating and pointers, that it helps to be familiar with. Read more about those in this blog post.
First, register for a Nom Nom Data account and follow the steps to install a Nominode. Using the Nominode is free and no credit card is required. Once you have set up a Nominode, you’re ready to get started with these steps.
Three easy steps:
- Create a Generic:Database Connection with the details about your database. This connection will be used as the target of your SQL query.
- Create a new Task and select SQL Runner from the list of engines
- Use the Alias field to name your Task
- Select Run SQL Script With Date Parameters in the Action Type field
- Use the Target Database Connection field to select the Database Connection that you created
- Add the SQL query that you want to automate to the SQL Script field. Usually, this will be an Insert or Update statement to maintain a dataset that is built from data collected over time.
- Provide User Defined Parameters, if you are using templating in your query
- Use the Next Run Start Point field to specify the date in your data to begin with
- Set amount of data that you want to process in the Process Increment field
- Click the Create button
- Create a new Sequence to run your Task on a regular basis
- Name your Sequence
- Enable your Sequence
- Specify whether your Task will run on a fixed schedule, defined with a CRON expression, or if the completion of another Task will trigger your Task to run
- Select the Task that you created
- Click the Save button
- You can test running your Task before it runs on the schedule by running the Sequence manually. And that’s it, you have successfully automated your SQL query for free.
For more details, use the ? icons next to the fields in the Task or visit our SQL Runner support page.