Reapit

Connections & GUIDs

← Back to Projects
Variable Library caveat: the SilverGold Variable Library currently has no environment overrides — all seven variables resolve to their DEV value in every workspace. The Bronze Variable Library has full overrides. Cells marked TBD mean the GUID hasn't been captured yet. Cells marked MISSING mean the value should exist but hasn't been added to the Variable Library valueSet yet.

Bronze Layer

Bronze Workspaces
Data Engineering workspaces hosting Bronze pipelines, notebooks, the OrchestrationDB warehouse and the Reapit_Bronze_DWH Lakehouse. Naming pattern: BI-Reapit-DataEngineering-{env} for lower envs; PRD has no suffix.
EnvWorkspace NameWorkspace GUID
DEVBI-Reapit-DataEngineering-DEV68b13123-6c5d-4927-97d9-0aff13d05a35
QABI-Reapit-DataEngineering-QA9079ffc8-9b68-4d92-806b-5fe51615bd77
UATBI-Reapit-DataEngineering-UAT6f386b5c-3f54-41b9-952f-9078697b3238
PRDBI-Reapit-DataEngineering322bf379-0c9a-4729-9f4e-807d1026b2c5
Reapit_Bronze_DWH — Bronze Lakehouse
Landing target for all Bronze table copies from Snowflake. Same artefact name across all environments.
EnvArtefact NameLakehouse GUID (Power BI URL form)ArtefactId in JSON (byte-reversed form)
DEVReapit_Bronze_DWHe0fdcfbd-db3b-4c33-a0fa-988efc529d9cfc529d9c-988e-a0fa-4c33-db3be0fdcfbd
QAReapit_Bronze_DWHe571c455-c9ad-4a06-85a6-e82f04dbe61404dbe614-e82f-85a6-4a06-c9ade571c455
UATReapit_Bronze_DWH6c4665cb-747b-4669-9b44-a0f9467c14af467c14af-a0f9-9b44-4669-747b6c4665cb
PRDReapit_Bronze_DWHdf03d9e5-7cca-46aa-81d6-85a815dcdd9f15dcdd9f-85a8-81d6-46aa-7ccadf03d9e5
Source: Bronze/Reapit_Bronze_DWH.Lakehouse/.platform and Power BI Lakehouse URLs. See "Byte-reversed GUIDs" note at bottom of page.
OrchestrationDB — Bronze Warehouse
Holds CONFIG.Processes and related orchestration tables. Referenced from Bronze pipelines by artefact ID + endpoint per environment.
EnvArtefact NameWarehouse Artefact IDSQL Endpoint
DEVOrchestrationDBac9aca96-7d35-4476-b229-21216814932fbaxylf6cvtbunj4zfiqblwg2iu-emy3c2c5nqtutf6zbl7rhuc2gu.datawarehouse.fabric.microsoft.com
QAOrchestrationDBd7b770a7-a8b4-4ae7-ab0d-0f1aac6a5bc0baxylf6cvtbunj4zfiqblwg2iu-zd7xteditoje3adll7srmfn5o4.datawarehouse.fabric.microsoft.com
UATOrchestrationDBe2f8b492-9e97-4fdd-b808-9e1140ce95a6baxylf6cvtbunj4zfiqblwg2iu-lrvtq32uh64udfjpsb4gs6zsha.datawarehouse.fabric.microsoft.com
PRDOrchestrationDBc69c6dcc-f5e0-4425-bb4c-fb1e24a34cbabaxylf6cvtbunj4zfiqblwg2iu-phzswmu2bquuph2oqb6rajvsyu.datawarehouse.fabric.microsoft.com
Source: Bronze pipeline JSONs (DataWarehouse linkedService) and Bronze/Variable_Library.VariableLibrary/valueSets/.
Snowflake Source Connections
Bronze source. Two distinct Snowflake connections used depending on schema.
SAU (AURORA_SAU_RPS_SAU → LANDING) — env-aware
EnvWorkspace GUID (DataFactory)Snowflake Connection IDConnection Name
DEV68b13123-6c5d-4927-97d9-0aff13d05a35d3ee313a-11eb-429f-ab85-000f756cc65cconn-snowflakeendpoint-Reapit_Source-DEV
QA9079ffc8-9b68-4d92-806b-5fe51615bd77d3ee313a-11eb-429f-ab85-000f756cc65cconn-snowflakeendpoint-Reapit_Source-DEV
UAT6f386b5c-3f54-41b9-952f-9078697b3238d3ee313a-11eb-429f-ab85-000f756cc65cconn-snowflakeendpoint-Reapit_Source-DEV
PRD(else)86027bc6-eda4-469e-ba86-a6617cb5430aREAPIT_PROD
PP (AURORA_PRP_RPS_PRP → LANDING_PP) — fixed across envs
EnvSnowflake Connection IDConnection Name
ALLc42cf032-9e24-4618-9358-b3923aabe356REAPIT_PP
Source: pl_ETL_0001_DataRefresh_ReapitRaw.DataPipeline and pl_bronze_batch_load.DataPipeline connection expressions.
bronze_orchestration — Bronze Data Pipeline
Main orchestration pipeline in the Bronze workspace. Called from Silver notebooks to trigger Bronze ETL runs. Pipeline GUID is used as the pipelineId in the Fabric REST API trigger call.
EnvPipeline NamePipeline GUID
DEVbronze_orchestration5add1441-bb27-448e-a361-15d4f9aaa9af
QAbronze_orchestration80a74271-6450-4101-9494-1d69f0542e27
UATbronze_orchestration19e0fced-05c1-4ee1-950a-87efcf1cffef
PRDbronze_orchestration4975ade3-2cdb-4ef1-a762-7144c13a61d6
Source: Power BI URL — /groups/{workspaceGuid}/pipelines/{pipelineGuid}

Silver Layer

Silver / Gold Workspaces
One shared workspace per environment hosts both the Silver Lakehouse (Reapit_Silver_LH) and the Gold Warehouse (Reapit_Gold_WH). Naming pattern: BI-Reapit-GoldLayer-DataEngineering-{env} for lower envs; PRD has no suffix.
EnvWorkspace NameWorkspace GUID
DEVBI-Reapit-GoldLayer-DataEngineering-DEVfefcefd6-dc51-4907-93d7-cf8d33d34f57
QABI-Reapit-GoldLayer-DataEngineering-QA8312fb7d-a07d-4cce-ba52-d530e34d4fb9
UATBI-Reapit-GoldLayer-DataEngineering-UATaed50ec3-449c-4e99-9d61-159b55420fd6
PRDBI-Reapit-GoldLayer-DataEngineeringf9f5697e-085d-4b56-8c97-7156ffdc27b7
Reapit_Silver_LH — Silver Lakehouse
Silver layer target for cleaned/conformed data from Bronze. Same artefact name across all environments.
EnvArtefact NameLakehouse GUID (Power BI URL form)Logical ID (byte-reversed form)
DEVReapit_Silver_LH6afb6b4e-4171-4304-856b-30b812ef1d5e12ef1d5e-30b8-856b-4304-41716afb6b4e
QAReapit_Silver_LH9b452b27-9d83-4149-81dd-6410e18947a7TBD
UATReapit_Silver_LH2b8d53e6-b9ab-4179-80b8-ecb6838000b8TBD
PRDReapit_Silver_LHc087576f-8286-4ffe-8592-0b3df23b3469TBD
Source: SilverGold/Reapit_Silver_LH.Lakehouse/.platform (on working-silver branch) and Power BI Lakehouse URLs.

Gold Layer

Reapit_Gold_WH — Gold Warehouse
Business-ready aggregates. Hosted in the same Silver / Gold Workspace shown above. Case-insensitive collation to match Power BI semantic model behaviour.
EnvArtefact NameWarehouse GUID (URL form)Logical ID (byte-reversed form)SQL Endpoint
DEVReapit_Gold_WHTBD1fe7e8e7-dc36-a34d-4ba7-b93377b2a27cTBD
QAReapit_Gold_WHc000d3cb-9cd2-4e06-b54a-26b800095f5700095f57-26b8-b54a-4e06-9cd2c000d3cbTBD
UATReapit_Gold_WHfec5e35e-e816-47fc-8aa0-b0d624117be024117be0-b0d6-8aa0-47fc-e816fec5e35eTBD
PRDReapit_Gold_WHTBDTBDTBD
Source: SilverGold/Reapit_Gold_WH.Warehouse/.platform and Power BI Warehouse URLs.

Fabric Connections Cross-layer

Bronze Orchestration DW Connection
Fabric Connection object used by Silver / Gold notebooks to reach the Bronze OrchestrationDB warehouse. Distinct from the warehouse artefact itself.
EnvConnection GUID
DEV545e8d79-7287-4869-8e50-64930917bbf1
QA49b0c59f-de5a-4274-be95-884de2707c69
UATf4984960-e128-4f66-82cb-f4f956afa2d6
PRD8f9e0db4-da8e-46d0-81a9-1b072bbdbfcb
Source: SilverGold/Variable_Library.VariableLibrary/variables.json (variable Bronze_Orchestration_Connection_Guid).
Snowflake Environment (for Notebooks)
Fabric Environment artefact carrying Snowflake connection settings for Bronze deployment notebooks.
EnvEnvironment Logical ID
DEV3bd6e874-ba81-96d5-4842-622c637025b3
QATBD
UATTBD
PRDTBD
Source: Bronze/Environments/env_SnowflakeConnForNotebooks.Environment/.platform.

Variable Libraries Reference

Bronze Variable Library
Committed state of Bronze/Variable_Library.VariableLibrary/. Grouped by variable so gaps between envs are obvious.
Bronze_OrchestrationDB_Guid Guid
DEVac9aca96-7d35-4476-b229-21216814932f
QAd7b770a7-a8b4-4ae7-ab0d-0f1aac6a5bc0
UATe2f8b492-9e97-4fdd-b808-9e1140ce95a6
PRDc69c6dcc-f5e0-4425-bb4c-fb1e24a34cba
Silver_Workspace_Guid Guid
DEVfefcefd6-dc51-4907-93d7-cf8d33d34f57
QA8312fb7d-a07d-4cce-ba52-d530e34d4fb9
UATaed50ec3-449c-4e99-9d61-159b55420fd6
PRDf9f5697e-085d-4b56-8c97-7156ffdc27b7
Silver_Lakehouse_Guid Guid
DEV6afb6b4e-4171-4304-856b-30b812ef1d5e
QA9b452b27-9d83-4149-81dd-6410e18947a7
UAT2b8d53e6-b9ab-4179-80b8-ecb6838000b8
PRDc087576f-8286-4ffe-8592-0b3df23b3469
SilverGold Variable Library
Committed state of SilverGold/Variable_Library.VariableLibrary/. QA and UAT valueSets exist but are empty; PRD valueSet not present in repo. Every variable currently resolves to its DEV value across all envs — overrides marked MISSING below need populating.
Bronze_Workspace_Guid Guid
DEV68b13123-6c5d-4927-97d9-0aff13d05a35
QAMISSING   (should be 9079ffc8-9b68-4d92-806b-5fe51615bd77)
UATMISSING   (should be 6f386b5c-3f54-41b9-952f-9078697b3238)
PRDMISSING   (should be 322bf379-0c9a-4729-9f4e-807d1026b2c5)
Bronze_Lakehouse_Guid Guid
DEVe0fdcfbd-db3b-4c33-a0fa-988efc529d9c
QAMISSING   (should be e571c455-c9ad-4a06-85a6-e82f04dbe614)
UATMISSING   (should be 6c4665cb-747b-4669-9b44-a0f9467c14af)
PRDMISSING   (should be df03d9e5-7cca-46aa-81d6-85a815dcdd9f)
Orchestration_Guid Guid
DEVac9aca96-7d35-4476-b229-21216814932f
QAMISSING   (should be d7b770a7-a8b4-4ae7-ab0d-0f1aac6a5bc0)
UATMISSING   (should be e2f8b492-9e97-4fdd-b808-9e1140ce95a6)
PRDMISSING   (should be c69c6dcc-f5e0-4425-bb4c-fb1e24a34cba)
Bronze_Orchestration_Connection_Guid Guid
DEV545e8d79-7287-4869-8e50-64930917bbf1
QA49b0c59f-de5a-4274-be95-884de2707c69
UATf4984960-e128-4f66-82cb-f4f956afa2d6
PRD8f9e0db4-da8e-46d0-81a9-1b072bbdbfcb
Bronze_Orchestration_SQL_Endpoint String
DEVbaxylf6cvtbunj4zfiqblwg2iu-emy3c2c5nqtutf6zbl7rhuc2gu.datawarehouse.fabric.microsoft.com
QAMISSING   (should be baxylf6cvtbunj4zfiqblwg2iu-zd7xteditoje3adll7srmfn5o4.datawarehouse.fabric.microsoft.com)
UATMISSING   (should be baxylf6cvtbunj4zfiqblwg2iu-lrvtq32uh64udfjpsb4gs6zsha.datawarehouse.fabric.microsoft.com)
PRDMISSING   (should be baxylf6cvtbunj4zfiqblwg2iu-phzswmu2bquuph2oqb6rajvsyu.datawarehouse.fabric.microsoft.com)
Reapit_Silver_Workspace_GUID Guid
DEVfefcefd6-dc51-4907-93d7-cf8d33d34f57
QAMISSING   (should be 8312fb7d-a07d-4cce-ba52-d530e34d4fb9)
UATMISSING   (should be aed50ec3-449c-4e99-9d61-159b55420fd6)
PRDMISSING   (should be f9f5697e-085d-4b56-8c97-7156ffdc27b7)
Reapit_Silver_Lakehouse_GUID Guid
DEV6afb6b4e-4171-4304-856b-30b812ef1d5e
QAMISSING   (should be 9b452b27-9d83-4149-81dd-6410e18947a7)
UATMISSING   (should be 2b8d53e6-b9ab-4179-80b8-ecb6838000b8)
PRDMISSING   (should be c087576f-8286-4ffe-8592-0b3df23b3469)

Notes Reference

Byte-reversed GUIDs
Fabric represents the same underlying artefact GUID two ways depending on where it's serialised.
ContextExample
Power BI URL / UIe0fdcfbd-db3b-4c33-a0fa-988efc529d9c
Pipeline JSON artifactId / .platform logicalIdfc529d9c-988e-a0fa-4c33-db3be0fdcfbd
Both strings identify the same artefact. The JSON form has the GUID segments reordered to a byte-reversed layout. Fabric handles the conversion internally — you never need to convert by hand, but knowing both forms exist prevents confusion when cross-referencing a URL against a pipeline JSON or a .platform file.