Skip to main content
  • Append (or insert) all records from a source table (specified by source_table_name) to a particular target table (specified by table_name). The field map (specified by field_map) holds the user specified map of target table column names with their mapped source column names.

    Parameters

    • table_name: string

      The table name for the records to be appended, in [schema_name.]table_name format, using standard name resolution rules. Must be an existing table.

    • source_table_name: string

      The source table name to get records from, in [schema_name.]table_name format, using standard name resolution rules. Must be an existing table name.

    • field_map: Record<string, string>

      Contains the mapping of column names from the target table (specified by table_name) as the keys, and corresponding column names or expressions (e.g., ‘col_name+1’) from the source table (specified by source_table_name). Must be existing column names in source table and target table, and their types must be matched. For details on using expressions, see Expressions.

    • Optionaloptions: Record<string, string>

      Optional parameters.

    • Optionalcallback: GPUdbCallback

      Optional callback function

    Returns Promise<AppendRecordsResponse>

    Promise<Types.AppendRecordsResponse> - Promise resolving to the response

  • Append (or insert) all records from a source table (specified by source_table_name) to a particular target table (specified by table_name). The field map (specified by field_map) holds the user specified map of target table column names with their mapped source column names.

    Parameters

    Returns Promise<AppendRecordsResponse>

    Promise<Types.AppendRecordsResponse> - Promise resolving to the response