Page History

...

1. Drag the Freehand SQL option.
   
   
   
   
2. Select the data source that you want to use.
   
   
   
   
3. Write the a SQL query to extract the required data.
   
   
   
   
4. Click You can click on the Validate option to check the validity of the SQL you provided. This ensures there are no errors in the codequery.
5. Click on the Submit button when you are sure your query is correct.
6. Click Then click on Apply in the Configure panel. The extracted data will appear in the data preview panel.
   
   
   
   
7. To change the freehand SQL query, click the Edit SQL option in the Configure panel.

...

Single Database Table

1. Drag the single table Single Table option onto the canvas.
   
   Image Added
   
   

2. On the appearance of the popup, select the database you want to use.
   
   
   
   

3. Then choose a table. And click on the Submit button. 
   
   

   
   Next
   

4. , click on the newly created input step in the canvas. Its details will appear in the configure flow The details of this step can be configured through the configure panel. 
   
   
   
   

5. Select only the fields that you want data to be extracted from. (You can unselect any unwanted fields.)

6. Click on the Add Filter button to apply filters to control the data being extracted through the Filter popup. 

7. Once you’re done with the configuration, click on the Apply button. 

8. On doing so, the data preview panel will display the data extracted from the configured data source. A maximum row setting of 200 applies.
   
   

   

...

Third-party Connectors

1. Drag the thirdThird-party table connector Table Connector option from the input step onto the canvas.
   
   
   
   
2. A list of all third-party data sources will appear. (Ensure you have already created a third-party data source. Learn how to do this here.)
   
   
   
   
3. Choose the data source that you want to use.
4. Then select the a table with from the chosen data you wish to usesource.
5. Finally, click Submit.
   
   
   
   
6. Next choose the fields that are to be extracted.
7. Note: If you’re extracting data from a Google Analytics table, you will need to provide the start and end date dates to filter your data.
8. Click on the Apply button. The extracted data will appear in the data preview panel.
   
   

...