V_QUERY_OLAPDATASOURCE_ETLHISTORY
The log of the ETL History for all Data Marts
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ETL history log ID | |
| ETLSTARTTIME | datetime | ETL start time | |
| ETLENDTIME | datetime | yes | ETL end time |
| COMPLETED | bit | Completed | |
| TOTALMINUTES | int | yes | Total refresh minutes |
| ETLCONTROLID | int | ETL control ID | |
| DATAWINDOWOPEN | datetime | yes | Data window open |
| DATAWINDOWCLOSE | datetime | yes | Data window close |
| SSISPACKAGENAME | nvarchar(255) | SSIS package name | |
| SSISMACHINENAME | nvarchar(500) | SSIS machine name | |
| SSISUSERNAME | nvarchar(500) | SSIS user name | |
| SSISEXECUTIONINSTANCEGUID | uniqueidentifier | SSIS execution ID | |
| ISPARENTPACKAGE | bit | Parent package | |
| OLAPDATASOURCEID | uniqueidentifier | OLAPDATASOURCEID | |
| OLAPDATASOURCENAME | nvarchar(255) | yes | Data Mart |
| ISFULLREFRESH | bit | yes | Full refresh |
| ISINCREMENTALREFRESH | bit | yes | Incremental refresh |
| NUMROWSADDED | bigint | ||
| NUMROWSUPDATED | bigint |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:52:19 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_OLAPDATASOURCE_ETLHISTORY AS
select
ID,
ETLSTARTTIME,
ETLENDTIME,
COMPLETED,
DATEDIFF(MINUTE,ETLSTARTTIME,ETLENDTIME) AS TOTALMINUTES,
ETLCONTROLID,
DATAWINDOWOPEN,
DATAWINDOWCLOSE,
SSISPACKAGENAME,
SSISMACHINENAME,
SSISUSERNAME,
SSISEXECUTIONINSTANCEGUID,
ISPARENT AS ISPARENTPACKAGE,
OLAPDATASOURCEID,
(SELECT SOURCENAME FROM dbo.OLAPDATASOURCE AS O WHERE O.ID=ETLHISTORY.OLAPDATASOURCEID) AS OLAPDATASOURCENAME,
CAST(CASE WHEN DATAWINDOWOPEN <= '1776-07-04' THEN 1 ELSE 0 END AS BIT) AS ISFULLREFRESH,
CAST(CASE WHEN DATAWINDOWOPEN > '1776-07-04' THEN 1 ELSE 0 END AS BIT) AS ISINCREMENTALREFRESH,
[NUMROWSADDED],
[NUMROWSUPDATED]
from dbo.ETLHISTORY