https://community.databricks.com/t5/administration-architecture/how-can-i-set-the-data-access-for-each-sql-warehouse/m-p/3734#M12 <P>It can be done but it's very tricky. You should create a service principal to whom you will grant permission over some tables then you can generate a token using the SP to access only this data.</P> Fri, 02 Jun 2023 13:27:30 GMT youssefmrini 2023-06-02T13:27:30Z https://community.databricks.com/t5/administration-architecture/how-can-i-set-the-data-access-for-each-sql-warehouse/m-p/3732#M10 <P>As far as the official <A href="https://learn.microsoft.com/en-us/azure/databricks/sql/admin/data-access-configuration" target="_blank" rel="noopener">documentation</A> from Microsoft says and I understood it correctly, each SQL warehouse uses the same service principal for data access.</P> <P>But I want to control the access to the data (Azure Data Lake Storage) for each SQL warehouse individually. Is this even possible?</P> Tue, 18 Mar 2025 16:40:52 GMT https://community.databricks.com/t5/administration-architecture/how-can-i-set-the-data-access-for-each-sql-warehouse/m-p/3732#M10 niklas 2025-03-18T16:40:52Z https://community.databricks.com/t5/administration-architecture/how-can-i-set-the-data-access-for-each-sql-warehouse/m-p/3733#M11 <P>following..</P> Fri, 02 Jun 2023 11:11:31 GMT https://community.databricks.com/t5/administration-architecture/how-can-i-set-the-data-access-for-each-sql-warehouse/m-p/3733#M11 Rajeev_Basu 2023-06-02T11:11:31Z https://community.databricks.com/t5/administration-architecture/how-can-i-set-the-data-access-for-each-sql-warehouse/m-p/3734#M12 <P>It can be done but it's very tricky. You should create a service principal to whom you will grant permission over some tables then you can generate a token using the SP to access only this data.</P> Fri, 02 Jun 2023 13:27:30 GMT https://community.databricks.com/t5/administration-architecture/how-can-i-set-the-data-access-for-each-sql-warehouse/m-p/3734#M12 youssefmrini 2023-06-02T13:27:30Z