Skip to main content
  • Merges data from one or more tables with comparable data types into a new table.

    The following merges are supported:

    UNION (DISTINCT/ALL) - For data set union details and examples, see Union. For limitations, see Union Limitations and Cautions.

    INTERSECT (DISTINCT/ALL) - For data set intersection details and examples, see Intersect. For limitations, see Intersect Limitations.

    EXCEPT (DISTINCT/ALL) - For data set subtraction details and examples, see Except. For limitations, see Except Limitations.

    Parameters

    • table_name: string

      Name of the table to be created, in [schema_name.]table_name format, using standard name resolution rules and meeting table naming criteria.

    • table_names: string[]

      The list of table names to merge, in [schema_name.]table_name format, using standard name resolution rules. Must contain the names of one or more existing tables.

    • input_column_names: string[][]

      The list of columns from each of the corresponding input tables.

    • output_column_names: string[]

      The list of names of the columns to be stored in the output table.

    • Optionaloptions: Record<string, string>

      Optional parameters.

    • Optionalcallback: GPUdbCallback

      Optional callback function

    Returns Promise<CreateUnionResponse>

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

  • Merges data from one or more tables with comparable data types into a new table.

    The following merges are supported:

    UNION (DISTINCT/ALL) - For data set union details and examples, see Union. For limitations, see Union Limitations and Cautions.

    INTERSECT (DISTINCT/ALL) - For data set intersection details and examples, see Intersect. For limitations, see Intersect Limitations.

    EXCEPT (DISTINCT/ALL) - For data set subtraction details and examples, see Except. For limitations, see Except Limitations.

    Parameters

    Returns Promise<CreateUnionResponse>

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