When I read https://docs.microsoft.com/en-us/azure/databricks/sql/admin/sql-endpoints#cluster-size, it says : Each driver and worker has eight 128 GB Standard LRS managed disks attached. Attached disks are charged hourly.My question is, why do e...
Need some advice for managing my SQL environment and handling internal chargebacks to the teams using the endpoint.
Thank you for sharing your valuable solution, it's work properly.LiveTheOrangeLife
Databricks SQL provides a simple experience for SQL users who want to run quick ad-hoc queries on their data lake, create multiple visualization types to explore query results from different perspectives, and build and share dashboards.
I'd like to be able to limit the rows users see when querying tables in Databricks SQL based on what access level each user is supposed to be granted. Is this possible in the SQL environment?
Using dynamic views you can specify permissions down to the row or field level e.g. CREATE VIEW sales_redacted AS SELECT user_id, country, product, total FROM sales_raw WHERE CASE WHEN is_member('managers') THEN TRUE ELSE total <= 1...
SQL Analytics actually uses several layers of caching. Some documentation about the different layers can be found here in the documentation. There are two primary layers that users will experience. 1) The first is that the actual data results of spec...
