- 1373 Views
- 11 replies
- 1 kudos
Resolved! databricks Asset Bundle
i have come accross a documentation on asset bundles long back whcih states that when you typedatabricks bundle initit gives us option to choose a project type. But i see the below error when i do that i see the below erroris there a way, i can take ...
- 1373 Views
- 11 replies
- 1 kudos
- 632 Views
- 1 replies
- 2 kudos
column mask on <tinyint>Y columns gives error
My table breaks when I try to mask a column with a name like `<tinyint>Y` -- Create a table with a masked column> CREATE FUNCTION mask_int_col(col_val INTEGER) RETURN CASE WHEN is_member('HumanResourceDept') THEN col_val ELSE CAST(NULL as INTEGER) EN...
- 632 Views
- 1 replies
- 2 kudos
- 2 kudos
Hi @DW ,I have replicated your scenario and encountered the same error when applying a column mask to a column named 1Y in Databricks SQL.In short, it makes sense simply to follow Databricks documentation and use the SQL naming conventions, so that c...
- 2 kudos
- 338 Views
- 1 replies
- 0 kudos
Databricks Pyspark filter several columns with similar criteria
I am querying a table from the Databricks Catalog which I have to filter several columns with the same criteria. below is what I have created so far. I have 10 columns that I have filter with a set of criteria from (dx_list1) and another 10 that I ...
- 338 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @abueno ,As I understand the logic you want to implement is:1. For every pair of columns:First Column (DX_i): Must be in dx_list1Second Column (DX_{i+1}): Must be in dx_list22. The condition for each pair is:col('DX_i').isin(dx_list1) OR col('DX_{...
- 0 kudos
- 425 Views
- 1 replies
- 0 kudos
Set up compute policy to allow installing python libraries from a private package index
In our organization, we maintain a bunch of libraries we share code with. They're hosted on a private python package index, which requires a token to allow downloads. My idea was to store the token as a secret which would then be loaded into a cluste...
- 425 Views
- 1 replies
- 0 kudos
- 0 kudos
I figured it out, seems like secrets can only be loaded into environment variables if the content is the secret and nothing else:"value": "{{secrets/global/arneCorpPyPI_token}}" # this will work"value": "foo {{secrets/global/arneCorpPyPI_toke...
- 0 kudos
- 1263 Views
- 3 replies
- 1 kudos
How to retrieve Spark Session inside java jar library installed on Cluster
I have a java app in form of jar package. This jar is installed on a Databricks cluster. This jar package reads and writes to few tables in databricks. In order to achieve that, I need SparkSession available in the code. Given that spark session is a...
- 1263 Views
- 3 replies
- 1 kudos
- 191 Views
- 0 replies
- 0 kudos
Course registration issue
Hi All,I'm trying to register for "Spark Developer course" which is free course but I don't see this course under the course catalogue and if I try to directly access using a link I get 403 forbidden error. Can anyone help me figure out the issue.
- 191 Views
- 0 replies
- 0 kudos
- 1061 Views
- 7 replies
- 0 kudos
Unable to install the Databricks in AWS
I have followed the instructions given in the following link https://docs.databricks.com/en/admin/workspace/quick-start.html#use-aws-quickstart-to-create-a-databricks-workspace%22There was an error in CFT while deploying the workspace. Please help[ER...
- 1061 Views
- 7 replies
- 0 kudos
- 0 kudos
Hi @rseshadri ,I'm more familiar with Azure, but this error is most commonly caused by entering the wrong credentials in the Cloudformation template.Try to launch the Quickstart again from the Databricks Account Console and double check that you ente...
- 0 kudos
- 304 Views
- 2 replies
- 1 kudos
How to delete object permissions using REST API
We have REST API methods to set,update,Get object permissions documented here https://docs.databricks.com/api/workspace/permissionsIs there a way to revoke the permissions which are granted through REST API
- 304 Views
- 2 replies
- 1 kudos
- 1 kudos
Thank you for your response!We have a situation where we assigned CAN_BIND permissions to a group for a service principal using the following:$ vim grant-service-principal.json{"access_control_list": [{"user_name": "{username}","permission_level": "C...
- 1 kudos
- 1540 Views
- 3 replies
- 0 kudos
How to Read Data from Databricks Worker Nodes in Unity Catalog Volume
I am currently working on a similarity search use case where we need to extract text from PDF files and create a vector index. We have stored our PDF files in a Unity Catalog Volume, and I can successfully read these files from the driver node.Here's...
- 1540 Views
- 3 replies
- 0 kudos
- 3415 Views
- 2 replies
- 0 kudos
ArcGIS Connection
Hi,I am trying to connect to an ArcGIS instance using Data bricks. Is this possible? After connecting, I am trying to read the data into a Data fame.Please help me with this request. If its not possible to connect , please provide an alternative.Than...
- 3415 Views
- 2 replies
- 0 kudos
- 0 kudos
Hello, please. Feel free to reach out if you need support deploying ArcGIS within Databricks. Nowadays, there are multiple ways for users to leverage the power of Databricks while using Esri's advanced tools and the app creators once the analysis is ...
- 0 kudos
- 682 Views
- 3 replies
- 0 kudos
Unable to install databricks free trial on AWS
I was trying to install databricks on AWS using these instructions "https://docs.databricks.com/en/admin/workspace/quick-start.html#use-aws-quickstart-to-create-a-databricks-workspace". But when CloudFormation Template stack executed "createCredentia...
- 682 Views
- 3 replies
- 0 kudos
- 0 kudos
I am facing the same error when installing the Databricks in AWS, Please find attached the error below and help [ERROR] 2024-10-08T12:11:56.458Z ad8dd24a-67ec-4941-8096-3f8d883994b2 Exception: Expecting value: line 1 column 1 (char 0)Traceback (most ...
- 0 kudos
- 10665 Views
- 9 replies
- 2 kudos
How to disable task in databricks job workflow
I don't see any option to disable the task. I have created one workflow which contains multiple tasks.sometime i need to disable some task for my experiment. but there is no straightforward way for this. I feel "disable" button is must have option ...
- 10665 Views
- 9 replies
- 2 kudos
- 2 kudos
I know this post was a while ago, but I've hit this issue, and come up with using if/else conditions between the tasks with a Job parameter of "IsActiveTask2" with a True or False, and then I can have the Task2 dependant on the success of this condit...
- 2 kudos
- 1936 Views
- 1 replies
- 0 kudos
how to configure EC2 instance connection in databricks
I would like to know how to configure to be aws instance connection, a VPC and an EC2 instance were configured and allowed IP ping ping server onpremise, how would it be possible to make connection in Databricks so that it can make a connection?
- 1936 Views
- 1 replies
- 0 kudos
- 0 kudos
I would like to know how to configure to be aws instance connection, a VPC and an EC2 instance were configured and allowed IP ping ping server onpremise, how would it be possible to make connection in Databricks so that it can make a connection?
- 0 kudos
- 288 Views
- 1 replies
- 0 kudos
Automating the Migration of ML Models and Metadata to Unity Catalog
Hello everyone,I am currently working on a project where I need to migrate ML models from the Model Registry of one Databricks workspace to the Unity Catalog (schema/catalog) of another workspace. This migration needs to include not only the models t...
- 288 Views
- 1 replies
- 0 kudos
- 0 kudos
Deploy as Code is recommended. https://learn.microsoft.com/en-us/azure/databricks/machine-learning/mlops/deployment-patterns#deploy-code If you need to copy the model as a Pickle file then use https://github.com/mlflow/mlflow-export-import CICD imple...
- 0 kudos
- 719 Views
- 1 replies
- 0 kudos
Price of UCX assessment and migration
Hi,I am planning to migrate few tables and workflows from Hive metastore to Unity catalog( For example 8 tables and 2 small) workflows. What is the cost of using UCX (Unity Catalog Upgrade eXperience) for assessment and migration of artifacts from a ...
- 719 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @satya1206 ,There is no place involved when it comes to using ucx. It's free tool, open source tool created by databricks labs. More info you can find on below: https://github.com/databrickslabs/ucx
- 0 kudos
