About the Discover Base Tables
SAS 360 Discover base tables (DBTs) combine sets of information from different detail tables to create tables that you might find useful for analysis. Each DBT is created to provide you with one place to get the most relevant information about a specific subject.
In addition, these tables are used to create the predefined reports that are available in SAS Customer Intelligence 360.
These tables can be downloaded using the SAS Customer Intelligence 360 download API. Use the following information when downloading DBTs:
- In your API call, use the
dbtReportendpoint to download these tables. For more information, see Download Discover Base Tables (DBTs) and Analytical Base Tables (ABTs) in SAS Customer Intelligence 360: Administration Guide or Downloading Data Tables with the REST API in SAS Customer Intelligence 360: Administration Guide. - Make sure that you review the category and schema version for the tables that you want to download.
TipTo download all tables that you have access to, use the
ALLcategory and the most recent schema version (22). - The DBTs are updated about every four hours. Only completed sessions are available for download.
- Download the entity relationship diagrams to review the tables' organization and links.
- The downloaded data might contain
more columns than are documented in the Help Center or in the schema files.
These columns might have been introduced for internal consumption already
and will be added to a future version of the schema.
The same scenario can happen when you are not using the most recent schema. The data that you download always uses the columns from the latest schema, but you might have requested a schema version that has fewer columns.
- A schema might add columns to
tables, but the columns are not populated with data until a later release of
SAS Customer Intelligence
360. For example, a table in the current schema might have nine
columns, but data records populate only seven columns. When columns are
added but not yet populated with data, you can ignore these columns when you
process the data.
When SAS Customer Intelligence 360 is updated to populate these columns, you might need to wait 2–3 days before the data is populated in the downloaded tables.
To mitigate any issues, configure your ETL processes to allow for the physical files to have more columns than what is described in the JSON schema and the documentation.