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_vdf Reads a VDF file and create the associated vDataFrame.

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.
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_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.
vHelp Help module (FAQ).