- 2676 Views
- 2 replies
- 0 kudos
Best practice to use s3 gateway with VPC
The company is getting a high expensive cost in data traffic after setting up the VPC, now we notice that we have to set up a s3 gateway, I wonder what is the best practices
- 2676 Views
- 2 replies
- 0 kudos
- 0 kudos
@Ayun In terms of s3 gateway wrt to aws that looks promising in terms of price, but i have not seen anything related to s3 gateway mentioned in databricks articles. for most of implementations we went with standard approach that databricks mentioned....
- 0 kudos
- 5374 Views
- 1 replies
- 0 kudos
Resolved! Issue with Enabling Unity Catalog in Workspace
I hope this message finds you all well.I followed the necessary steps to enable the Unity Catalog in our workspace.However, upon saving the configuration, I noticed that the Unity Catalog feature is automatically being disabled.I have double-checked ...
- 5374 Views
- 1 replies
- 0 kudos
- 0 kudos
@msserpa where you are enabling this config please, usually if you add workspace in data--> metastore--> workspace , then you should not get any issue
- 0 kudos
- 2023 Views
- 1 replies
- 1 kudos
Restrict access to Hive Metastore in environments
Hi, We have issues with users creating tables and storing data in hive metastore in environments with UC. How to you restrict this access?
- 2023 Views
- 1 replies
- 1 kudos
- 1 kudos
@JohannaAK please restrict users in catalog level, by only providing select operation, looks all permissions are enabled for users
- 1 kudos
- 1153 Views
- 0 replies
- 0 kudos
API to access query data plan
I'm working on a tool to visualise who accessed which (unity) catalogs, schemas and tables. To do that, I would like to access the query plan of the queries in the query history. Unfortunately, It seems like the REST api doesn't support accessing tho...
- 1153 Views
- 0 replies
- 0 kudos
- 3652 Views
- 1 replies
- 0 kudos
Bronze layer tables
What type of tables do we use for Bronze layer. Managed or external when our raw data is in csv file
- 3652 Views
- 1 replies
- 0 kudos
- 0 kudos
You can create either a managed or an unmanaged (external) table in the bronze layer, depending on your preference and use case. If you choose to create a managed table, Databricks will manage both the metadata and the data for the table. If you choo...
- 0 kudos
- 1135 Views
- 0 replies
- 1 kudos
DataAI summit 2023
Loving the experience at DataAI summit 2023. Excited for the new features on the lakehouse
- 1135 Views
- 0 replies
- 1 kudos
- 6815 Views
- 2 replies
- 0 kudos
- 6815 Views
- 2 replies
- 0 kudos
- 0 kudos
Redis offers various data structures such as strings, lists, sets, and hashes. Depending on your use case, select the appropriate data structure for storing the crm enrich data. For example, if you need to store key-value pairs, Redis hashes (HSET, H...
- 0 kudos
- 7609 Views
- 1 replies
- 0 kudos
How can I use Delta Lake with AWS Athena and AWS Glue catalog?
Currently we use AWS Athena and aws glue catalog for our data lake. We would like to evaluate delta lake for data management. How shall we try this with the existing setup?
- 7609 Views
- 1 replies
- 0 kudos
- 0 kudos
Actually the Glue Hive Metastore integration with Unity Catalog as been announced today at the Databricks Summit.Give it a try herehttps://docs.databricks.com/archive/external-metastores/aws-glue-metastore.html
- 0 kudos
- 896 Views
- 0 replies
- 0 kudos
Git Hub Enterprise and public IP
Hello anybody tried to attach an internal Git Hub Enterprise server through databricks whiteout having to whitelist the public op of the control plane ?both on Azure or AWS ?
- 896 Views
- 0 replies
- 0 kudos
- 995 Views
- 0 replies
- 0 kudos
Lake house monitoring
I’m excited for the inbuilt monitoring capabilities coming in the future.
- 995 Views
- 0 replies
- 0 kudos
- 4685 Views
- 2 replies
- 0 kudos
Resolved! Connect Spark Cluster to SQL Endpoint
Hello! Is it possible to retrieve data from a SQL Endpoint in the Databricks SQL persona using the Data Science and Engineering persona? In other words, I would like to use pyspark in DS&E to query a table in Databricks SQL.#DatabricksSQL#Databricks...
- 4685 Views
- 2 replies
- 0 kudos
- 0 kudos
you do not need the sql warehouse itself for that. for ds & e you need a classic cluster (not a sql endpoint) anyway so you can easily read the tables from the metastore using spark.read.table().Connecting the sql endpoint to the ds cluster seems od...
- 0 kudos
- 7403 Views
- 5 replies
- 1 kudos
Resolved! Use different instance types in pools
I am wondering if it's possible to create a pool that has a mix of instance types in it?
- 7403 Views
- 5 replies
- 1 kudos
- 1 kudos
AWS Fleet instance types are now GA and available for clusters and instance pools. You can see more details here: https://docs.databricks.com/compute/aws-fleet-instances.html
- 1 kudos
- 4502 Views
- 3 replies
- 0 kudos
Resolved! Are there any scenarios where it doesn't make sense to use Spot Instances?
It seems like using spot instances make a lot of sense for cost savings. But are there any risks to using them? Or things to consider before enabling them?
- 4502 Views
- 3 replies
- 0 kudos
- 0 kudos
On AWS, to further improve the chance of acquiring spot instances, you can use the newly GA'd feature Fleet instance types: https://docs.databricks.com/compute/aws-fleet-instances.html
- 0 kudos
- 3033 Views
- 1 replies
- 1 kudos
Limited number of workspaces vs workspace for department or line of business ?
We are just getting started with databricks currently we have 1 workspace for each environment (DEV, QA and PRD). we have started with 1 workspace but there is already getting flooded with new workspace requests? is there any check list/criteria fo...
- 3033 Views
- 1 replies
- 1 kudos
- 1 kudos
I believe DEV, QA and PRD are the right segregate . We may need this because this will be easy to categorize the production and QA workload - based upon the amount of data cluster processes (Meaning more DBU) which we can restrict by the company work...
- 1 kudos
- 3059 Views
- 1 replies
- 0 kudos
Delta Live Table tables in Data Tab
If I use this code (CREATE STREAMING LIVE TABLE Employee) in dlt pipeline, where does the Employee table gets created by default, if no storage location is specified? How can I create this table in Data tab within a database (a.k.a: Schema) lets say ...
- 3059 Views
- 1 replies
- 0 kudos
- 0 kudos
@Kris Koirala​ :When you create a streaming live table in Databricks Delta Lake using the code CREATE STREAMING LIVE TABLE Employee, the table is created in the default database called default. If no storage location is specified, the table is stored...
- 0 kudos
