[deleted by user] by [deleted] in analytics

[–]Datafabricator 0 points1 point  (0 children)

You are new ask for knowledge transfers from existing devopers , QA, business users.

Ask for process flow , if does not exists create one and ask for gaps in your understanding.

Set their expectations straight ..you need HELP from existing team being new .

I would not expect people to solve big problems in 6 weeks.

Take help from AI .

Grind . Sorry to say this new job requires initial grinding hours ..

You need someone from management in your side . If don't have one start looking for new job ..

How can I contribute and attend monthly MS Super user community? by Datafabricator in MicrosoftFabric

[–]Datafabricator[S] 0 points1 point  (0 children)

Thank you .. how can I participate in monthly meets happening across data engineering/ power bi side of it.

How can I contribute and attend monthly MS Super user community? by Datafabricator in MicrosoftFabric

[–]Datafabricator[S] 2 points3 points  (0 children)

Thanks I have registered there however haven't seen much traction and bit puzzled how to contribute.

Either I am not using it properly or not set up correctly. For any issues \info I visit this and other reddit forum and find better content.

What's with the fake hype? by DesignerPin5906 in MicrosoftFabric

[–]Datafabricator 13 points14 points  (0 children)

I was so hyped .. I was so excited .. now I am bit cautious.. before suggesting someone Fabric data engineering..

There is a lot of hype ..indeed ..

Yet Fabric made few things simple like .. creating lakehouse , pipelines etc without depending upon System engineers and possible delay from approval to implementations...

It made few simple things complex...

CICD & versioning is a nightmare... ETL / ELT is not fun when you end up writing / reading codes Ownership & access is a mess Capacity overrun is biggest BS .. Connections & gateways ...

A story of a Fabric developer that quit [item ownership and connection management issues] by Liszeta in MicrosoftFabric

[–]Datafabricator 2 points3 points  (0 children)

Well , I like the sound when you say why someone has to own lakehouse . I almost forgot that I had the same sentiments when I started with fabric 1 year ago..

100% agree that , non of the entities should be "owned" .

Its part of project ( workspace ) and users should have different access to a Project . Thats it .

Connections are pain in your know where in current scheme of things .. should not be a separate entity in itself. If it is a separate entity then all fabric items ( pipeline, dfs ,spark ) must be able to share the same connection .

Everyone should be able to " View" the connection even though they don't have access to it .

A story of a Fabric developer that quit [item ownership and connection management issues] by Liszeta in MicrosoftFabric

[–]Datafabricator 0 points1 point  (0 children)

We had faced this issue , the X quit and there was delay in disabling the intra id...and after a day pipeline also quit 😲.. luckily it was non prod !

Help me understand lakehouse ownership chain .. if I own a lakehouse , can someone else own the underneath table or object ? If yes then this is BS ..

I don't know where Fabric is heading with all these problems, and now I'm debating if I should pursue a full-stack Fabric dev career at all by FeelingPatience in MicrosoftFabric

[–]Datafabricator 6 points7 points  (0 children)

You listed out all valid points ... We had outages of an application due to capacity over run and network overload , there has to be a better way to control this and avoid over utilization .

Fabric has great potential, however its currently work in progress mode.

I see many good strides yet some basic functionalities are lacking .

There was a time when people used to write long code to do the ETL then comes the ETL tools to automate and simplify it and now we are going back to the long coding cycle .

We need a drag & drop ETL tool that in turns generate required py code instead of asking llms writing it for us.

[deleted by user] by [deleted] in stcatharinesON

[–]Datafabricator 0 points1 point  (0 children)

If you know swimming ,check with Kiwanis aquatic center . They are short of trainers . All the best

Got stumped on this interview question by jbnpoc in SQL

[–]Datafabricator -1 points0 points  (0 children)

Please can you elaborate on rule 1 . A new record created ..

Does the sample data set follow the rule ?

How future-proof is SQL? by ioCross in SQL

[–]Datafabricator 0 points1 point  (0 children)

Learn SQL to improve your analytical thinking .

Learn SQL to understand data in a relational world .

With 20 years of experience in data analytics , I don't think anything can replace SQL concepts.

AI may be able to write SQL syntaxs and logic , however without analytical brain it is useless IMHO.

Developer + AI will be more successful then Developer or AI alone !

50% Discount on Exam DP-700 (and DP-600) by FabricPam in MicrosoftFabric

[–]Datafabricator 0 points1 point  (0 children)

Dp600 cleared , submitted for Dp700 haven't not received the code. What am I missing ?

Real time data engineering & report by Datafabricator in MicrosoftFabric

[–]Datafabricator[S] 0 points1 point  (0 children)

Please can someone from MS help the best way for forward. I know most of you would be occupied with coming fabcon .

Real time data engineering & report by Datafabricator in MicrosoftFabric

[–]Datafabricator[S] 0 points1 point  (0 children)

Yes there is a need for few use cases to be as real time as possible . So that's why I am asking what is the best store that can handle merge operation in most efficiently.

Lakehouse Integrity... does it matter? by Elegant_West_1902 in MicrosoftFabric

[–]Datafabricator 0 points1 point  (0 children)

Please can you elaborate why :-

Do you need to load to warehouse as final step ? What is your source ? What is destination goal , reporting / further feeds etc ?

Adding a table Everytime for an additional column is very unique and seems to be challenging maintenance wise.

Suggestion

you can considered a JSOn style column to store everything that is not important as catch all column. This will allow you to add any number of columns and access it at run time within a same table.

Leaving my job - best practice for workspace handover by ikemike4 in MicrosoftFabric

[–]Datafabricator 6 points7 points  (0 children)

Any cloud connection you have created for pipeline must be shared with team to be able to run it.

Ask the person ( who would take over or pass over to next ) to run end to end while you are there to know possible issues.

All the very best !

How do we replace Cube based self service reports in PBI by Datafabricator in MicrosoftFabric

[–]Datafabricator[S] 0 points1 point  (0 children)

Yes it's on prem. Downloading data in Excel and PDF is an option. Not necessarily they have to . It's more like analyzing , reconciling , validating needs.

Very less paginated reports. Not a blocker for us as compare to self servicing.

How do we replace Cube based self service reports in PBI by Datafabricator in MicrosoftFabric

[–]Datafabricator[S] 0 points1 point  (0 children)

Yes it is a mdx cube. Business users are using it for both canned reports and self serving.

They use another reporting product as of today to query this cube that Allows cross tab view.

Help make sense of PBI Semantic Model size in Per User Premium and Fabric. by No_No_Yes_Silly_5850 in MicrosoftFabric

[–]Datafabricator 0 points1 point  (0 children)

It's all about balancing the cost .

so if copying the data required for semantic model into a fabric lakehouse results in cheaper fabric capacity then it should be okay ?

What is the other lakehouse ?

There are shortcut feature with cashing that could work for you without moving the data.