Ingest Data

Function	Definition
pandas_to_vertica	Ingests a pandas DataFrame to Vertica DB by creating a CSV file first and then using flex tables.
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 Data

Function	Definition
get_data_types	Returns a customized relation with columns and their respective data types. Creates a temporary table during the process.
load_model	Loads a Vertica model and returns the associated object.
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.
vdf_from_relation	Creates a vDataFrame based on a customized relation.

Drop Data

Function	Definition
drop_model	Drops the input model.
drop_table	Drops the input table.
drop_text_index	Drops the input text index.
drop_view	Drops the input view.

Help

Function	Definition
check_model	Checks if the model already exists.
version	Returns the Vertica Version.
vHelp	Help module (FAQ).

VerticaPy Schema

Function	Definition
create_verticapy_schema	Creates the VerticaPy schema.
drop_verticapy_schema	Drops the VerticaPy schema.

Options & Displaying

Function	Definition
set_option	Sets new VerticaPy options.