Reapit

Initial Load

← Back to Projects

Bronze

Overview
All 55 source tables are loaded from Snowflake into the Bronze Lakehouse via a single pipeline chain. CursorField in CONFIG.Processes controls the pagination behaviour per table.
CursorField Logic
ValueBehaviour
codePaginate by Reapit code field — alphanumeric, unique per table
_FIVETRAN_IDPaginate by Fivetran-generated Base64 unique string — tables with no natural primary key (e.g. JNL)
noneFull copy in one pass — no cursor filter or LIMIT applied; loop exits after first batch
Snowflake Connection IDs
Moved to the project-level Connections & GUIDs reference page (SAU and PP tables) — kept there alongside every other Reapit workspace / Lakehouse / Warehouse / Connection GUID so the initial-load page can stay focused on the load itself.
Table Inventory
All 55 source tables. ID = CONFIG.Processes ID. Each environment shows Date Loaded, Snowflake count (active rows, SynchDel = 0), Fabric count, and Status. Snowflake counts confirmed 29 Jun 2026 (SAU) and 4 Aug 2026 (PP). PRD counts for APP–AREAS confirmed 4 Aug 2026. Note: the PRD account (SS94622) names the source schema AURORA_SAV_RPS_SAV, not AURORA_SAU_RPS_SAU as in dev.
ID Table Source Schema Target Cursor Date Loaded Snowflake Fabric Status
SAU (AURORA_SAU_RPS_SAU → LANDING)
1APPAURORA_SAU_RPS_SAULANDINGnone 30 Jun 2026286,251286,251 Loaded
2APP_AAURORA_SAU_RPS_SAULANDINGcode 24 Jun 20263,535,7253,535,725 Loaded
3APPIMPAURORA_SAU_RPS_SAULANDINGnone 30 Jun 20263,169,2233,169,223 Loaded
4AREASAURORA_SAU_RPS_SAULANDINGcode 24 Jun 20263,7983,798 Loaded
48BANKSTATAURORA_SAU_RPS_SAULANDINGcode 24 Jun 2026321,387321,387 Loaded
49BANKSTAT_AAURORA_SAU_RPS_SAULANDINGcode 24 Jun 202600 Loaded
5CERTAURORA_SAU_RPS_SAULANDINGnone 24 Jun 2026333,843333,843 Loaded
6CNTAURORA_SAU_RPS_SAULANDINGnone 30 Jun 20263,602,4123,602,412 Loaded
7CNT_AAURORA_SAU_RPS_SAULANDINGnone 30 Jun 20261,072,3441,072,344 Loaded
8CONFIGSETTINGAURORA_SAU_RPS_SAULANDINGnone 30 Jun 20266,0216,021 Loaded
9DIARYAURORA_SAU_RPS_SAULANDINGcode 24 Jun 20263,057,4093,057,409 Loaded
10DIARY_AAURORA_SAU_RPS_SAULANDINGcode 24 Jun 20263,200,8073,200,807 Loaded
11EXTRAAURORA_SAU_RPS_SAULANDINGcode 24 Jun 20264,091,2424,091,216 Loaded
12EXTRA_AAURORA_SAU_RPS_SAULANDINGcode 24 Jun 20261111 Loaded
13FILEMANAURORA_SAU_RPS_SAULANDINGcode 24 Jun 202613,580,10413,580,097 Loaded
14IDCHECKAURORA_SAU_RPS_SAULANDINGcode 24 Jun 2026615,378615,378 Loaded
15INTLAURORA_SAU_RPS_SAULANDINGcode 24 Jun 2026422422 Loaded
16INVHEADAURORA_SAU_RPS_SAULANDINGcode 24 Jun 2026427,186427,186 Loaded
17JNLAURORA_SAU_RPS_SAULANDING_FIVETRAN_ID 1 Jul 202636,119,14136,119,141 Loaded
18LLDAURORA_SAU_RPS_SAULANDINGcode 24 Jun 2026190,043190,019 Loaded
19LLD_AAURORA_SAU_RPS_SAULANDINGcode 24 Jun 202600 Loaded
20LOOKUPAURORA_SAU_RPS_SAULANDINGcode 24 Jun 20263,029,4213,029,390 Loaded
21LOOKUP_AAURORA_SAU_RPS_SAULANDINGcode 30 Jun 20265,598,6125,598,612 Loaded
22MAILINGSAURORA_SAU_RPS_SAULANDINGcode 24 Jun 20261,830,3481,830,348 Loaded
23NEGSAURORA_SAU_RPS_SAULANDINGcode 24 Jun 20269,7549,754 Loaded
50NOMALLOCAURORA_SAU_RPS_SAULANDINGcode 24 Jun 20262,001,4382,001,438 Loaded
51NOMALLOC_AAURORA_SAU_RPS_SAULANDINGcode 30 Jun 202600 Loaded
24NOMTRANAURORA_SAU_RPS_SAULANDINGcode 24 Jun 20263,103,8093,103,809 Loaded
25NOMTRAN_AAURORA_SAU_RPS_SAULANDINGcode 24 Jun 202600 Loaded
26OFFERSAURORA_SAU_RPS_SAULANDINGcode 24 Jun 2026357,148357,147 Loaded
27OFFERS_AAURORA_SAU_RPS_SAULANDINGcode 30 Jun 2026377,568377,568 Loaded
28OFFICEAURORA_SAU_RPS_SAULANDINGcode 24 Jun 2026725725 Loaded
52PAIDAURORA_SAU_RPS_SAULANDINGcode 24 Jun 20267,3287,328 Loaded
53PAID_AAURORA_SAU_RPS_SAULANDINGcode 24 Jun 202600 Loaded
54PAYMENTSAURORA_SAU_RPS_SAULANDINGcode 30 Jun 2026754,791754,791 Loaded
55PAYMENTS_AAURORA_SAU_RPS_SAULANDINGcode 24 Jun 202600 Loaded
29PERMISSIONGRPAURORA_SAU_RPS_SAULANDINGcode 24 Jun 2026270270 Loaded
30PERMISSIONSETAURORA_SAU_RPS_SAULANDINGcode 24 Jun 2026396396 Loaded
31PICAURORA_SAU_RPS_SAULANDINGnone 30 Jun 20262,994,3462,994,346 Loaded
32PIC_AAURORA_SAU_RPS_SAULANDINGnone 30 Jun 20261,920,4011,920,401 Loaded
33PRPAURORA_SAU_RPS_SAULANDINGcode 30 Jun 2026549,993549,993 Loaded
34PRP_AAURORA_SAU_RPS_SAULANDINGcode 24 Jun 2026669,538669,538 Loaded
35REFERRALSAURORA_SAU_RPS_SAULANDINGcode 24 Jun 202651,84351,843 Loaded
36RENEWALSAURORA_SAU_RPS_SAULANDINGcode 24 Jun 202672,37972,379 Loaded
37SRCAURORA_SAU_RPS_SAULANDINGcode 30 Jun 20261,6781,678 Loaded
38TENAURORA_SAU_RPS_SAULANDINGcode 24 Jun 2026126,675126,672 Loaded
39TEN_AAURORA_SAU_RPS_SAULANDINGcode 24 Jun 202627,13027,130 Loaded
40TENEXTAURORA_SAU_RPS_SAULANDINGcode 24 Jun 2026493,132493,132 Loaded
41WORKFLOWAURORA_SAU_RPS_SAULANDINGcode 30 Jun 2026248248 Loaded
PP (AURORA_PRP_RPS_PRP → LANDING_PP)
42CNTAURORA_PRP_RPS_PRPLANDING_PPnone 4 Aug 202611,67411,674 Loaded
43CNT_AAURORA_PRP_RPS_PRPLANDING_PPnone 30 Jun 20262020 Loaded
44IDCHECKAURORA_PRP_RPS_PRPLANDING_PPnone 30 Jun 20261,8561,856 Loaded
45LOOKUPAURORA_PRP_RPS_PRPLANDING_PPnone 30 Jun 202641,24741,247 Loaded
46LOOKUP_AAURORA_PRP_RPS_PRPLANDING_PPnone 30 Jun 202623,43923,439 Loaded
47NEGSAURORA_PRP_RPS_PRPLANDING_PPnone 30 Jun 2026247247 Loaded

Silver

To be documented.

Gold

To be documented.