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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Srisakthi,

    As you said, current it seems not support directly use t-sql model notebook.
    For this scenario, I'd like to suggest create a new common notebook to invoke in pipeline and enter the notebook and manually switch its mode to 't-sql'. (I test with this and it works normally)

    Regards,

    Xiaoxin Sheng