Table of Contents

Class AzureSynapseAnalyticsSchema.LoaderBackupRun

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

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.


See sys.pdw_loader_backup_runs.

[Table(Schema = "sys", Name = "pdw_loader_backup_runs", IsView = true)]
public class AzureSynapseAnalyticsSchema.LoaderBackupRun
Inheritance
AzureSynapseAnalyticsSchema.LoaderBackupRun
Extension Methods

Properties

Command

Full text of the command submitted by the user.
Range: Will be truncated if longer than 4000 characters (counting spaces).

[Column("command")]
[NotNull]
public string Command { get; set; }

Property Value

string

DatabaseName

Name of the database that is the context of this operation

[Column("database_name")]
[NotNull]
public string DatabaseName { get; set; }

Property Value

string

EndTime

Time the operation completed, failed, or was cancelled.

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

Property Value

DateTime

Mode

The mode within the run type.
Range: For operation_type = BACKUP
DIFFERENTIAL
FULL

For operation_type = LOAD
APPEND
RELOAD
UPSERT

For operation_type = RESTORE
DATABASE
HEADER_ONLY

[Column("mode")]
[NotNull]
public string Mode { get; set; }

Property Value

string

Name

Null for load. Optional name for backup or restore.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

OperationType

The load type.
Range: 'BACKUP', 'LOAD', 'RESTORE'

[Column("operation_type")]
[NotNull]
public string OperationType { get; set; }

Property Value

string

PrincipalID

ID of the user requesting the operation.

[Column("Principal_id")]
[NotNull]
public int PrincipalID { get; set; }

Property Value

int

Progress

Percentage completed.
Range: 0 to 100

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

Property Value

int

RequestID

ID of the request performing the operation. For loads, this is the current or last request associated with this load..
Range: See request_id in sys.dm_pdw_exec_requests (Transact-SQL).

[Column("request_id")]
[NotNull]
public string RequestID { get; set; }

Property Value

string

RowsInserted

Number of rows inserted into the database table(s) as part of this operation.

[Column("rows_inserted")]
[NotNull]
public long RowsInserted { get; set; }

Property Value

long

RowsProcessed

Number of rows processed as part of this operation.

[Column("rows_processed")]
[NotNull]
public long RowsProcessed { get; set; }

Property Value

long

RowsRejected

Number of rows rejected as part of this operation.

[Column("rows_rejected")]
[NotNull]
public long RowsRejected { get; set; }

Property Value

long

RunID

Unique identifier for a specific backup, restore, or load run.

Key for this view.

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

Property Value

int

SessionID

ID of the session performing the operation.
Range: See session_id in sys.dm_pdw_exec_sessions (Transact-SQL).

[Column("session_id")]
[NotNull]
public string SessionID { get; set; }

Property Value

string

StartTime

Time the operation started.

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

Property Value

DateTime

Status

Status of the run.
Range: 'CANCELLED','COMPLETED','FAILED','QUEUED','RUNNING'

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

Property Value

string

SubmitTime

Time the request was submitted.

[Column("submit_time")]
[NotNull]
public DateTime SubmitTime { get; set; }

Property Value

DateTime

TableName

Information not available.

[Column("table_name")]
[NotNull]
public string TableName { get; set; }

Property Value

string

TotalElapsedTime

Total time elapsed between start_time and current time, or between start_time and end_time for completed, cancelled, or failed runs.
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