# Python connector for google drive errors out when selecting from one of the system tables

**URL:** <https://community.cdata.com/t/python-connector-for-google-drive-errors-out-when-selecting-from-one-of-the-system-tables/532>\
**Category:** CData Drivers\
**Tags:** question, python\
**Created:** [November 21, 2023, 6:01am UTC](https://community.cdata.com/t/python-connector-for-google-drive-errors-out-when-selecting-from-one-of-the-system-tables/532 "2023-11-21T06:01:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![OP\_Tester](https://avatars.discourse-cdn.com/v4/letter/o/2acd7d/32.png) [@OP\_Tester](https://community.cdata.com/u/OP_Tester)\
**Post date:** [November 21, 2023, 6:01am UTC](https://community.cdata.com/t/python-connector-for-google-drive-errors-out-when-selecting-from-one-of-the-system-tables/532/1 "2023-11-21T06:01:14Z")

</div>

It is failing with an error that is not very descriptive when a query like SELECT \* FROM sys\_connection\_hierarchy is executed in Python

 ![5e5a0169-d029-427e-aae5-1b74dbd06c64.png](https://us1.discourse-cdn.com/cdata/original/1X/1f41de7b9a37c871cf5158f50cb0a75f599b20d9.png)

The same query works fine in JDBC. Can you please advise?

---

<div class="post-metadata">

**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\
**Post date:** [November 22, 2023, 11:02pm UTC](https://community.cdata.com/t/python-connector-for-google-drive-errors-out-when-selecting-from-one-of-the-system-tables/532/2 "2023-11-22T23:02:11Z")

</div>

This system table is an internal CData table and there is not much information available for this to the public. That said, is there a reason why you need to query the _sys\_connection\_hierarchy_ system table? Are you using it for&nbsp;retrieving connection information? If that is what you are looking for, note that&nbsp;you can also make use of the _sys\_connection\_props_ table.

On a side note, a similar issue is reproducible on our end so a ticket has been opened with the development team. Thank you for reporting this.

You will be notified as soon as there is an update.

---

<div class="post-metadata">

**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\
**Post date:** [November 30, 2023, 10:17pm UTC](https://community.cdata.com/t/python-connector-for-google-drive-errors-out-when-selecting-from-one-of-the-system-tables/532/3 "2023-11-30T22:17:29Z")

</div>

The engineering team has implemented a fix for the issue that was reported here.

If you want to get an updated version of the Python Connector for GoogleDrive with the hotfix&nbsp;feel free to reach our support team out at [support@cdata.com](mailto:support@cdata.com) or submit a support ticket here [https://www.cdata.com/support/submit.aspx](https://www.cdata.com/support/submit.aspx)
