SQL as Query Mode – Technical Documentation

Overview

In addition to the traditional Table Selection mode, the platform now supports SQL as Query mode for selected source connectors. This feature enables users to directly input custom SQL queries for more flexible and precise data extraction.

This feature is available during the integration pipeline setup's Source Connector configuration step (Step 1).

Supported Connectors

• Azure SQL Server

• AWS SQL Server

• Oracle

• Snowflake

Modes of Data Extraction

1. Table Selection

Users select one table from the connected database to extract data.

2. Query Mode

Users can input a custom SQL SELECT query to fetch data. This is ideal for:

• Joining multiple tables

• Filtering rows with WHERE conditions

• Aggregating data using GROUP BY

• Implementing business logic via subqueries

On selecting Query, an SQL editor field appears where users can enter a valid SQL query.
Validation ensures only read-only queries are accepted (e.g., no INSERT, UPDATE, DELETE)