verticapy.vertica_python_dtype¶

verticapy.vertica_python_dtype(type_name: str, display_size: int = 0, precision: int = 0, scale: int = 0) → str¶

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

Parameters¶

Let’s import the function before proceeding.

from verticapy.sql import vertica_python_dtype

Let’s format a varchar data type.

vertica_python_dtype('varchar', 666)
Out[2]: 'varchar(666)'

Let’s format a numeric data type.

vertica_python_dtype('numeric', precision = 5, scale = 4)
Out[3]: 'numeric(5,4)'

Note

This function is designed for formatting the cursor-guessed data type. Ensuring the optimal performance of the get_data_types function is crucial.