SQL DML (DI/ETL) Scripts
SQL DML Script files usually consist of multiple SQL statements and sometimes designed to be executed from outside the database, and therefore not necessarily compiled in the database. Such scripts are often handcrafted and sometimes generated or part of the database utilities (e.g. Teradata fastload, bulkload and multiload)
Parsing of independent SQL script files (.sql) is currently limited to the following database technologies:
- Apache Hadoop Hive Database (Cloudera, Hortonworks, MapR) SQL DML (DI/ETL) Script (HiveQL)
- Apache Sqoop
- IBM DB2 Universal Database (UDB) SQL DML (DI/ETL) Script
- Microsoft SQL Server Database SQL DML (DI/ETL) Script (Transact-SQL)
- Oracle Database SQL DML (DI/ETL) Script (PL/SQL)
- PostgreSQL Database SQL DML (DI/ETL) Script
- Teradata Database SQL DML (DI/ETL) Script (BTEQ, Fastload, etc.)