Regarding YQL, I found this github repo - https://github.com/yql/yql-tables that seem to describe some of the external tables that used to be available through YQL.