Create New Relations

Function	Definition
create_schema	Creates a new schema.
create_table	Creates a new table using the input columns' names and data types.
create_verticapy_schema	Creates the VerticaPy schema.

Drop Data

Function	Definition
drop	Drops the input relation.

Help & Version

Function	Definition
help_start	Help module (FAQ).
version	Returns the Vertica version.

Ingest Data

Function	Definition
insert_into	Inserts the dataset into an existing Vertica table.
pandas_to_vertica	Ingests a pandas DataFrame into the Vertica database.
pcsv	Parses a CSV file using flex tables and identifies the columns and their respective types.
pjson	Parses a JSON file using flex tables and identifies the columns and their respective types.
read_csv	Ingests a CSV file using flex tables.
read_json	Ingests a JSON file using flex tables.
read_shp	Ingests a SHP file.

Options & Displaying

Function	Definition
set_option	Sets VerticaPy options.

Read Data

Function	Definition
get_data_types	Returns a customized relation with columns and their respective data types.
readSQL	Returns the result of a SQL query as a tablesample object.
tablesample	Displays query results. This object does not have dependencies with any other module.
to_tablesample	Returns the result of a SQL query as a tablesample object.
vDataFrameSQL	Creates a vDataFrame based on a customized relation.