21. Administrative accounts in Synapse SQL in Azure Synapse Analytics

[@deepak0417]

Thank you for continuing the series.

[@WafaStudies]

Welcome 🤗

[@annukumari9629]

Thankyou! Got a lot of clarity on this 😊

[@WafaStudies]

Welcome 🤗

[@ranjansrivastava9256]

Hi @wafaStudies, Could you please share your thoughts on the question:- Where do the metadata store once we create external table or select top 100 rows on the file which are located on the blob storage in synapse analytics. How it happens behind the scene. This is the interview question.

[@nitinjoshi4372]

Hi Sir, I have a problem statement in which I have to use an excel file, use a stored procedure to pivot the rows and save the file in csv or parquet for further use in Power BI. This all should be done using Azure Synapse. Please guide me how can I do this.?

[@lakshmikanthparvathapuram1250]

Thanks alot for your wonderful explanation..could you please create a video on how to connect to the Azure Synapse from Power BI..and how can we access the tables or ADLS gen2 from Azure Synapse to Power BI.

[@WafaStudies]

Sure i will plan for it

[@lakshmikanthparvathapuram1250]

Thanks Maheer 👍

[@RawandReal85]

Thanks

[@sonamkori8169]

Thank You..

[@WafaStudies]

Welcome

[@RawandReal85]

Thanks

[@WafaStudies]

Welcome 🤗