Loading...

Utilities

Utility functions for creating, managing, and querying database objects.


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

vast_python_dtype(type_name[, display_size, ...])

Takes as input the Trino type information and returns its corresponding data type string.