bteqExport

Last updated: June 9, 2026

Writes query results to a file on the BTEQ execution host. Generates the complete sequence of BTEQ dot-commands (.SET WIDTH, .SET SEPARATOR, .EXPORT, the SELECT query, and .EXPORT RESET) so you do not need to hand-write these commands in a <sql> block.

This is useful for data validation, ETL staging, and audit extracts. The change type guarantees that .EXPORT RESET is always emitted after the query, preventing accidental corruption of subsequent output.

Note: This change type does not support automatic rollback.

Available attributes

Attribute	Type	Required	Description
`file`	String	Yes	Absolute path to the output file on the BTEQ execution host. Must not contain newline characters.
`query`	String	Yes	SELECT statement to execute and export. Must start with `SELECT` and must not contain `.EXPORT` commands.
`format`	String	No	Export format. Accepted values: `REPORT` (human-readable) or `DATA` (binary). Default: `REPORT`.
`width`	Integer	No	Maximum line width for REPORT mode. Accepted range: 1 to 1048575. Default: `80`.
`separator`	String	No	Field delimiter character for REPORT mode.
`titleDashes`	Boolean	No	Show dashes under column headers. `true` = ON, `false` = OFF.
`nullValue`	String	No	Display string for NULL values.

Example code

Be sure to replace your_table, your_author, and the file paths with your actual values.

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:pro-teradata="http://www.liquibase.org/xml/ns/pro-teradata"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-teradata
        http://www.liquibase.org/xml/ns/pro-teradata/liquibase-pro-teradata-latest.xsd">

    <!-- Setup: create and populate a table to export -->
    <changeSet id="export-setup" author="your_author">
        <preConditions onFail="MARK_RAN">
            <not><tableExists tableName="your_table"/></not>
        </preConditions>
        <createTable tableName="your_table">
            <column name="product_id" type="int">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="product_name" type="varchar(50)">
                <constraints nullable="false"/>
            </column>
            <column name="price" type="decimal(10,2)"/>
            <column name="category" type="varchar(30)"/>
        </createTable>
        <sql>
            INSERT INTO your_table VALUES (1, 'Laptop Pro', 1299.99, 'Electronics');
            INSERT INTO your_table VALUES (2, 'Desk Chair', 449.50, 'Furniture');
            INSERT INTO your_table VALUES (3, 'USB Cable', 9.99, 'Electronics');
        </sql>
    </changeSet>

    <!-- Export as CSV with REPORT format -->
    <changeSet id="export-csv-report" author="your_author" runWith="bteq">
        <pro-teradata:bteqExport file="/tmp/your_export.csv"
                        format="REPORT"
                        separator=","
                        width="2000"
                        titleDashes="false"
                        query="SELECT product_id, product_name, price, category FROM your_table ORDER BY product_id"/>
    </changeSet>

    <!-- Export with DATA format -->
    <changeSet id="export-data-format" author="your_author" runWith="bteq">
        <pro-teradata:bteqExport file="/tmp/your_export.dat"
                        format="DATA"
                        query="SELECT product_id, product_name FROM your_table WHERE category = 'Electronics' ORDER BY product_id"/>
    </changeSet>

    <!-- Export with default settings (REPORT, width=80) -->
    <changeSet id="export-defaults" author="your_author" runWith="bteq">
        <pro-teradata:bteqExport file="/tmp/your_summary.txt"
                        query="SELECT category, COUNT(*) AS cnt, SUM(price) AS total FROM your_table GROUP BY category ORDER BY category"/>
    </changeSet>

    <!-- Export with NULL value handling -->
    <changeSet id="export-null-handling" author="your_author" runWith="bteq">
        <pro-teradata:bteqExport file="/tmp/your_export_nulls.csv"
                        format="REPORT"
                        separator="|"
                        width="1000"
                        nullValue="N/A"
                        query="SELECT product_id, product_name, price FROM your_table ORDER BY product_id"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "export-csv-report",
        "author": "your_author",
        "runWith": "bteq",
        "changes": [
          {
            "bteqExport": {
              "file": "/tmp/your_export.csv",
              "format": "REPORT",
              "separator": ",",
              "width": "2000",
              "titleDashes": "false",
              "query": "SELECT product_id, product_name, price, category FROM your_table ORDER BY product_id"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "export-data-format",
        "author": "your_author",
        "runWith": "bteq",
        "changes": [
          {
            "bteqExport": {
              "file": "/tmp/your_export.dat",
              "format": "DATA",
              "query": "SELECT product_id, product_name FROM your_table WHERE category = 'Electronics' ORDER BY product_id"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Export as CSV with REPORT format
  - changeSet:
      id: export-csv-report
      author: your_author
      runWith: bteq
      changes:
        - bteqExport:
            file: /tmp/your_export.csv
            format: REPORT
            separator: ","
            width: "2000"
            titleDashes: "false"
            query: "SELECT product_id, product_name, price, category FROM your_table ORDER BY product_id"

  # Export with DATA format
  - changeSet:
      id: export-data-format
      author: your_author
      runWith: bteq
      changes:
        - bteqExport:
            file: /tmp/your_export.dat
            format: DATA
            query: "SELECT product_id, product_name FROM your_table WHERE category = 'Electronics' ORDER BY product_id"

.SET WIDTH 2000
.SET SEPARATOR ','
.SET TITLEDASHES OFF
.EXPORT REPORT FILE=/tmp/your_export.csv
SELECT product_id, product_name, price, category FROM your_table ORDER BY product_id;
.EXPORT RESET

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:pro-teradata="http://www.liquibase.org/xml/ns/pro-teradata"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-teradata
        http://www.liquibase.org/xml/ns/pro-teradata/liquibase-pro-teradata-latest.xsd">

    <!-- Setup: create and populate a table to export -->
    <changeSet id="export-setup" author="your_author">
        <preConditions onFail="MARK_RAN">
            <not><tableExists tableName="your_table"/></not>
        </preConditions>
        <createTable tableName="your_table">
            <column name="product_id" type="int">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="product_name" type="varchar(50)">
                <constraints nullable="false"/>
            </column>
            <column name="price" type="decimal(10,2)"/>
            <column name="category" type="varchar(30)"/>
        </createTable>
        <sql>
            INSERT INTO your_table VALUES (1, 'Laptop Pro', 1299.99, 'Electronics');
            INSERT INTO your_table VALUES (2, 'Desk Chair', 449.50, 'Furniture');
            INSERT INTO your_table VALUES (3, 'USB Cable', 9.99, 'Electronics');
        </sql>
    </changeSet>

    <!-- Export as CSV with REPORT format -->
    <changeSet id="export-csv-report" author="your_author" runWith="bteq">
        <pro-teradata:bteqExport file="/tmp/your_export.csv"
                        format="REPORT"
                        separator=","
                        width="2000"
                        titleDashes="false"
                        query="SELECT product_id, product_name, price, category FROM your_table ORDER BY product_id"/>
    </changeSet>

    <!-- Export with DATA format -->
    <changeSet id="export-data-format" author="your_author" runWith="bteq">
        <pro-teradata:bteqExport file="/tmp/your_export.dat"
                        format="DATA"
                        query="SELECT product_id, product_name FROM your_table WHERE category = 'Electronics' ORDER BY product_id"/>
    </changeSet>

    <!-- Export with default settings (REPORT, width=80) -->
    <changeSet id="export-defaults" author="your_author" runWith="bteq">
        <pro-teradata:bteqExport file="/tmp/your_summary.txt"
                        query="SELECT category, COUNT(*) AS cnt, SUM(price) AS total FROM your_table GROUP BY category ORDER BY category"/>
    </changeSet>

    <!-- Export with NULL value handling -->
    <changeSet id="export-null-handling" author="your_author" runWith="bteq">
        <pro-teradata:bteqExport file="/tmp/your_export_nulls.csv"
                        format="REPORT"
                        separator="|"
                        width="1000"
                        nullValue="N/A"
                        query="SELECT product_id, product_name, price FROM your_table ORDER BY product_id"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "export-csv-report",
        "author": "your_author",
        "runWith": "bteq",
        "changes": [
          {
            "bteqExport": {
              "file": "/tmp/your_export.csv",
              "format": "REPORT",
              "separator": ",",
              "width": "2000",
              "titleDashes": "false",
              "query": "SELECT product_id, product_name, price, category FROM your_table ORDER BY product_id"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "export-data-format",
        "author": "your_author",
        "runWith": "bteq",
        "changes": [
          {
            "bteqExport": {
              "file": "/tmp/your_export.dat",
              "format": "DATA",
              "query": "SELECT product_id, product_name FROM your_table WHERE category = 'Electronics' ORDER BY product_id"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Export as CSV with REPORT format
  - changeSet:
      id: export-csv-report
      author: your_author
      runWith: bteq
      changes:
        - bteqExport:
            file: /tmp/your_export.csv
            format: REPORT
            separator: ","
            width: "2000"
            titleDashes: "false"
            query: "SELECT product_id, product_name, price, category FROM your_table ORDER BY product_id"

  # Export with DATA format
  - changeSet:
      id: export-data-format
      author: your_author
      runWith: bteq
      changes:
        - bteqExport:
            file: /tmp/your_export.dat
            format: DATA
            query: "SELECT product_id, product_name FROM your_table WHERE category = 'Electronics' ORDER BY product_id"

.SET WIDTH 2000
.SET SEPARATOR ','
.SET TITLEDASHES OFF
.EXPORT REPORT FILE=/tmp/your_export.csv
SELECT product_id, product_name, price, category FROM your_table ORDER BY product_id;
.EXPORT RESET

bteqExport

Available attributes

Example code

XML

JSON

YAML

SQL