What I was trying to do:
read the path variable in Accounts_Routes table from big query
What I expected to happen:
having a path like other tables
What actually happened:
the path is path variable of the subcollections.