Class AzureSynapseAnalyticsSchema.DataContext
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
public class AzureSynapseAnalyticsSchema.DataContext- Inheritance
-
AzureSynapseAnalyticsSchema.DataContext
- Extension Methods
Constructors
DataContext(IDataContext)
public DataContext(IDataContext dataContext)Parameters
dataContextIDataContext
Properties
ColumnDistributionProperties
sys.pdw_column_distribution_properties (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Holds distribution information for columns.
public ITable<AzureSynapseAnalyticsSchema.ColumnDistributionProperty> ColumnDistributionProperties { get; }Property Value
DatabaseMappings
sys.pdw_database_mappings (Transact-SQL)
Applies to: √ Analytics Platform System (PDW)
Maps the database_ids of databases to the physical name used on Compute nodes, and provides the principal id of the database owner on the system. Join sys.pdw_database_mappings to sys.databases and sys.pdw_nodes_pdw_physical_databases.
public ITable<AzureSynapseAnalyticsSchema.DatabaseMapping> DatabaseMappings { get; }Property Value
DiagEventProperties
sys.pdw_diag_event_properties (Transact-SQL)
Applies to: √ Analytics Platform System (PDW)
Holds information about which properties are associated with diagnostic events.
public ITable<AzureSynapseAnalyticsSchema.DiagEventProperty> DiagEventProperties { get; }Property Value
DiagEvents
sys.pdw_diag_events (Transact-SQL)
Applies to: √ Analytics Platform System (PDW)
Holds information about events that can be included in diagnostic sessions on the system.
See sys.pdw_diag_events.
public ITable<AzureSynapseAnalyticsSchema.DiagEvent> DiagEvents { get; }Property Value
DiagSessions
sys.pdw_diag_sessions (Transact-SQL)
Applies to: √ Analytics Platform System (PDW)
Holds information regarding the various diagnostic sessions that have been created on the system.
public ITable<AzureSynapseAnalyticsSchema.DiagSession> DiagSessions { get; }Property Value
Distributions
sys.pdw_distributions (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Holds information about the distributions on the appliance. It lists one row per appliance distribution.
public ITable<AzureSynapseAnalyticsSchema.Distribution> Distributions { get; }Property Value
HealthAlerts
sys.pdw_health_alerts (Transact-SQL)
Applies to: √ Analytics Platform System (PDW)
Stores properties for the different alerts that can occur on the system; this is a catalog table for alerts.
public ITable<AzureSynapseAnalyticsSchema.HealthAlert> HealthAlerts { get; }Property Value
HealthComponentGroups
sys.pdw_health_component_groups (Transact-SQL)
Applies to: √ Analytics Platform System (PDW)
Stores information about logical groupings of components and devices.
public ITable<AzureSynapseAnalyticsSchema.HealthComponentGroup> HealthComponentGroups { get; }Property Value
HealthComponentProperties
sys.pdw_health_component_properties (Transact-SQL)
Applies to: √ Analytics Platform System (PDW)
Stores properties that describe a device. Some properties show device status and some properties describe the device itself.
public ITable<AzureSynapseAnalyticsSchema.HealthComponentProperty> HealthComponentProperties { get; }Property Value
HealthComponentStatusMappings
sys.pdw_health_component_status_mappings (Transact-SQL)
Applies to: √ Analytics Platform System (PDW)
Defines the mapping between the Microsoft Azure Synapse Analytics component statuses and the manufacturer-defined component names.
public ITable<AzureSynapseAnalyticsSchema.HealthComponentStatusMapping> HealthComponentStatusMappings { get; }Property Value
HealthComponents
sys.pdw_health_components (Transact-SQL)
Applies to: √ Analytics Platform System (PDW)
Stores information about all components and devices that exist in the system. These include hardware, storage devices, and network devices.
public ITable<AzureSynapseAnalyticsSchema.HealthComponent> HealthComponents { get; }Property Value
IndexMappings
sys.pdw_index_mappings (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Maps the logical indexes to the physical name used on Compute nodes as reflected by a unique combination of object_id of the table holding the index and the index_id of a particular index within that table.
public ITable<AzureSynapseAnalyticsSchema.IndexMapping> IndexMappings { get; }Property Value
LoaderBackupRunDetails
sys.pdw_loader_backup_run_details (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Contains further detailed information, beyond the information in sys.pdw_loader_backup_runs (Transact-SQL), about ongoing and completed backup and restore operations in Azure Synapse Analytics and about ongoing and completed backup, restore, and load operations in Analytics Platform System (PDW). The information persists across system restarts.
public ITable<AzureSynapseAnalyticsSchema.LoaderBackupRunDetail> LoaderBackupRunDetails { get; }Property Value
LoaderBackupRuns
sys.pdw_loader_backup_runs (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Contains information about ongoing and completed backup and restore operations in Azure Synapse Analytics, and about ongoing and completed backup, restore, and load operations in Analytics Platform System (PDW). The information persists across system restarts.
public ITable<AzureSynapseAnalyticsSchema.LoaderBackupRun> LoaderBackupRuns { get; }Property Value
LoaderRunStages
sys.pdw_loader_run_stages (Transact-SQL)
Applies to: √ Analytics Platform System (PDW)
Contains information about ongoing and completed load operations in Analytics Platform System (PDW). The information persists across system restarts.
public ITable<AzureSynapseAnalyticsSchema.LoaderRunStage> LoaderRunStages { get; }Property Value
MaterializedViewColumnDistributionProperties
sys.pdw_materialized_view_column_distribution_properties (Transact-SQL)
Applies to: √ Azure Synapse Analytics
Displays distribution information for columns in a materialized view.
See sys.pdw_materialized_view_column_distribution_properties.
public ITable<AzureSynapseAnalyticsSchema.MaterializedViewColumnDistributionProperty> MaterializedViewColumnDistributionProperties { get; }Property Value
MaterializedViewDistributionProperties
sys.pdw_materialized_view_distribution_properties (Transact-SQL) (preview)
Applies to: √ Azure Synapse Analytics
Displays distribution information materialized views.
public ITable<AzureSynapseAnalyticsSchema.MaterializedViewDistributionProperty> MaterializedViewDistributionProperties { get; }Property Value
MaterializedViewMappings
sys.pdw_materialized_view_mappings (Transact-SQL)
Applies to: √ Azure Synapse Analytics
Ties the materialized view to internal object names by object_id.
The columns physical_name and object_id form the key for this catalog view.
public ITable<AzureSynapseAnalyticsSchema.MaterializedViewMapping> MaterializedViewMappings { get; }Property Value
NodesColumnStoreDictionaries
sys.pdw_nodes_column_store_dictionaries (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Contains a row for each dictionary used in columnstore indexes. Dictionaries are used to encode some, but not all data types, therefore not all columns in a columnstore index have dictionaries. A dictionary can exist as a primary dictionary (for all segments) and possibly for other secondary dictionaries used for a subset of the column's segments.
public ITable<AzureSynapseAnalyticsSchema.NodesColumnStoreDictionary> NodesColumnStoreDictionaries { get; }Property Value
NodesColumnStoreRowGroups
sys.pdw_nodes_column_store_row_groups (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Provides clustered columnstore index information on a per-segment basis to help the administrator make system management decisions in Azure Synapse Analytics. sys.pdw_nodes_column_store_row_groups has a column for the total number of rows physically stored (including those marked as deleted) and a column for the number of rows marked as deleted. Use sys.pdw_nodes_column_store_row_groups to determine which row groups have a high percentage of deleted rows and should be rebuilt.
public ITable<AzureSynapseAnalyticsSchema.NodesColumnStoreRowGroup> NodesColumnStoreRowGroups { get; }Property Value
NodesColumnStoreSegments
sys.pdw_nodes_column_store_segments (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Contains a row for each column in a columnstore index.
public ITable<AzureSynapseAnalyticsSchema.NodesColumnStoreSegment> NodesColumnStoreSegments { get; }Property Value
NodesColumns
sys.pdw_nodes_columns (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Shows columns for user-defined tables and user-defined views.
public ITable<AzureSynapseAnalyticsSchema.NodesColumn> NodesColumns { get; }Property Value
NodesIndexes
sys.pdw_nodes_indexes (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Returns indexes for Azure Synapse Analytics.
public ITable<AzureSynapseAnalyticsSchema.NodesIndex> NodesIndexes { get; }Property Value
NodesPartitions
sys.pdw_nodes_partitions (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Contains a row for each partition of all the tables, and most types of indexes in a Azure Synapse Analytics database. All tables and indexes contain at least one partition, whether or not they are explicitly partitioned.
public ITable<AzureSynapseAnalyticsSchema.NodesPartition> NodesPartitions { get; }Property Value
NodesPhysicalDatabases
sys.pdw_nodes_pdw_physical_databases (Transact-SQL)
Applies to: √ Analytics Platform System (PDW)
Contains a row for each physical database on a compute node. Aggregate physical database information to get detailed information about databases. To combine information, join the sys.pdw_nodes_pdw_physical_databases to the sys.pdw_database_mappings and sys.databases tables.
public ITable<AzureSynapseAnalyticsSchema.NodesPhysicalDatabase> NodesPhysicalDatabases { get; }Property Value
NodesTables
sys.pdw_nodes_tables (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Contains a row for each table object that a principal either owns or on which the principal has been granted some permission.
See sys.pdw_nodes_tables.
public ITable<AzureSynapseAnalyticsSchema.NodesTable> NodesTables { get; }Property Value
PermanentTableMappings
sys.pdw_permanent_table_mappings (Transact-SQL)
Applies to: √ Azure Synapse Analytics
Ties permanent user tables to internal object names by object_id.
note
sys.pdw_permanent_table_mappings holds mappings to permanent tables and does not include temporary or external table mappings.
public ITable<AzureSynapseAnalyticsSchema.PermanentTableMapping> PermanentTableMappings { get; }Property Value
ReplicatedTableCacheStates
sys.pdw_replicated_table_cache_state (Transact-SQL)
Applies to: √ Azure Synapse Analytics
Returns the state of the cache associated with a replicated table by object_id.
public ITable<AzureSynapseAnalyticsSchema.ReplicatedTableCacheState> ReplicatedTableCacheStates { get; }Property Value
TableDistributionProperties
sys.pdw_table_distribution_properties (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Holds distribution information for tables.
public ITable<AzureSynapseAnalyticsSchema.TableDistributionProperty> TableDistributionProperties { get; }Property Value
TableMappings
sys.pdw_table_mappings (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Ties user tables to internal object names by object_id.
public ITable<AzureSynapseAnalyticsSchema.TableMapping> TableMappings { get; }Property Value
WorkloadManagementWorkloadClassifierDetails
sys.workload_management_workload_classifier_details (Transact-SQL)
Applies to: √ Azure Synapse Analytics
Returns details for each classifier.
public ITable<AzureSynapseAnalyticsSchema.WorkloadManagementWorkloadClassifierDetail> WorkloadManagementWorkloadClassifierDetails { get; }Property Value
WorkloadManagementWorkloadClassifiers
sys.workload_management_workload_classifiers (Transact-SQL)
Applies to: √ Azure Synapse Analytics
Returns details for workload classifiers.
public ITable<AzureSynapseAnalyticsSchema.WorkloadManagementWorkloadClassifier> WorkloadManagementWorkloadClassifiers { get; }