Ingest Data

Function Definition
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.

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.
tablesampleDisplays 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 Drops the input relation.

Help

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

VerticaPy Schema

Function Definition
create_verticapy_schema Creates the VerticaPy schema.

Options & Displaying

Function Definition
set_option Sets VerticaPy options.