What would cause this query to report the following error: "An error occurred while checking the query syntax. Errors: MemberData is not a known data extension or system data view. You can only query existing data extensions or system data view

Northern Trail Outfitters' account is configured with two child BU(s): US and Global. The account has a data extension In the Shared Data Extensions folder named 'MemberData'. This data extension contains basic address information, as well as Boolean fields labeled 'US' and 'Global'indicating to which business unit the subscriber belongs. Automation needs to be created in the US business unit to query all records in New York who are members of the business unit US.

SELECT * FROM MemberData WHERE State = 'NY' AND US = 1

What would cause this query to report the following error: "An error occurred while checking the query syntax. Errors: MemberData is not a known data extension or system data view. You can only query existing data extensions or system data views."?

Show Answer Hide Answer