Loading...

Utilities#

Create New Relations#

create_schema(schema[, raise_error])

Creates a new schema.

create_table(table_name, dtype[, schema, ...])

Creates a new table using the input columns' names and data types.

Ingest Data#

insert_into(table_name, data[, schema, ...])

Inserts the dataset into an existing Vertica table.

See other parsers at Parsers.

Drop Data#

drop([name, method, raise_error])

Drops the input relation.

Database Information#

current_session()

Returns the current DB session.

username()

Returns the current DB username.

does_table_exist(table_name, schema)

Checks if the specified table exists.

has_privileges(object_name, object_schema, ...)

Checks if the user has all the privileges on the object_schema.object_name object.

Table Information#

get_data_types([expr, column, table_name, ...])

Returns customized relation columns and the respective data types.

vertica_python_dtype(type_name[, ...])

Takes as input the Vertica Python type code and returns its corresponding data type.