- 3822 Views
- 1 replies
- 1 kudos
Databricks integration with DocumentDB
Hi Everyone,I was wondering if anyone here has any experience or tips reading data from AWS DocumentDB. I am working on this using the MongoDB connector. For DocumentDB we also need to work with the required creds issued as a .pem file by AWS. Th...
- 3822 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi @Kaniz Fatma​ ,Thank you so much for your response. Your suggestions were helpful. As per the AWS documentation, DocumentDB is MongoDB compatible. "With Amazon DocumentDB, you can run the same application code and use the same drivers and tools th...
- 1 kudos
- 5339 Views
- 9 replies
- 2 kudos
SQL Warehouse connections in us-east-2
I have 2 very similarly configured workspaces, one in us-west-2 and one in us-east-2.Both got configured by default with a "Starter Warehouse".The one in us-west-2 I can reach via the internet using python databricks-sql-connector, but the one in us-...
- 5339 Views
- 9 replies
- 2 kudos
- 2 kudos
Hi @Marcus Simonsen​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Th...
- 2 kudos
- 2005 Views
- 1 replies
- 0 kudos
unable to find LoginModule class: org.apache.kafka.common.security.plain.PlainLoginModule
In databricks I am trying to read data from a protected kafka topic using pyspark.I am getting an error "unable to find LoginModule class: org.apache.kafka.common.security.plain.PlainLoginModule".
- 2005 Views
- 1 replies
- 0 kudos
- 0 kudos
Did you able to resolve it?
- 0 kudos
- 4638 Views
- 4 replies
- 0 kudos
Resolved! authentication is not configured for provider
Hi team, I started getting this message lately when trying add some new config or change my workspace with terraform :Error: cannot create global init script: authentication is not configured for provider. Please check https://registry.terraform.io/p...
- 4638 Views
- 4 replies
- 0 kudos
- 0 kudos
Hi @Avi Edri​ looks like you are using a provider that is authenticated to the Accounts console (https://accounts.cloud.databricks.com) to create a global init script within the workspace. Can you try authentication with host and PAT token? Follow th...
- 0 kudos
- 2116 Views
- 0 replies
- 3 kudos
How to specify which columns to use when using DLT APPLY CHANGES INTO
I have a notebook with the code below, where I try to do an upsert into a dimension table and only include one column from the source table. I get an error even though I think the syntax matches what I see in the docs. How can I write this in the cor...
- 2116 Views
- 0 replies
- 3 kudos
- 11590 Views
- 6 replies
- 2 kudos
Resolved! Failed to fetch archive.ubuntu
I am trying to use selenium webdriver to do a scraping project in Databricks. The notebook used to run properly but now has an issue with the Get:1 http://archive.ubuntu.com/ubuntu focal/main amd64 fonts-liberation all 1:1.07.4-11 [822 kB]command .In...
- 11590 Views
- 6 replies
- 2 kudos
- 2 kudos
Hi, @Dagart Allison​ . I've created a new version of the selenium with the databricks manual. Please look here https://community.databricks.com/s/feed/0D58Y00009SWgVuSAL
- 2 kudos
- 5308 Views
- 2 replies
- 0 kudos
Using Selenium Chrome Driver in Databricks, runs the first time but fails after that
I have a notebook that uses a Selenium Web Driver for Chrome and it works the first time I run the notebook. If I run the notebook again, it will not work and gives the error message: WebDriverException: Message: unknown error: unable to discover op...
- 5308 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi, @Dagart Allison​ . I've created a new version of the selenium with the databricks manual. Please look here https://community.databricks.com/s/feed/0D58Y00009SWgVuSAL
- 0 kudos
- 10345 Views
- 6 replies
- 3 kudos
How to do bucketing in Databricks?
We are migrating a job from onprem to databricks. We are trying to optimize the jobs but couldn't use bucketing because by default databricks stores all tables as delta table and it shows error that bucketing is not supported for delta. Is there anyw...
- 10345 Views
- 6 replies
- 3 kudos
- 3 kudos
Hi @Arun Balaji​ ,bucketing is not supported for the delta tables as you have noticed.For the optimization and best practices with delta tables check this:https://docs.databricks.com/optimizations/index.htmlhttps://docs.databricks.com/delta/best-prac...
- 3 kudos
- 16617 Views
- 13 replies
- 23 kudos
Resolved! Users are failing query data from S3 bucket
Hi team, Users are unable run select on data located on S3 buckets, S3 permission are ok.The only way they manage do it by granted the databricks workspace admin permission.Attached the error.Thanks!
- 16617 Views
- 13 replies
- 23 kudos
- 23 kudos
@Avi Edri​ adding some more info to @Pat Sienkiewicz​ suggestion, @Avi Edri​ are you using cluster with instance profile, if you are using instance profile configured, please validate read permissions are there on that bucket and instance profile ass...
- 23 kudos
- 26210 Views
- 7 replies
- 10 kudos
Resolved! Migrate tables from one azure databricks workspace to another
Hello all,I'm currently trying to move the tables contained in one azure workspace to another, because of a change in the way we use our resources groups. I have not been able to move more than metadata with the databrickslabs/migrate repo. I was won...
- 26210 Views
- 7 replies
- 10 kudos
- 10 kudos
Hi @Quentin Maire​ ,We need a bit more details.where is your data stored ?are you using external or managed tables?the migrate tool allows you to export DDL statements not the data itself.I can think about few scenarios on Top of my head.if you had p...
- 10 kudos
- 3345 Views
- 2 replies
- 0 kudos
Spark SQL output multiple small files
We are having multiple joins involving a large table (about 500gb in size). The output of the joins is stored into multiple small files each of size 800kb-1.5mb. Because of this the job is split into multiple tasks and taking a long time to complete....
- 3345 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi @Arun Balaji​ , Could you please provide the error message you are receiving?
- 0 kudos
- 2477 Views
- 1 replies
- 2 kudos
Issue converting the datasets into JSON
Im a newbie to Databricks, I need to convert the data sets into JSON. i tried bth FOR JSON AUTO AND FOR JSON PATH, However im getting an issue - [PARSE_SYNTAX_ERROR] Syntax error at or near 'json'line My Query works fine without FOR JSON AUTO AND FOR...
- 2477 Views
- 1 replies
- 2 kudos
- 2 kudos
Hi @Kavin Natarajan​ , Could you please go through https://www.tutorialkart.com/apache-spark/spark-write-dataset-to-json-file-example/ , looks like the steps are okay.
- 2 kudos
- 6888 Views
- 3 replies
- 3 kudos
Databricks web terminal not able to parse notebooks.
In the web terminal, I am not able to search for text for example using grep -l "search_term" db_notebookThis leads to "Operation not permitted on <notebook> error", any ideas why?This is for all DB notebooks in my cluster.Thanks!
- 6888 Views
- 3 replies
- 3 kudos
- 3 kudos
Hi @Andrej Erkelens​ , Could you please start the shell with %sh . Also, could you please provide the whole screenshot with the error here along with the whole command tried?
- 3 kudos
- 3424 Views
- 3 replies
- 4 kudos
How to run SQL queries from services when data migrated from SQL server to data lake?
Currently our service provides an API to serve the purchase records. The purchase records are stored in SQL database. To simplify, when users want to get their recent purchase records, they make an API call. The API call will run a SQL query on the D...
- 3424 Views
- 3 replies
- 4 kudos
- 4 kudos
Hi @Stanley Tang​ , There are several rest API resources managed by Databricks. You can refer https://docs.databricks.com/dev-tools/api/latest/index.html. In this scenario, SQL Warehouses API can be used: https://docs.databricks.com/sql/api/sql-endpo...
- 4 kudos
- 3132 Views
- 0 replies
- 1 kudos
Py4JError: com.xxxx.TipsScore.score does not exist in the JVM
I have installed score jar file in cluster but getting error while trying to useError: Py4JError: com.xxxxx.tips.TipsScore.score does not exist in the JVMCode: score=spark._jvm.com.xxxx.tips.TipsScore.score
- 3132 Views
- 0 replies
- 1 kudos
| User | Count |
|---|---|
| 1626 | |
| 790 | |
| 510 | |
| 349 | |
| 287 |
