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