Data Cache Data ModelStatistics on the size of facts.
Catalog: Cache
Schema: Invantive
Alias: fsc
Label: Fact Size Statistics
This is a read-only view. The Data Cache API may not support changing the data or the Invantive SQL driver for Data Cache does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Cache API.
View Columns
The columns of the view dc_fact_size_statistics are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
dcr_name |
string(240) |
Data Container ID |
☑ |
Name of the data container. |
fsc_active_count_partitions |
decimal |
Size of Active Versions (partitions) |
☑ |
Total number of partitions in active versions. |
fsc_active_size_characters_m |
decimal |
Size of Active Versions (million characters) |
☑ |
Total number of characters in millions in active versions. |
fsc_active_size_rows_m |
decimal |
Size of Active Versions (million rows) |
☑ |
Total number of rows in millions in active versions. |
fsc_deleted_count_partitions |
decimal |
Size of Deleted Versions (partitions) |
☑ |
Total number of partitions in deleted versions. |
fsc_deleted_size_characters_m |
decimal |
Size of Obsoleted Versions (million characters) |
☑ |
Total number of characters in millions in deleted versions. |
fsc_deleted_size_rows_m |
decimal |
Size of Deleted Versions (million rows) |
☑ |
Total number of rows in millions in deleted versions. |
fsc_obsoleted_count_partitions |
decimal |
Size of Obsoleted Versions (partitions) |
☑ |
Total number of partitions in obsoleted versions. |
fsc_obsoleted_size_characters_m |
decimal |
Size of Obsoleted Versions (million characters) |
☑ |
Total number of characters in millions in obsoleted versions. |
fsc_obsoleted_size_rows_m |
decimal |
Size of Obsoleted Versions (million rows) |
☑ |
Total number of rows in millions in obsoleted versions. |
fsc_total_count_partitions |
decimal |
Size of All Versions (partitions) |
☑ |
Total number of partitions. |
fsc_total_size_characters_m |
decimal |
Size of All Versions (million characters) |
☑ |
Total number of characters in millions. |
fsc_total_size_rows_m |
decimal |
Size of All Versions (million rows) |
☑ |
Total number of rows in millions. |
tbe_facts_table_name |
string(30) |
Facts Table Name |
☑ |
Name of the facts table with last downloaded data for this table. |
tbe_full_qualified_name |
string(240) |
Full Qualified Name |
☑ |
Full qualified name of the table to be downloaded. |
09-12-2020 18:57 Version 20.1.300-BETA+3020
