When I set the list of active partitions in Data Hub using:
select code
from systemdivisions
where city='Rotterdam'
to all customers in Rotterdam, the next queries will retrieve data across all customers.
In Invantive Control I can see in the GUI which partitions are selected, but this is not visible in Data Hub since it is a command line tool.
How can I determine afterwards which companies have been selected as a partition?
Use the following query:
select code
, label
, short_name
from systempartitions@datadictionary
where is_selected = true
order
by code
to retrieve the currently selected partitions.