Pivot a DataFrame in Delta Live Table DLT

[Khalil]

I wanna apply a pivot on a dataframe in DLT but I'm having the following warning

Notebook:XXXX used `GroupedData.pivot` function that will be deprecated soon. Please fix the notebook.

I have the same warning if I use the the function collect.

Is it risky not to correct it.

[Khalil]

Thank you @Kaniz Fatma​  for that great answer. This can be a good workaround but the other issue I am facing is that collect function will be deprecated soon as well in Delta Live Table.

[Khalil]

Hi @Kaniz Fatma​ , I get your point; it might be risky to use toPandas as you said but as I need just to retrieve distinct values from a specific column of the dataframe so toPandas might be used in this case.

I will try this approch and let you know.

[Anonymous]

Hi @Ibrahima Fall​ 

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance! 

[Khalil · Accepted solution]

Thanks @Kaniz Fatma​  for your support.

The solution was to do the pivot outside of views or tables and the warning disappeared.