https://community.databricks.com/t5/administration-architecture/how-register-a-published-app/m-p/59978#M860 <P>Hello Yeshwanth,&nbsp;<BR /><BR />The use case is as follows.&nbsp; We have a cloud-hosted, nosql web application that accelerates the design process going from multiple tables to a single, "master" table.&nbsp; In addition to specifying the required joins and unions, the system hosts the domain specific information to generate a complete information set.&nbsp; The end-user is an analyst that needs to build the data set for a specific, short-lived project.&nbsp; The inputs to the workflow is a subset of the tables the user has access to in the Lakehouse. The inputs also include the project-specific information required to augment the data set with multiple sources of truth, and how to interpret the lack of records and field values (i.e., fill out and interpret a "non-event").&nbsp; The output is a master table that can be hosted on databricks (when write permissions exist) or exported to a preferred BI tool (e.g., Power BI, Tableau, Dataiku etc.).&nbsp;<BR /><BR />To that end, I would like to provide our users the ability to access their data managed by databricks.&nbsp; The app would use the read permissions to fuel the design and materialize the project-specific "master" data set.<BR /><BR />Finally, we have this functionality working using Google drive and the like (we use OAuth2 and the PKCE flow).&nbsp; The idea is to get a similar functionality up and running for Databricks.&nbsp; A step in the process is to pre-register the application with the data hosting service.&nbsp; Our app will use the connection between servers, with the proof of authorization negotiated by the user, to access the user's hosted data.</P> Mon, 12 Feb 2024 20:06:48 GMT edmundsecho 2024-02-12T20:06:48Z https://community.databricks.com/t5/administration-architecture/how-register-a-published-app/m-p/59505#M839 <P>Is there a way to register a web app with Databricks to enable it to access a user's data using OAuth2? i.e., be included in the list of published apps with a pre-negotiated scope?&nbsp;</P> Tue, 06 Feb 2024 18:31:41 GMT https://community.databricks.com/t5/administration-architecture/how-register-a-published-app/m-p/59505#M839 edmundsecho 2024-02-06T18:31:41Z https://community.databricks.com/t5/administration-architecture/how-register-a-published-app/m-p/59539#M841 <P><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/99058">@edmundsecho</a>&nbsp;could you please elaborate more on the use case?&nbsp;</P> Wed, 07 Feb 2024 05:12:43 GMT https://community.databricks.com/t5/administration-architecture/how-register-a-published-app/m-p/59539#M841 Yeshwanth 2024-02-07T05:12:43Z https://community.databricks.com/t5/administration-architecture/how-register-a-published-app/m-p/59978#M860 <P>Hello Yeshwanth,&nbsp;<BR /><BR />The use case is as follows.&nbsp; We have a cloud-hosted, nosql web application that accelerates the design process going from multiple tables to a single, "master" table.&nbsp; In addition to specifying the required joins and unions, the system hosts the domain specific information to generate a complete information set.&nbsp; The end-user is an analyst that needs to build the data set for a specific, short-lived project.&nbsp; The inputs to the workflow is a subset of the tables the user has access to in the Lakehouse. The inputs also include the project-specific information required to augment the data set with multiple sources of truth, and how to interpret the lack of records and field values (i.e., fill out and interpret a "non-event").&nbsp; The output is a master table that can be hosted on databricks (when write permissions exist) or exported to a preferred BI tool (e.g., Power BI, Tableau, Dataiku etc.).&nbsp;<BR /><BR />To that end, I would like to provide our users the ability to access their data managed by databricks.&nbsp; The app would use the read permissions to fuel the design and materialize the project-specific "master" data set.<BR /><BR />Finally, we have this functionality working using Google drive and the like (we use OAuth2 and the PKCE flow).&nbsp; The idea is to get a similar functionality up and running for Databricks.&nbsp; A step in the process is to pre-register the application with the data hosting service.&nbsp; Our app will use the connection between servers, with the proof of authorization negotiated by the user, to access the user's hosted data.</P> Mon, 12 Feb 2024 20:06:48 GMT https://community.databricks.com/t5/administration-architecture/how-register-a-published-app/m-p/59978#M860 edmundsecho 2024-02-12T20:06:48Z