Here's your Data + AI Summit 2024 - Data Governance recap as you navigate the explosion of AI, data and tools in efforts to build a flexible and scalable governance framework that spans your entire data and AI estate. Keynote: Evolving Data Governan...
SELECT position_no, position_function, work_function, job_profile_id, pos_cat as position_category, pos_cat_desc, job_posting_title as pos_title, employee_status as emp_status, emp_status_desc, clevel, subs...
In Azure, what are the limits of Unity Catalogue? One UC per region per subscription, or is it one UC per region per tenant?
Does it mean we will have DEV, TEST, PROD catalog in a single Unity catalog?
Hi Databricks community! Exciting news: we open-sourced PACE (Policy As Code Engine) and launched on Product Hunt, and we'd love your input!PACE offers an abstraction on Unity Catalog data access policies, translating YAML/JSON policy definitions int...
Hi,I have an external table which reads data from a S3 bucket. The s3 bucket is expected to get new files frequently. With some changes to the underlying schema. I used Refresh Table table command to load new files from the s3 location and it worked ...
I want to run SQL statements whenever we add ROW FILTER or MASK using ALTER TABLE command. https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-alter-table.htmlhttps://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-alt...
The best way to run a jobon ALTER TABLE SET ROW FILTER or SET MASK.1. **Create the Function** You need to start by creating a function that will be used to filter the rows or mask the columns. The function should return a boolean value that determin...
I am trying to create catelog and metastor but not able to create it
Hi, The Catalog Explorer UI is not live in all Databricks workspaces. For information about the previous UI, see Explore and create tables in DBFS. Refer: https://docs.databricks.com/en/catalog-explorer/index.html . Also, could you please share the ...
we are planning to enabled azure private link config. as per article looks , we will have 2 private link services that need to be configured and 2 private endpoints. also we would like enable system tables. based on system tables limitations it says ...
Hi, In this scenario, are you mentioning about private preview of system tables? Also, you can refer to https://learn.microsoft.com/en-us/azure/key-vault/general/integrate-databricks-blob-storage , let us know if this helps.
Hi,I want to access the Databricks Audit Logs to check the table usage information.I created a Databricks workspace on the premium pricing tier and enabled it for the Unity Catalogue.I configured Audit logs to be sent to Azure Diagnostic log delivery...
Thanks @Suteja Kanuri​ Could you guide me on how to setup and configure Table Access Control (TAC)?
We have a requirement to configure storage credentials in UC for s3 buckets which have been previously mounted by using access keys mounts has been depreciated and we need to configure storage credentials when we use UC. But while configuring storag...
Hello @karthik_p , The UC setup provides the feasibility to add the S3 bucket as a volume when compared to the non-UC concept Mounts.When added as Volume, the access to the Volume in UC is Governed via the Storage Credentials.Regarding Storage crede...
Execute the below Python code in your databricks workspace to enable lineage system tables import requests ctx = dbutils.notebook.entry_point.getDbutils().notebook().getContext() api_url = ctx.tags().get("browserHostName").get() api_token = ctx.apiTo...
Great, I wondered why I didn't see them
I’m currently trying to create a Foreign Catalog based on a Connection object of type SQLSERVER. This would allow me to directly access our on-premises MS SQL database from within Azure Databricks using Unity Catalog.As I’m part of a large organizati...
Good afternoon,We are in the process of setting up Unity Cat, we started in our existing workspace and set it up fine. We are particularly interested in federating existing warehouses at this point. We were able to federate one datawarehouse (dwh1) b...
Hi all,we are in the process of rolling out a new unity-enabled databricks env with 2 tiers: dev and prod.Initially we had the plan to completely decouple dev and prod, each with their own data lake as storage.While this is the safest option, it does...
That is the way I am working at right now. Assign workspace to the catalog and set to read-only if necessary.It would be easier though if it was possible to define a 2nd external location in read-only, as this cannot break anything (of course in rea...
Did any one tried UC DLT, we are trying to create multiple catalogs for UC DLTnote: as per limitations it won't support Locations, supports managed locationsOur use case: we want to create 2 catalogs one for dev and other for production. Dev catalog ...
We're setting up from scratch the Unity Catalog in our infrastructure in Azure, that is both- multi region ( europe, us)- multi env (dev, qa, prod)So, we did setup 2 metastore, one for each region, one in west europe and one for south central us.So f...
