vastorbit.core.tablesample.base.TableSample.to_sql¶

TableSample.to_sql() → str¶

Generates the SQL query associated to the TableSample.

Returns:: SQL query associated to the TableSample.
Return type:: str

Examples

Let’s import the TableSample object:

from vastorbit import TableSample

Let’s build an example object.

# dict with all the data.
d = {
    "customer_ID": [0, 1, 2, 3],
    "age": [40, 30, 22, 55],
    "name": ['Roger', 'Maria', 'Alisia', 'Costi'],
}

# creating the object.
tb = TableSample(d)

	customer_ID	age	name
1	0	40	Roger
2	1	30	Maria
3	2	22	Alisia
4	3	55	Costi

Rows: 1-4 | Columns: 3

Let’s use the function.

print(tb.to_sql())