When the DBIDIRECTEXEC system option is enabled (default), any time that you call the CREATE VIEW clause in SQL code, a FedSQL view is created. A FedSQL view is stored in a DBMS table that has the same name as the FedSQL view. Although you can access the data in a FedSQL view from within SAS, the data in the DBMS table that represents the FedSQL view cannot be read by any other tool.
To generate a DBMS view that can be read, use explicit SQL pass-through with PROC SQL by using Google BigQuery syntax. An explicit SQL pass-through connection uses the CONNECT statement from PROC SQL. For more information, see Explicit SQL Pass-Through.