Skip to main content

Data Warehouse Console

An ETL management dashboard.

While Compass — the Data Warehouse Console's companion tool — is available to many users, the Data Warehouse Console is accessible only by designated administrators, who typically perform functions similar to a system administrator.

The Data Warehouse Console dashboard clearly shows malfunctions and errors, pointing out where administrators need to take corrective action.

Configure batches​

Administrators easily and efficiently:

  • See all sources brought into the data warehouse
  • Create, view, modify, and remove the batch definitions of each source system
  • Search and filter batch definitions
  • Drill into various packages

Execute ETL tasks​

  • Create, schedule, run, and cancel batches
  • Launch and relaunch ETL tasks
  • Check the status of execution processes

Monitor the health of the data warehouse​

  • View batch and table load history
  • Access detailed logging tables
  • See error messages when loads fail
  • Correct error conditions

Interface​

Data Warehouse Console dashboardAn ETL operations dashboard with three stat cards - 1 running, 12 succeeded today, 1 failed - a batch history filter toolbar, and a table of recent batches for AdventureWorks, each with a load type, a color-coded status (processing, succeeded, or failed), a start time, a duration, and a Details or Cancel action.Data Warehouse ConsoleCatalogConsoleData WarehouseIntake Marts1Running12Succeeded today1FailedBatch historyTodayAnySearch batches…Intake martBatchLoad typeStatusStart timeDurationAdventureWorksAll tablesCustomProcessingToday, 3:53 PM—CancelAdventureWorksAll tablesCustomSucceededToday, 3:30 PM3m 38sDetailsAdventureWorksPerson onlyIncrementalSucceededToday, 2:15 PM1m 12sDetailsAdventureWorksClaimsIncrementalFailedToday, 1:05 PM0m 45sDetailsShowing 1 to 4 of 4 entries