Reference Data
This article contains the details for all of the informational views that are available in Luminate's Data Share.
Country
Summary
VW_COUNTRY_DS provides a list of all supported countries.
Details
| Field Name | Data Type | Details |
|---|---|---|
COUNTRY_CODE | VARCHAR | 2-digit country code using the ISO 3166-1 alpha-2 format |
COUNTRY_NAME | VARCHAR | Name of the country |
Market
Summary
VW_MARKET_DS provides a list of all metropolitan markets that are supported in the US and Canada datasets. Market-level data is not available outside of US and Canada.
Details
| Field Name | Data Type | Details |
|---|---|---|
MARKET_ID | NUMBER | Unique ID associated with a US or Canadian market. For all other territories, the only supported markets are National or Global. |
MARKET_NAME | VARCHAR | Market name corresponding to the Market ID. |
COUNTRY_CODE | VARCHAR | 2-digit country code using the ISO 3166-1 alpha-2 format |
Date
Summary
VW_DATE_DS provides the various time dimensions that are used in aggregation of Luminate's dataset.
Details
| Field Name | Data Type | Details |
|---|---|---|
DAYOFWEEKNAME | VARCHAR | Name of the day that is corresponding to the DATEID. |
DATEID | NUMBER | Date in YYYYMMDD format. |
DAYOFWEEKID | NUMBER | Order of calendar days within a given chart week. |
WEEKNUM | NUMBER | Order of chart week within a given year. |
WEEKID | NUMBER | ID of chart week in YYYYWW format. |
WEEKRANGE | VARCHAR | Date range for chart week. |
WEEK_END_DATE | DATE | Last date within a given chart week. |
PREVIOUSWEEKID | NUMBER | Previous chart week. |
MONTHID | NUMBER | ID of calendar month in YYYYMM format. |
QUARTERID | NUMBER | ID of calendar quarter in YYYYQ format. |
YEARID | NUMBER | ID of calendar year in YYYY format. |
Fact
Summary
VW_FACT_VALUES_DS provides a list of all available metrics, metric breakouts, and breakout dimensions for the streaming and sales data.
Details
Field Name | Data Type | Details |
|---|---|---|
|
| This field indicates the nature of the consumption. Product Sales are available only for the US and CA country codes. |
|
| Breakouts are categorizations of the consumption data and are metric-specific. Each metric category has its own set of breakouts. |
|
| Breakout values are the most granular classifications of the consumption data. Audio and Video breakout values are only available for the US, CA, and AA country codes. |
Airplay
Summary
VW_AIRPLAY_FORMAT_DS provides a list of all supported airplay formats.
Details
| Field Name | Data Type | Details |
|---|---|---|
FORMAT_ID | VARCHAR | Unique ID assigned to the airplay format |
FORMAT_NAME | VARCHAR | Format name corresponding to the format ID |
MODIFIED_AT | TIMESTAMP_NTZ | A timestamp that indicates when the record was last modified within the Luminate database |
Updated 2 days ago