Validate a sync task

Procedure

1. Log on to the Dataphin console.

2. On the Dataphin console page, select a region for your workspace and click Enter Dataphin>>.

3. On the Dataphin home page, click Develop.

4. Optional: On the Data Studio page, click the icon next to the project name and select a data development project (Dev or Basic).

   If you are already in a Dev or Basic project, you do not need to select a project.

5. On the Data Development page, click Ad Hoc Query.

6. Create an ad hoc query folder.

   1. On the Ad-hoc Query page, click the icon next to Ad-hoc Query

   2. In the Create Folder dialog box, enter a Name for the folder.

   3. Click OK to create the ad hoc query folder.

7. Create an ad hoc query file.

   1. On the Ad-hoc Query page, click the icon next to Ad-hoc Query

   2. On the Create File page, enter a Name and Description, and specify the Select Directory for the file.

   3. Click OK to create the ad hoc query file.

8. Write the code for the ad hoc query file.

   1. Execute the following SQL statement to check the result of the sync task.

      select * from target_table_name where ds='task_scheduling_date';

   2. After you write the code, click Precompile to check whether the SQL statement is valid.

      If the statement is invalid, click Format. The system automatically adjusts the format of your SQL statement.

   3. After the statement is validated, click Execute to view the execution result of the sync task.