Q: 8
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."?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
