Forum Discussion

Srisakthi's avatar
Srisakthi
Super User
1 year ago
Solved

When to use T-SQL notebook

Hello All,   Can you please suggest on what scenario i should consider using T-SQL notebooks for transformations. 1. I have to use only If I have warehouse tables and i need to do transformations ...
Warehouse
  • AndyDDC's avatar
    AndyDDC
    1 year ago

    Hi Srisakthi IMHO T-SQL support in Notebooks is really for adhoc SELECT analysis over the Lakehouse SQL Endpoint.  I would not look do do any ETL/ELT code in Notebooks.

     

    So for me, I use it for analysis of data, not for loading/engineering (Lakehouse SQL Endpoint is read only, cannot write data using T-SQL).

     

    Hope that helps.

Srisakthi's avatar
Srisakthi
Super User
1 year ago

Hi Anonymous ,

 

Thanks for your response. What I'm looking for is in which Scenario I should be using T-SQL notebooks. Because in data pipeline there is no option for T-SQL notebooks. T-SQL notebook to be used for manual analysis and has to be ran manually, no automation for this ?

 

Regards,

Srisakthi

AndyDDC's avatar
AndyDDC
Most Valuable Professional
1 year ago

Hi Srisakthi IMHO T-SQL support in Notebooks is really for adhoc SELECT analysis over the Lakehouse SQL Endpoint.  I would not look do do any ETL/ELT code in Notebooks.

 

So for me, I use it for analysis of data, not for loading/engineering (Lakehouse SQL Endpoint is read only, cannot write data using T-SQL).

 

Hope that helps.