You are sharing layers from a cloud data warehouse as a map image layer to a federated server that is not the hosting server. Layers from cloud data warehouses must be published to the hosting server.
Share the web layer to the hosting server. On the General tab, under Location, click the Server and Folder drop-down menu and select the hosting server.
When publishing data from a cloud data warehouse as a map image layer, you can optionally create a snapshot of the data. Snapshots are stored in the relational data store on the hosting server. To learn more, see Configure a map image layer.
For more information, see Create a query layer for data in a cloud data warehouse and Analyze your GIS resource.