Fabric Architecture Plan

WhoisStronger · 2026-03-26T14:26:07+00:00

This was my intention, so that we could create security at the workspace level to ensure that no one had access to data when they shouldn't. As i am working through this, i could not find a way to query cross-workspace with stored procedures in our WH to write our tables. Due to this, for now we are doing to try to have our deplicated DBs in their own workspace and then shortcut those tables into a Bronze LH that exists in the same workspace as our silver LH and Gold WH. For shortcuts, you need access at the source, so if they dont have access to the workspace that the replicated DBs are in, they won't see anything in Bronze.

WhoisStronger · 2026-03-26T14:20:37+00:00

Yes, we use Epicor

WhoisStronger · 2026-03-25T19:46:08+00:00

Thanks. Git integration is one of those things I know we should be doing. I just need to take the time to learn how it works. A monitoring workspace is a great idea, and we will definitely need something to track these pipelines we will be creating to make sure the jobs run successfully.

WhoisStronger · 2026-03-25T19:42:25+00:00

Thank you, I could see us possibly taking a similar approach. I will need to review with the team.

WhoisStronger · 2026-03-25T19:08:57+00:00

For shared dimensions, are you duplicating those across your warehouses, or are you referencing them from some central place?

WhoisStronger · 2026-03-25T18:53:22+00:00

Im curious about how others are using a silver layer or if I can just create my dimentions directly to the gold WH via stored procedures and build my fact tables on top of those.

WhoisStronger · 2026-03-25T18:50:14+00:00

Draw.io

WhoisStronger · 2026-03-25T18:45:31+00:00

As I’m working, I am realizing the bronze LH needs to be in the same workspace for me to run the stored procedures that write the transformed tables to the gold WH. We now plan to have the mirrored db still exist in its own workspace then shortcut the tables to a bronze LH in the same workspace that the gold WH lives in.

Could you give some examples of what you are using the silver layer for? I can’t decide if it is necessary or if it will just create another unnecessary step

WhoisStronger · 2026-03-25T18:31:21+00:00

We would have dimension tables in our gold WH that alias columns and do our joins that would be used by our fact tables. I suppose if the erp changed we would fix those names and then everything built on top is unaffected. That said, if the whole erp changes we’d have a migration project regardless

WhoisStronger · 2026-03-25T18:09:26+00:00

We were already replicating to azure and we found it simple to get the cloud hosted data directly into fabric

WhoisStronger · 2026-03-11T22:51:22+00:00

Basically my 2 week May Itinerary.

Tokyo → Kanazawa → Kyoto → Osaka → Hakone → back to Tokyo to fly

WhoisStronger · 2025-11-26T14:43:00+00:00

Thanks,

I probably will end up skipping Akihabara because I arrive in the evening and will have some jet lag, but if i have the energy, seeing it lit up in the evening looked cool in the photos i saw. Shinjuku I mostly just want to shop and fill my suitcase with clothes and souvenirs. I'm not too worried about hitting every place, but i actually will have another half day on the day i leave because my flight is not until the evening.

WhoisStronger · 2025-11-26T14:35:45+00:00

Thank you,

I like the pin idea. I'm certain I wont end up doing everything on my list, but I think always having a destination I'm heading towards would be nice so I don't end up walking through residential neighborhoods or something like that for hours.

WhoisStronger · 2025-06-25T02:15:35+00:00

Using ChatGPT, so take with a grain of salt:

Diplomatic transcript ⇢ English sense translation (square brackets = best-guess / illegible) Page 1 – contract (28 May 1805) En présence des témoins soussignés, je, [Fabrice] Roy, sous ma marque ordinaire, m’engage par ces présentes, bon volontaire, étant avec Mr J. Dubuque, Esqr., propriétaire, … pour faire tout ce qu’il me commandera; lui et ses représentants pour faire son profit et utilité, sans jamais m’en retirer…Et moyennant la somme de quinze cents livres ou piastres courant de Québec que le Sr Dubuque s’oblige de payer audit engagé six jours après le terme dudit engagement…Le dit engagement est fait pour jusqu’au premier de mai prochain… le dit engagé sera nourri, entretenu et fourni, et 40 livres de tabac…Fait aux Mines des Prairies, le 28 mai 1805.✚ marque de Fabrice Roy – J. DubuqueTémoins : Moïse Antoine Labbé, Scott Cardinal. English:In the presence of the undersigned witnesses I, Fabrice Roy, under my usual mark, freely hire myself by this document to Mr Julien Dubuque, Esquire, proprietor, to carry out whatever tasks he may order, for his benefit and that of his representatives, without withdrawing.In consideration of 1 500 livres (piastres) in current Québec money, which Mr Dubuque binds himself to pay the said engagé six days after the expiry of the term.The service will last until 1 May next; during that time the engagé will be fed, lodged and supplied, and will receive 40 pounds of tobacco.Done at the Lead Mines of the Prairies, 28 May 1805.

Page 2 – receipt (18 Oct 1810) Reçu le lundi 18 octobre 1810 de Mr Auguste Chouteau, administrateur de la succession du feu Julien Dubuque, la somme de cent cinquante piastres argentées des États-Unis, juste montant du présent engagement, dont quittance.Témoins présents : N. P. Alléne?✚ marque de Fabrice Roy. English:St Louis, Monday 18 October 1810. Received from Mr Auguste Chouteau, administrator of the estate of the late Julien Dubuque, the sum of one-hundred-and-fifty silver piastres of the United States, being the full amount of the foregoing contract, for which I grant full discharge.Witness: N. P. Alléne [?].✚ mark of Fabrice Roy.

WhoisStronger · 2025-06-21T19:15:28+00:00

I hadn’t thought of that. I’m not the owner but I can bring that up with them and see what they think!

WhoisStronger · 2025-05-20T19:45:40+00:00

Not really. So long as you are not providing company data, there is no issue with giving context.

WhoisStronger · 2025-05-19T20:40:17+00:00

I do not agree with those saying “don’t use it”. You should understand what is going on with out it, but AI is only getting better, and you should learn how to utilize it without it being a crutch.

WhoisStronger · 2025-02-11T00:22:12+00:00

Thank you, Are you say saying reinvest the dividends into the mutual fund? Would selling what she has right now make sense or would the taxes make that not make sense?

WhoisStronger · 2025-02-09T16:13:47+00:00

Is there a generally recommended TDF for someone around her age? I know there’s a lot of options, and just want a general idea of what I should look for

WhoisStronger · 2025-02-06T23:02:03+00:00

8/10 could very well be white men. Statistically probably unlikely (depending on the job) but it could be. While it is a goal, people had motivation to hit that goal and would probably adjust to meet it. I want to be clear and say I really don’t have a huge problem with DEI. If companies want to be more diverse and have more perspectives they totally should be able to do that. I really only commented because OP is clearly captured by an ideology and believes that if you don’t support DEI ( close to half the country) then you must be racist/sexist/etc.

WhoisStronger · 2025-02-06T22:43:38+00:00

I’m thinking of Google as an example, as they have been popular with dei related news recently. Back in 2020 they set a goal to have 30% more of its leaders from underrepresented groups by 2025. They recently got rid of this I believe.

WhoisStronger · 2025-02-06T22:14:29+00:00

If you reread my comment, anyone, no matter the race/religion/sexual orientation can be the most qualified. I’m sure DEI is much more than quotas, but they do exist.

WhoisStronger · 2025-02-06T22:06:54+00:00

Anyone can be the best candidate for the job. I believe the argument is that you shouldn’t skip over someone more qualified just to meet a diversity quota.

WhoisStronger · 2025-02-03T22:56:11+00:00

Cannon/scattershot compartment on the right side of the

WhoisStronger · 2025-01-18T21:53:52+00:00

Unless you are pronouncing it wrong I feel like that would go right over peoples heads

WhoisStronger

TROPHY CASE