insert_into¶

In [ ]:

insert_into(table_name: str,
            data: list,
            schema: str = "",
            column_names: list = [],
            copy: bool = True,
            genSQL: bool = False,)

Inserts the dataset into an existing Vertica table.

Parameters¶

Name	Type	Optional	Description
table_name	str	❌	Name of the table to insert into.
data	list	❌	The data to ingest.
schema	str	✓	Schema name.
column_names	list	✓	Name of the column(s) to insert into.
copy	bool	✓	If set to True, the batch insert is converted to a COPY statement with prepared statements. Otherwise, the INSERTs are performed sequentially.
genSQL	bool	✓	If set to True, the SQL code that would be used to insert the data is generated, but not executed.

Returns¶

int : The number of rows ingested.

Example¶

In [28]:

from verticapy.datasets import load_iris
iris = load_iris()
iris

Out[28]:

	123 SepalLengthCm Numeric(5,2)	123 SepalWidthCm Numeric(5,2)	123 PetalLengthCm Numeric(5,2)	123 PetalWidthCm Numeric(5,2)	Abc Species Varchar(30)
1	4.3	3.0	1.1	0.1	Iris-setosa
2	4.4	2.9	1.4	0.2	Iris-setosa
3	4.4	3.0	1.3	0.2	Iris-setosa
4	4.4	3.2	1.3	0.2	Iris-setosa
5	4.5	2.3	1.3	0.3	Iris-setosa
6	4.6	3.1	1.5	0.2	Iris-setosa
7	4.6	3.2	1.4	0.2	Iris-setosa
8	4.6	3.4	1.4	0.3	Iris-setosa
9	4.6	3.6	1.0	0.2	Iris-setosa
10	4.7	3.2	1.3	0.2	Iris-setosa
11	4.7	3.2	1.6	0.2	Iris-setosa
12	4.8	3.0	1.4	0.1	Iris-setosa
13	4.8	3.0	1.4	0.3	Iris-setosa
14	4.8	3.1	1.6	0.2	Iris-setosa
15	4.8	3.4	1.6	0.2	Iris-setosa
16	4.8	3.4	1.9	0.2	Iris-setosa
17	4.9	2.4	3.3	1.0	Iris-versicolor
18	4.9	2.5	4.5	1.7	Iris-virginica
19	4.9	3.0	1.4	0.2	Iris-setosa
20	4.9	3.1	1.5	0.1	Iris-setosa
21	4.9	3.1	1.5	0.1	Iris-setosa
22	4.9	3.1	1.5	0.1	Iris-setosa
23	5.0	2.0	3.5	1.0	Iris-versicolor
24	5.0	2.3	3.3	1.0	Iris-versicolor
25	5.0	3.0	1.6	0.2	Iris-setosa
26	5.0	3.2	1.2	0.2	Iris-setosa
27	5.0	3.3	1.4	0.2	Iris-setosa
28	5.0	3.4	1.5	0.2	Iris-setosa
29	5.0	3.4	1.6	0.4	Iris-setosa
30	5.0	3.5	1.3	0.3	Iris-setosa
31	5.0	3.5	1.6	0.6	Iris-setosa
32	5.0	3.6	1.4	0.2	Iris-setosa
33	5.1	2.5	3.0	1.1	Iris-versicolor
34	5.1	3.3	1.7	0.5	Iris-setosa
35	5.1	3.4	1.5	0.2	Iris-setosa
36	5.1	3.5	1.4	0.2	Iris-setosa
37	5.1	3.5	1.4	0.3	Iris-setosa
38	5.1	3.7	1.5	0.4	Iris-setosa
39	5.1	3.8	1.5	0.3	Iris-setosa
40	5.1	3.8	1.6	0.2	Iris-setosa
41	5.1	3.8	1.9	0.4	Iris-setosa
42	5.2	2.7	3.9	1.4	Iris-versicolor
43	5.2	3.4	1.4	0.2	Iris-setosa
44	5.2	3.5	1.5	0.2	Iris-setosa
45	5.2	4.1	1.5	0.1	Iris-setosa
46	5.3	3.7	1.5	0.2	Iris-setosa
47	5.4	3.0	4.5	1.5	Iris-versicolor
48	5.4	3.4	1.5	0.4	Iris-setosa
49	5.4	3.4	1.7	0.2	Iris-setosa
50	5.4	3.7	1.5	0.2	Iris-setosa
51	5.4	3.9	1.3	0.4	Iris-setosa
52	5.4	3.9	1.7	0.4	Iris-setosa
53	5.5	2.3	4.0	1.3	Iris-versicolor
54	5.5	2.4	3.7	1.0	Iris-versicolor
55	5.5	2.4	3.8	1.1	Iris-versicolor
56	5.5	2.5	4.0	1.3	Iris-versicolor
57	5.5	2.6	4.4	1.2	Iris-versicolor
58	5.5	3.5	1.3	0.2	Iris-setosa
59	5.5	4.2	1.4	0.2	Iris-setosa
60	5.6	2.5	3.9	1.1	Iris-versicolor
61	5.6	2.7	4.2	1.3	Iris-versicolor
62	5.6	2.8	4.9	2.0	Iris-virginica
63	5.6	2.9	3.6	1.3	Iris-versicolor
64	5.6	3.0	4.1	1.3	Iris-versicolor
65	5.6	3.0	4.5	1.5	Iris-versicolor
66	5.7	2.5	5.0	2.0	Iris-virginica
67	5.7	2.6	3.5	1.0	Iris-versicolor
68	5.7	2.8	4.1	1.3	Iris-versicolor
69	5.7	2.8	4.5	1.3	Iris-versicolor
70	5.7	2.9	4.2	1.3	Iris-versicolor
71	5.7	3.0	4.2	1.2	Iris-versicolor
72	5.7	3.8	1.7	0.3	Iris-setosa
73	5.7	4.4	1.5	0.4	Iris-setosa
74	5.8	2.6	4.0	1.2	Iris-versicolor
75	5.8	2.7	3.9	1.2	Iris-versicolor
76	5.8	2.7	4.1	1.0	Iris-versicolor
77	5.8	2.7	5.1	1.9	Iris-virginica
78	5.8	2.7	5.1	1.9	Iris-virginica
79	5.8	2.8	5.1	2.4	Iris-virginica
80	5.8	4.0	1.2	0.2	Iris-setosa
81	5.9	3.0	4.2	1.5	Iris-versicolor
82	5.9	3.0	5.1	1.8	Iris-virginica
83	5.9	3.2	4.8	1.8	Iris-versicolor
84	6.0	2.2	4.0	1.0	Iris-versicolor
85	6.0	2.2	5.0	1.5	Iris-virginica
86	6.0	2.7	5.1	1.6	Iris-versicolor
87	6.0	2.9	4.5	1.5	Iris-versicolor
88	6.0	3.0	4.8	1.8	Iris-virginica
89	6.0	3.4	4.5	1.6	Iris-versicolor
90	6.1	2.6	5.6	1.4	Iris-virginica
91	6.1	2.8	4.0	1.3	Iris-versicolor
92	6.1	2.8	4.7	1.2	Iris-versicolor
93	6.1	2.9	4.7	1.4	Iris-versicolor
94	6.1	3.0	4.6	1.4	Iris-versicolor
95	6.1	3.0	4.9	1.8	Iris-virginica
96	6.2	2.2	4.5	1.5	Iris-versicolor
97	6.2	2.8	4.8	1.8	Iris-virginica
98	6.2	2.9	4.3	1.3	Iris-versicolor
99	6.2	3.4	5.4	2.3	Iris-virginica
100	6.3	2.3	4.4	1.3	Iris-versicolor

Rows: 1-100 | Columns: 5

In [9]:

from verticapy.utilities import insert_into
# copy left as default (True): one copy
insert_into(table_name = "iris",
            schema = "public",
            data = [[3.3, 4.5, 5.6, 7.8, "Iris-setosa"], 
                    [4.3, 4.7, 9.6, 1.8, "Iris-virginica"]],)

Out[9]:

In [10]:

# copy set to False: multiple inserts
insert_into(table_name = "iris",
            schema = "public",
            data = [[3.3, 4.5, 5.6, 7.8, "Iris-setosa"], 
                    [4.3, 4.7, 9.6, 1.8, "Iris-virginica"]],
            copy=False,)

Out[10]:

In [11]:

# genSQL set to True: SQL for inserting data is generated, but not executed
# copy set to False: multiple inserts
insert_into(table_name = "iris",
            schema = "public",
            data = [[3.3, 4.5, 5.6, 7.8, "Iris-setosa"], 
                    [4.3, 4.7, 9.6, 1.8, "Iris-virginica"]],
            genSQL=True,)

Out[11]:

['INSERT INTO "public"."iris" ("SepalLengthCm", "SepalWidthCm", "PetalLengthCm", "PetalWidthCm", "Species") VALUES (\'3.3\',\'4.5\',\'5.6\',\'7.8\',\'Iris-setosa\');',
 'INSERT INTO "public"."iris" ("SepalLengthCm", "SepalWidthCm", "PetalLengthCm", "PetalWidthCm", "Species") VALUES (\'4.3\',\'4.7\',\'9.6\',\'1.8\',\'Iris-virginica\');']

read_csv	Ingests a CSV file into the Vertica DB.
read_json	Ingests a JSON file into the Vertica DB.

insert_into¶

Parameters¶

Returns¶

Example¶

See Also¶