bteqImport

Last updated: June 9, 2026

Loads data from a delimited file on the BTEQ execution host into a Teradata table. Generates the complete BTEQ import sequence (.IMPORT, .REPEAT, USING, and INSERT) so you do not need to hand-write the multi-command block in a <sql> element.

Getting the USING(...) clause wrong can silently corrupt data. This change type builds it from structured column definitions, reducing the risk of type mismatches.

Note: This change type does not support automatic rollback.

Available attributes

Attribute	Type	Required	Description
`file`	String	Yes	Absolute path to the input file on the BTEQ execution host. Must not contain newline characters.
`tableName`	String	Yes	Target table for the INSERT.
`schemaName`	String	No	Database or schema qualifier.
`format`	String	No	Import format. In `VARTEXT` mode, columns are read as delimited text, declared as `VARCHAR` in the `USING` clause, and non-`VARCHAR` types are cast in the generated `VALUES` clause. In `DATA` mode, columns use native types directly from a binary file produced by BTEQ `.EXPORT DATA`. Accepted values: `VARTEXT` or `DATA`. Default: `VARTEXT`.
`delimiter`	String	No	Field delimiter character. Applies to `VARTEXT` mode only. Default: `,`.
`repeatCount`	String	No	Number of rows to import. Use `` for all rows, or a positive integer to limit the import. Default: ``.

Column nested attributes

Each <pro-teradata:column> element defines a column in the import file and its target data type.

Attribute	Type	Required	Description
`name`	String	Yes	Column name. Must match a column in the target table.
`type`	String	Yes	Teradata data type. In `VARTEXT` mode, non-`VARCHAR` types (e.g., `INTEGER`, `DATE`) are declared as `VARCHAR` buffers in the `USING` clause and cast to this type in the generated `VALUES` clause. In `DATA` mode, the native type is used directly.
`format`	String	No	Date or timestamp format string for casting in `VARTEXT` mode (e.g., `YYYY-MM-DD`).

Example code

Be sure to replace your_table, your_author, and your_file_path 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 target table for import -->
    <changeSet id="import-setup" author="your_author">
        <preConditions onFail="MARK_RAN">
            <not><tableExists tableName="your_table"/></not>
        </preConditions>
        <createTable tableName="your_table">
            <column name="item_id" type="int">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="item_name" type="varchar(100)"/>
            <column name="price" type="decimal(10,2)"/>
            <column name="received_date" type="date"/>
        </createTable>
    </changeSet>

    <!-- Import CSV data -->
    <changeSet id="import-csv" author="your_author" runWith="bteq">
        <pro-teradata:bteqImport file="your_file_path"
                        tableName="your_table"
                        format="VARTEXT"
                        delimiter=",">
            <pro-teradata:column name="item_id" type="INTEGER"/>
            <pro-teradata:column name="item_name" type="VARCHAR(100)"/>
            <pro-teradata:column name="price" type="DECIMAL(10,2)"/>
            <pro-teradata:column name="received_date" type="DATE" format="YYYY-MM-DD"/>
        </pro-teradata:bteqImport>
    </changeSet>

    <!-- Verify: select imported rows -->
    <changeSet id="import-verify" author="your_author" runWith="bteq">
        <sql>SELECT * FROM your_table ORDER BY item_id;</sql>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "import-csv",
        "author": "your_author",
        "runWith": "bteq",
        "changes": [
          {
            "bteqImport": {
              "file": "your_file_path",
              "tableName": "your_table",
              "format": "VARTEXT",
              "delimiter": ",",
              "columns": [
                { "column": { "name": "item_id", "type": "INTEGER" } },
                { "column": { "name": "item_name", "type": "VARCHAR(100)" } },
                { "column": { "name": "price", "type": "DECIMAL(10,2)" } },
                { "column": { "name": "received_date", "type": "DATE", "format": "YYYY-MM-DD" } }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: import-csv
      author: your_author
      runWith: bteq
      changes:
        - bteqImport:
            file: your_file_path
            tableName: your_table
            format: VARTEXT
            delimiter: ","
            columns:
              - column:
                  name: item_id
                  type: INTEGER
              - column:
                  name: item_name
                  type: VARCHAR(100)
              - column:
                  name: price
                  type: DECIMAL(10,2)
              - column:
                  name: received_date
                  type: DATE
                  format: YYYY-MM-DD

.IMPORT VARTEXT ',' FILE=your_file_path
.REPEAT *
USING (
    item_id VARCHAR(12),
    item_name VARCHAR(100),
    price VARCHAR(12),
    received_date VARCHAR(12)
)
INSERT INTO your_table (item_id, item_name, price, received_date)
VALUES (CAST(:item_id AS INTEGER), :item_name, CAST(:price AS DECIMAL(10,2)), CAST(:received_date AS DATE FORMAT 'YYYY-MM-DD'));

<?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 target table for import -->
    <changeSet id="import-setup" author="your_author">
        <preConditions onFail="MARK_RAN">
            <not><tableExists tableName="your_table"/></not>
        </preConditions>
        <createTable tableName="your_table">
            <column name="item_id" type="int">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="item_name" type="varchar(100)"/>
            <column name="price" type="decimal(10,2)"/>
            <column name="received_date" type="date"/>
        </createTable>
    </changeSet>

    <!-- Import CSV data -->
    <changeSet id="import-csv" author="your_author" runWith="bteq">
        <pro-teradata:bteqImport file="your_file_path"
                        tableName="your_table"
                        format="VARTEXT"
                        delimiter=",">
            <pro-teradata:column name="item_id" type="INTEGER"/>
            <pro-teradata:column name="item_name" type="VARCHAR(100)"/>
            <pro-teradata:column name="price" type="DECIMAL(10,2)"/>
            <pro-teradata:column name="received_date" type="DATE" format="YYYY-MM-DD"/>
        </pro-teradata:bteqImport>
    </changeSet>

    <!-- Verify: select imported rows -->
    <changeSet id="import-verify" author="your_author" runWith="bteq">
        <sql>SELECT * FROM your_table ORDER BY item_id;</sql>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "import-csv",
        "author": "your_author",
        "runWith": "bteq",
        "changes": [
          {
            "bteqImport": {
              "file": "your_file_path",
              "tableName": "your_table",
              "format": "VARTEXT",
              "delimiter": ",",
              "columns": [
                { "column": { "name": "item_id", "type": "INTEGER" } },
                { "column": { "name": "item_name", "type": "VARCHAR(100)" } },
                { "column": { "name": "price", "type": "DECIMAL(10,2)" } },
                { "column": { "name": "received_date", "type": "DATE", "format": "YYYY-MM-DD" } }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: import-csv
      author: your_author
      runWith: bteq
      changes:
        - bteqImport:
            file: your_file_path
            tableName: your_table
            format: VARTEXT
            delimiter: ","
            columns:
              - column:
                  name: item_id
                  type: INTEGER
              - column:
                  name: item_name
                  type: VARCHAR(100)
              - column:
                  name: price
                  type: DECIMAL(10,2)
              - column:
                  name: received_date
                  type: DATE
                  format: YYYY-MM-DD

.IMPORT VARTEXT ',' FILE=your_file_path
.REPEAT *
USING (
    item_id VARCHAR(12),
    item_name VARCHAR(100),
    price VARCHAR(12),
    received_date VARCHAR(12)
)
INSERT INTO your_table (item_id, item_name, price, received_date)
VALUES (CAST(:item_id AS INTEGER), :item_name, CAST(:price AS DECIMAL(10,2)), CAST(:received_date AS DATE FORMAT 'YYYY-MM-DD'));

bteqImport

Available attributes

Column nested attributes

Example code

XML

JSON

YAML

SQL