Class AzureSynapseAnalyticsSchema.LoaderBackupRunDetail

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

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.

See sys.pdw_loader_backup_run_details.

[Table(Schema = "sys", Name = "pdw_loader_backup_run_details", IsView = true)]
public class AzureSynapseAnalyticsSchema.LoaderBackupRunDetail

Inheritance

object

AzureSynapseAnalyticsSchema.LoaderBackupRunDetail

Extension Methods

Map.DeepCopy<T>(T)

Properties

EndTime

Time at which the operation ended on this particular node, if any.

[Column("end_time")]
[NotNull]
public DateTime EndTime { get; set; }

Property Value

DateTime

PdwNodeID

Unique identifier of an appliance node for which this record holds details.

run_id and pdw_node_id form the key for this view.
Range: See node_id in sys.dm_pdw_nodes (Transact-SQL).

[Column("pdw_node_id")]
[NotNull]
public int PdwNodeID { get; set; }

Property Value

int

Progress

Progress of the operation expressed as a percentage.
Range: 0 to 100

[Column("progress")]
[NotNull]
public int Progress { get; set; }

Property Value

int

RunID

Unique identifier for a specific backup or restore run.

run_id and pdw_node_id form the key for this view.

[Column("run_id")]
[NotNull]
public int RunID { get; set; }

Property Value

int

StartTime

Time at which the operation started on this particular node.

[Column("start_time")]
[NotNull]
public DateTime StartTime { get; set; }

Property Value

DateTime

Status

The current status of the run.
Range: 'CANCELLED', 'COMPLETED', 'FAILED', 'QUEUED', 'RUNNING'

[Column("status")]
[NotNull]
public string Status { get; set; }

Property Value

string

TotalElapsedTime

Total time the operation has been running on this particular node.
Range: If total_elapsed_time exceeds the maximum value for an integer (24.8 days in milliseconds), it will cause materialization failure due to overflow.

The maximum value in milliseconds is equivalent to 24.8 days.

[Column("total_elapsed_time")]
[NotNull]
public int TotalElapsedTime { get; set; }

Property Value

int