Links

Unions

Union one or multiple tables with the base table. Looks at all columns in each table and finds columns in common across all of them to keep in the final table.

Parameters

Name
Type
Description
Is Optional
union_tables
table_list
tables to union with the base table
​
remove_duplicates
boolean
Defaults to False. Set to True to use UNION, which removes duplicate rows. Set to False to use UNION ALL, which keeps rows that are duplicated.
True

Example

d1 = rasgo.get.dataset(dataset_id)
d2 = rasgo.get.dataset(dataset_id_2)
d3 = rasgo.get.dataset(dataset_id_3)
​
union_ds = d1.unions(
union_tables=[d2.fqtn, d3.fqtn]
remove_duplicates=True
)
​
union_ds.preview()

Source Code

Last modified 1yr ago