This is a query for the data warehouse, I probably should have mentioned that. dim_asset_tag is a table that provides the link between a tag_id and an asset_id. Based on your error, you are trying to run this query in the console, which will not work. The table that is similar to the warehouse dim_asset_tag is dim_tag_asset in the console.