I have two questions 1. Regarding datawarehousing if at the end you want to report on Power BI what is the best practise can you use any of your query for reporting or is there any prequisite. 2. Is there a way to structure your views ? Like creating folder or what is the best practise here ? . This creating scripts in one folder can be overhwelming after 30-40 views.
How to Connect Azure Data Factory Self-hosted IR(for connecting Onpromise Database to Synapse) to Asure Synapse without Reinstall Microsoft Runtime Installation?
This is a good explanation. However why is this so important? I'd use CTAS/SELECT INTO rarely. Who essentially copies tables inside their database that much? CETAS I can understand because it does data virtualization but this... Can someone tell me some useful use cases?
You explain the process very clearly , kindly keep making this series. thank you for the videos.
Everything is cakewalk when you explain. Thanks Sir.
Welcome 😊
I have two questions
1. Regarding datawarehousing if at the end you want to report on Power BI what is the best practise can you use any of your query for reporting or is there any prequisite.
2. Is there a way to structure your views ? Like creating folder or what is the best practise here ? . This creating scripts in one folder can be overhwelming after 30-40 views.
Excellent Video, could you please advise how can we put the result of select statement into DataFrame?
thank you straight to the point
Thank you 😊
The best. Tks friend!
Thank you 😊
Sir can you make one video on Clustered column stored and non clustered column stored?
Awesome.. 👍
Thank you 😊
How to Connect Azure Data Factory Self-hosted IR(for connecting Onpromise Database to Synapse) to Asure Synapse without Reinstall Microsoft Runtime Installation?
plz continue this series
Hi everyone, why we can just use CTAS with a dedicated sql pool?
This is a good explanation. However why is this so important? I'd use CTAS/SELECT INTO rarely. Who essentially copies tables inside their database that much? CETAS I can understand because it does data virtualization but this... Can someone tell me some useful use cases?
if u want to create table in Dedicated SQL pool and load that table by fetching the data from external table ,CTAS would be usefull in this case