Creating SQL Pipelines

Prerequisites

Ensure that the SQL query is prepared beforehand.

Overview

Infoworks enables you to use SQL queries to build pipelines. This can be performed via SQL pipelines.

Infoworks provides an SQL editor to create an SQL pipeline, which is convenient for a user instead of preparing a visual pipeline. It allows you to enter the SQL query and build the pipeline for further use.

Providing SQL Query

To provide an SQL query:

Step 1: Navigate to Domains > Pipeline.

Step 2: Select the required pipeline.

Step 3: Click the SQL Pipeline and then click Open Editor.

Step 4: Provide the SQL queries.