Dataset Tables
The data from CloudBilling is stored in a data warehouse as a PostgreSQL-based relational dataset. The dataset contains tables for the various CloudBilling entities like Products, Customers, Invoices, Pricing Rules, and Purchases. Each table consists of columns that represent the attributes of an entity. For example, a Customer has a Customer Code and Customer Name, which is present for all Customers. All tables contain an attribute called Primary Key that uniquely defines a record in that table. The Primary Key attribute is used to link various tables to each other and retrieve data spanning across multiple tables. The following sections will provide detailed description of the attributes for each table and important considerations.