Copy to clipboard

bteqInsert

Last updated: June 9, 2026

Provides a structured way to insert rows into a Teradata table through the BTEQ executor. Generates a standard SQL INSERT INTO ... VALUES (...) statement from column definitions specified in XML.

This change type is designed for enterprises with no-raw-SQL policies that require all database changes to go through modeled (structured) change types rather than inline SQL. It can be used in any changeset that has runWith="bteq".

Available attributes

Attribute	Type	Required	Description
`tableName`	String	Yes	Target table name
`schemaName`	String	No	Database or schema qualifier. When provided, the table is referenced as `schemaName.tableName`

Column attributes

Each <pro-teradata:column> element defines a column name and its value. Use exactly one value attribute per column.

Attribute	Type	Description
`name`	String	Column name (required)
`value`	String	String value, single-quoted in the generated SQL. Internal single quotes are escaped by doubling (e.g., `O'Brien` → `'O''Brien'`). Use `"` in XML for literal double quotes.
`valueNumeric`	String	Numeric value, inserted without quotes
`valueDate`	Date	Date value, formatted as `DATE 'YYYY-MM-DD'`
`valueBoolean`	Boolean	Boolean value, converted to `1` (true) or `0` (false)
`valueComputed`	String	Raw expression inserted as-is (e.g., `CURRENT_TIMESTAMP`)

If no value attribute is set on a column, the value NULL is inserted.

Example code

Be sure to replace your_table and your_author with your actual table name and author. Columns not listed (e.g., quantity, active, created_at) are inserted as NULL.

<?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 -->
    <changeSet id="insert-setup" author="your_author">
        <preConditions onFail="MARK_RAN">
            <not><tableExists tableName="your_table"/></not>
        </preConditions>
        <createTable tableName="your_table">
            <column name="id" type="int">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="name" type="varchar(100)"/>
            <column name="quantity" type="int"/>
            <column name="active" type="byteint"/>
            <column name="created_at" type="date"/>
        </createTable>
    </changeSet>

    <!-- Insert with string, numeric, boolean, and date values -->
    <changeSet id="insert-row" author="your_author" runWith="bteq">
        <pro-teradata:bteqInsert tableName="your_table">
            <pro-teradata:column name="id" valueNumeric="6"/>
            <pro-teradata:column name="name" value="Widget Alpha"/>
            <pro-teradata:column name="quantity" valueNumeric="100"/>
            <pro-teradata:column name="active" valueBoolean="true"/>
            <pro-teradata:column name="created_at" valueDate="2026-01-15"/>
        </pro-teradata:bteqInsert>
    </changeSet>

    <!-- Insert with special characters in string values -->
    <changeSet id="insert-special-chars" author="your_author" runWith="bteq">
        <pro-teradata:bteqInsert tableName="your_table">
            <pro-teradata:column name="id" valueNumeric="7"/>
            <pro-teradata:column name="name" value="O'Brien's &quot;Best&quot; Gadget"/>
            <pro-teradata:column name="quantity" valueNumeric="0"/>
            <pro-teradata:column name="active" valueBoolean="false"/>
            <pro-teradata:column name="created_at" valueDate="2026-02-28"/>
        </pro-teradata:bteqInsert>
    </changeSet>

    <!-- Insert with NULL values (omitted columns) -->
    <changeSet id="insert-nulls" author="your_author" runWith="bteq">
        <pro-teradata:bteqInsert tableName="your_table">
            <pro-teradata:column name="id" valueNumeric="8"/>
            <pro-teradata:column name="name" value="Minimal Row"/>
        </pro-teradata:bteqInsert>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "insert-row",
        "author": "your_author",
        "runWith": "bteq",
        "changes": [
          {
            "bteqInsert": {
              "tableName": "your_table",
              "columns": [
                { "column": { "name": "id", "valueNumeric": "6" } },
                { "column": { "name": "name", "value": "Widget Alpha" } },
                { "column": { "name": "quantity", "valueNumeric": "100" } },
                { "column": { "name": "active", "valueBoolean": "true" } },
                { "column": { "name": "created_at", "valueDate": "2026-01-15" } }
              ]
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "insert-nulls",
        "author": "your_author",
        "runWith": "bteq",
        "changes": [
          {
            "bteqInsert": {
              "tableName": "your_table",
              "columns": [
                { "column": { "name": "id", "valueNumeric": "8" } },
                { "column": { "name": "name", "value": "Minimal Row" } }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Insert with all value types
  - changeSet:
      id: insert-row
      author: your_author
      runWith: bteq
      changes:
        - bteqInsert:
            tableName: your_table
            columns:
              - column:
                  name: id
                  valueNumeric: "6"
              - column:
                  name: name
                  value: Widget Alpha
              - column:
                  name: quantity
                  valueNumeric: "100"
              - column:
                  name: active
                  valueBoolean: "true"
              - column:
                  name: created_at
                  valueDate: "2026-01-15"

  # Insert with NULL values (omitted columns)
  - changeSet:
      id: insert-nulls
      author: your_author
      runWith: bteq
      changes:
        - bteqInsert:
            tableName: your_table
            columns:
              - column:
                  name: id
                  valueNumeric: "8"
              - column:
                  name: name
                  value: Minimal Row

INSERT INTO your_table (id, name, quantity, active, created_at)
VALUES (6, 'Widget Alpha', 100, 1, DATE '2026-01-15');

<?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 -->
    <changeSet id="insert-setup" author="your_author">
        <preConditions onFail="MARK_RAN">
            <not><tableExists tableName="your_table"/></not>
        </preConditions>
        <createTable tableName="your_table">
            <column name="id" type="int">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="name" type="varchar(100)"/>
            <column name="quantity" type="int"/>
            <column name="active" type="byteint"/>
            <column name="created_at" type="date"/>
        </createTable>
    </changeSet>

    <!-- Insert with string, numeric, boolean, and date values -->
    <changeSet id="insert-row" author="your_author" runWith="bteq">
        <pro-teradata:bteqInsert tableName="your_table">
            <pro-teradata:column name="id" valueNumeric="6"/>
            <pro-teradata:column name="name" value="Widget Alpha"/>
            <pro-teradata:column name="quantity" valueNumeric="100"/>
            <pro-teradata:column name="active" valueBoolean="true"/>
            <pro-teradata:column name="created_at" valueDate="2026-01-15"/>
        </pro-teradata:bteqInsert>
    </changeSet>

    <!-- Insert with special characters in string values -->
    <changeSet id="insert-special-chars" author="your_author" runWith="bteq">
        <pro-teradata:bteqInsert tableName="your_table">
            <pro-teradata:column name="id" valueNumeric="7"/>
            <pro-teradata:column name="name" value="O'Brien's &quot;Best&quot; Gadget"/>
            <pro-teradata:column name="quantity" valueNumeric="0"/>
            <pro-teradata:column name="active" valueBoolean="false"/>
            <pro-teradata:column name="created_at" valueDate="2026-02-28"/>
        </pro-teradata:bteqInsert>
    </changeSet>

    <!-- Insert with NULL values (omitted columns) -->
    <changeSet id="insert-nulls" author="your_author" runWith="bteq">
        <pro-teradata:bteqInsert tableName="your_table">
            <pro-teradata:column name="id" valueNumeric="8"/>
            <pro-teradata:column name="name" value="Minimal Row"/>
        </pro-teradata:bteqInsert>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "insert-row",
        "author": "your_author",
        "runWith": "bteq",
        "changes": [
          {
            "bteqInsert": {
              "tableName": "your_table",
              "columns": [
                { "column": { "name": "id", "valueNumeric": "6" } },
                { "column": { "name": "name", "value": "Widget Alpha" } },
                { "column": { "name": "quantity", "valueNumeric": "100" } },
                { "column": { "name": "active", "valueBoolean": "true" } },
                { "column": { "name": "created_at", "valueDate": "2026-01-15" } }
              ]
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "insert-nulls",
        "author": "your_author",
        "runWith": "bteq",
        "changes": [
          {
            "bteqInsert": {
              "tableName": "your_table",
              "columns": [
                { "column": { "name": "id", "valueNumeric": "8" } },
                { "column": { "name": "name", "value": "Minimal Row" } }
              ]
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Insert with all value types
  - changeSet:
      id: insert-row
      author: your_author
      runWith: bteq
      changes:
        - bteqInsert:
            tableName: your_table
            columns:
              - column:
                  name: id
                  valueNumeric: "6"
              - column:
                  name: name
                  value: Widget Alpha
              - column:
                  name: quantity
                  valueNumeric: "100"
              - column:
                  name: active
                  valueBoolean: "true"
              - column:
                  name: created_at
                  valueDate: "2026-01-15"

  # Insert with NULL values (omitted columns)
  - changeSet:
      id: insert-nulls
      author: your_author
      runWith: bteq
      changes:
        - bteqInsert:
            tableName: your_table
            columns:
              - column:
                  name: id
                  valueNumeric: "8"
              - column:
                  name: name
                  value: Minimal Row

INSERT INTO your_table (id, name, quantity, active, created_at)
VALUES (6, 'Widget Alpha', 100, 1, DATE '2026-01-15');

bteqInsert

Available attributes

Column attributes

Example code

XML

JSON

YAML

SQL