OLAP Index Design Views

All Columns View

Name Pattern: snap$olapindex_<facttablename> for example snap$olapindex_store_sales

Provides detailed information about column in the StarSchema.

Schema:

Name	DataType	Description
tableName	String
columnName	String
isPrimaryKey	Boolean
isForeignKey	Boolean
sparkData	String
sparkTimestampFormat	String
indexFieldName	String
indexData	String
isNullable	Boolean
nullValueInIndex	String
indexField	String
isIndexTimestamp	Boolean
indexDefaultAggregator	String
indexHasMetricExtraction	Boolean
sourceDistinctCount	Long
sourceMinValue	String
sourceMaxValue	String
sourceNullCount	Long
sourceAvgLen	Long
sourceMaxLen	Long
indexAvgDictionarySize	Double
indexAvgColumnSize	Double
indexAvgTotalSize	Double
indexAvgNumDistincts	Double
hintNeverUsed	Boolean
hintFreqFiltered	Boolean
hintFreqGBy	Boolean
hintFreqAgg	Boolean
hintIsIndexTS	Boolean
hintTSFormat	String
hintBinGiven	Boolean
hintTimeElemExtractGiven	Boolean
hintPrecision	String

Options View

Name Pattern: snap$olapindex_<facttablename>_options for example snap$olapindex_store_sales_options

List the OLAP Index Options

Schema:

Name	DataType	Description
name	String
value	String

TimeElems View

Name Pattern: snap$olapindex_<facttablename>_timeelem_extracts for example snap$olapindex_store_sales_timeelem_extracts

For Metrics with an defined TimestampMetricExtractInfo this lists each TimeElement

Schema:

Name	DataType	Description
indexFieldName	String
timeElementExtract	String	for example: Year, Month, ...

NumBins View

Name Pattern: snap$olapindex_<facttablename>_numbin_extracts for example snap$olapindex_store_sales_numbin_extracts

For Metrics with an defined NumBinsMetricInfo this lists the binning information

Schema:

Name	DataType	Description
indexFieldName	String
minValue	String
maxValue	String
numBins	String
okToRemoveOriginalFilterInQuery	String

ExplicitBins View

Name Pattern: snap$olapindex_<facttablename>_explicitbin_extracts for example snap$olapindex_store_sales_explicitbin_extracts

For Metrics with an defined ExplicitBinsMetricInfo this lists the binning information

Schema:

Name	DataType	Description
indexFieldName	String
bins	String
okToRemoveOriginalFilterInQuery	String