Accessing table in Unity Catalog

phanisaisrir — Thu, 05 Sep 2024 04:53:31 GMT

What is the preferred way of accessing a UC enabled SqlWarehouse table from Databricks Spark Cluster .

My requirement is to fetch the data from a sqlwarehouse table using complex queries, transform it using Pyspark notebook and save the results.

But to fetch data from UC Enabled Sql warehouse, we can use jdbc connection or we can directly access it using spark.sql().

Which one is suggested in this scenario? Also, note that I need to schedule this notebook for every 30 mins.

Note : Both the Spark cluster and Sql ware house are UC enabled

Re: Accessing table in Unity Catalog

filipniziol — Thu, 05 Sep 2024 06:36:29 GMT

Hi @phanisaisrir ,
Use spark sql. This is the native and most integrated way to interact with data within Databricks.

topic Accessing table in Unity Catalog in Get Started Discussions

Accessing table in Unity Catalog

Re: Accessing table in Unity Catalog