This method is used to import data from a database using an SQL query.
Step Configuration
Follow the guidelines below to configure a freehand SQL step:
- Click on the Input Steps button on the left side of the Transformation Flow builder, to view a panel will all the input steps.
- Drag the Freehand SQL option.
- Select the data source that you want to use.
- Write a SQL query to extract the required data.
- You can click on the Validate option to check the validity of the SQL you provided. This ensures there are no errors in the query.
- Click on the Submit button when you are sure your query is correct.
- Then click on Apply in the Configure panel. The extracted data will appear in the data preview panel.
- You can also change the SQL query by clicking on the Edit SQL option in the Configure panel.