Which command-line utility can be used to perform data transformation in-database?
Which command-line utility can be used to perform data transformation in-database?
BTEQ, which stands for Basic Teradata Query, is a command-line utility used to interact with Teradata databases. It allows users to submit SQL queries and perform data transformation directly within the database. It is specifically designed to offer a powerful and flexible interface for executing SQL commands and scripts, making it the appropriate utility for performing in-database data transformations.
B. SQLA. SQLA (SQLAlchemy Command-Line Interface) is a command-line utility that provides a powerful and versatile interface for interacting with SQLAlchemy, a popular Python object-relational mapper (ORM) for relational databases. It allows users to perform a variety of data transformation tasks, including:
SQLA is SQL Assistant . As such, it is not a command-line interface.