https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Limited-access-to-the-table-contents-i...
Please follow above link...
We are seeing a huge requests from users to support this feature...
Till 2019.4 version, Alteryx can't connect to a table if complete read access is NOT granted to it....
Other DataConnector tools des this action except Alteryx...
Please consider this as a Feature Request ..