Class AzureSynapseAnalyticsSchema.LoaderRunStage

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

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.

See sys.pdw_loader_run_stages.

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

Inheritance

object

AzureSynapseAnalyticsSchema.LoaderRunStage

Extension Methods

Map.DeepCopy<T>(T)

Properties

EndTime

Time at which the stage ended, if any.
Range: NULL if not started or in progress.

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

Property Value

DateTime

RequestID

ID of the request running this stage.

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

Property Value

string

RunID

Unique identifier of a loader run.

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

Property Value

int

Stage

The current stage for the run.
Range: 'CREATE_STAGING', 'DMS_LOAD', 'LOAD_INSERT', 'LOAD_CLEANUP'

[Column("stage")]
[NotNull]
public string Stage { get; set; }

Property Value

string

StartTime

Time at which the stage was started.

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

Property Value

DateTime

Status

Status of this phase.

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

Property Value

string

TotalElapsedTime

Total time this stage spent (or spent so far) running.
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