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

  • 21 November 2023
  • 2 replies


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

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


Best answer by Ethem Q 30 November 2023, 23:17

View original

2 replies

Userlevel 5

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 retrieving connection information? If that is what you are looking for, note that 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.

Userlevel 5

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 feel free to reach our support team out at or submit a support ticket here