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_avro	Ingests an AVRO file.
read_csv	Ingests a CSV file.
read_file	Inspects and ingests a file in CSV, Parquet, ORC, JSON, or Avro format.
read_json	Ingests a JSON file.
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.

Flex Functions

Function	Definition
compute_flextable_keys	Computes the flex table keys and returns the predicted data types.
compute_vmap_keys	Computes the most frequent keys in the input VMap.
isflextable	Checks if the input relation is a flextable.
isvmap	Checks if the input column is a VMap.