https://community.esri.com/t5/arcgis-enterprise-questions/join-hosted-feature-layer-to-table-inregistered/m-p/1270052#M35446 <P>Hello,</P><P>&nbsp;</P><P>I am trying to set up a web map for users to interact with that has a hosted feature layer joined to a table that is housed in a SQL database that is registered. This table gets updated daily and I am trying to get these updates to show up in the symbology of the hosted feature layer.</P><P>I am able to get the table added to the web map by publishing it in a map image layer, but I am getting an invalid URL error when trying to add the join between my map image table and the hosted feature layer when publishing as a view (I believe using the current map extent will create an independent feature layer that won't update as the source SQL table updates).&nbsp;</P><P>Here is the join features docs that I referenced. Seems like both layers need to be hosted feature layers to create the view:&nbsp;<A href="https://enterprise.arcgis.com/en/portal/latest/use/join-features.htm" target="_blank">Join Features—Portal for ArcGIS | Documentation for ArcGIS Enterprise</A></P><P>Is it possible to join a hosted feature layer to a SQL table and present the result of that in a web map in a format that it will be live?</P><P>&nbsp;</P><P>Thanks,&nbsp;</P> Tue, 21 Mar 2023 19:56:14 GMT mattkramer 2023-03-21T19:56:14Z https://community.esri.com/t5/arcgis-enterprise-questions/join-hosted-feature-layer-to-table-inregistered/m-p/1270052#M35446 <P>Hello,</P><P>&nbsp;</P><P>I am trying to set up a web map for users to interact with that has a hosted feature layer joined to a table that is housed in a SQL database that is registered. This table gets updated daily and I am trying to get these updates to show up in the symbology of the hosted feature layer.</P><P>I am able to get the table added to the web map by publishing it in a map image layer, but I am getting an invalid URL error when trying to add the join between my map image table and the hosted feature layer when publishing as a view (I believe using the current map extent will create an independent feature layer that won't update as the source SQL table updates).&nbsp;</P><P>Here is the join features docs that I referenced. Seems like both layers need to be hosted feature layers to create the view:&nbsp;<A href="https://enterprise.arcgis.com/en/portal/latest/use/join-features.htm" target="_blank">Join Features—Portal for ArcGIS | Documentation for ArcGIS Enterprise</A></P><P>Is it possible to join a hosted feature layer to a SQL table and present the result of that in a web map in a format that it will be live?</P><P>&nbsp;</P><P>Thanks,&nbsp;</P> Tue, 21 Mar 2023 19:56:14 GMT https://community.esri.com/t5/arcgis-enterprise-questions/join-hosted-feature-layer-to-table-inregistered/m-p/1270052#M35446 mattkramer 2023-03-21T19:56:14Z