要获取AWS数据管道插入SQLActivity的状态，可以使用AWS SDK提供的相关方法。

以下是使用AWS SDK for Java的示例代码：

import com.amazonaws.services.datapipeline.DataPipelineClient;
import com.amazonaws.services.datapipeline.model.GetPipelineExecutionRequest;
import com.amazonaws.services.datapipeline.model.GetPipelineExecutionResult;
import com.amazonaws.services.datapipeline.model.PipelineObject;

public class DataPipelineStatusExample {

    public static void main(String[] args) {
        String pipelineId = "your-pipeline-id";
        String pipelineExecutionId = "your-pipeline-execution-id";

        DataPipelineClient dataPipelineClient = new DataPipelineClient();

        GetPipelineExecutionRequest getPipelineExecutionRequest = new GetPipelineExecutionRequest()
                .withPipelineId(pipelineId)
                .withPipelineExecutionId(pipelineExecutionId);

        GetPipelineExecutionResult getPipelineExecutionResult = dataPipelineClient.getPipelineExecution(getPipelineExecutionRequest);

        PipelineObject sqlActivity = getPipelineExecutionResult.getPipelineExecution().getPipelineObjects()
                .stream()
                .filter(pipelineObject -> pipelineObject.getId().equals("your-sql-activity-id"))
                .findFirst()
                .orElse(null);

        if (sqlActivity != null) {
            System.out.println("SQLActivity status: " + sqlActivity.getFields().get("status").getStringValue());
        } else {
            System.out.println("SQLActivity not found");
        }
    }
}

请将your-pipeline-id、your-pipeline-execution-id和your-sql-activity-id替换为正确的值。此示例代码将使用AWS SDK for Java中的DataPipelineClient类来获取数据管道执行的状态，并找到指定的SQLActivity对象来获取其状态值。

请确保已在您的Java项目中添加了AWS SDK for Java的依赖项。