insert - Kinetica Docs

insert(*, table_name: str = None, records: List[Any] | Dict[str, Any] | List[List[Any]] | List[Dict[str, Any]] = None, options=None)[source]

Insert one or more records.

Parameters

table_name –

keyword only The name of the Kinetica table to insert data into

records –

keyword only Values for all columns of a single record or multiple records. For a single record, use either of the following syntaxes:

insert_records( [1, 2, 3] )

For multiple records, use either of the following syntaxes:

insert_records( [ [1, 2, 3], [4, 5, 6] ] )
insert_records(   [1, 2, 3], [4, 5, 6]   )

Also, the user can use keyword arguments to pass in values:

# For a record type with two integers named 'a' and 'b':
insert_records( {"a":  1, "b":  1},
                {"a": 42, "b": 32} )

# Also can use a list to pass the dicts
insert_records( [ {"a":  1, "b":  1},
                  {"a": 42, "b": 32} ] )

Additionally, the user may provide options for the insertion operation. For example:

insert_records( [1, 2, 3], [4, 5, 6],
                options = {"return_record_ids": "true"} )

options –

keyword only Values for all columns for a single record. Mutually exclusive with args (i.e. cannot provide both) when it only contains data.

May contain an ‘options’ keyword arg which will be passed to the database for the insertion operation.

Returns

A GPUdbTable object with the insert_records() –

response fields converted to attributes and stored within.