KedroDatasets pandas.GBQTableDataset upgrade to pandas-gbq

[janickspirig]

Description

The pandas.GBQTableDataset uses currently pd.to_gbq() to write a DataFrame to GBQ. However this method is deprecated. As the method is deprecated warnings are raised. I suggest upgrading the dataset to use pandas_gbq.to_gbq() instead.

Your Environment

• Kedro version used (pip show kedro or kedro -V): 0.19.8
• Python version used (python -V): 3.11.9
• Operating system and version: MacOS

[noklam]

@janickspirig Are you interested to open a PR? If so, go ahead!

[janickspirig]

Sure, will do on the weekend