When to use this transformation
Use SQL transformation to extract data from the relational databases or transform data by running a SQL on unstructured or semi-structured data sources, such as a file, a response from the API, a data feed from the social network, etc.
Create a transformation
When creating a source-destination transformation, enter a query into the Source query
field on the Mappings
tab.
Write SQL queries when working with relational databases
Use native SQL syntax of the source relational database. In addition to SELECT SQL
statements, you can execute stored procedures and functions as long as they return a cursor.
Write SQL queries when working with non-relational sources
Etlworks allows you to leverage SQL to query data from non-relational sources such as files (CSV, JSON, XML, Excel, Parquet, Avro and others) and API responses. This feature supports both flat and nested datasets, enabling powerful transformations, filtering, and aggregations using familiar SQL syntax.
Read about extracting data non-relational data sources using SQL.
Comments
0 comments
Please sign in to leave a comment.