When writing a query in the Audience Builder please note table names must exactly match the format used in the data warehouse. Table naming format if slightly different for each of the supported data warehouses for which a Connection can be created in Cloud Connect. We recommend testing the query in the query editor of your data warehouse to ensure it works then copying and pasting into the Cloud Connect audience builder. This will ensure the query can be successfully run by Cloud Connect.