- 3553 Views
- 4 replies
- 2 kudos
Resolved! DLT workflow failing to read files from AWS S3
Hi All, I am trying to read streams directly from AWS S3. I set the instance profile , but when i run the workflow it fails with below error"No AWS Credentials provided by TemporaryAWSCredentialsProvider : shaded.databricks.org.apache.hadoop.fs.s3a.C...
- 3553 Views
- 4 replies
- 2 kudos
- 2 kudos
Hi @SUDHANSHU RAJ​ is UC enabled on this workspace? What is the access mode set on the cluster? Is this coming from the metastore or directly when you read from S3? Is the S3 cross-account?
- 2 kudos
- 2730 Views
- 2 replies
- 2 kudos
Resolved! Autloader on CSV file didn't infer well cell with JSON data
Hello ! I playing with autoloader schema inference on a big S3 repo with +300 tables and large CSV files. I'm looking at autoloader with great attention, as it can be a great time saver on our ingestion process (data comes from a transactional DB gen...
- 2730 Views
- 2 replies
- 2 kudos
- 2 kudos
PySpark by default is using \ as an escape character. You can change it to "Doc: https://docs.databricks.com/ingestion/auto-loader/options.html#csv-options
- 2 kudos
- 8169 Views
- 2 replies
- 11 kudos
- 8169 Views
- 2 replies
- 11 kudos
- 11 kudos
@Kaniz Fatma​ Is that tool (dbvim) still maintained? It looks like it has been abandoned and there are a couple of unresolved issues.Are there any plans to support vim keybindings in Databricks? This is possible in many other web-based editors such a...
- 11 kudos
- 2051 Views
- 1 replies
- 0 kudos
Connection to Collibra
Hi Team,I want to connect to collibra to fetch details from Collibra.Currently we are using username and password to connect.I want to know recommended practice to connect Collibra account from databricks notebook.
- 2051 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi, Could you please know if this helps. https://marketplace.collibra.com/listings/jdbc-driver-for-databricks/
- 0 kudos
- 2509 Views
- 1 replies
- 2 kudos
How do I maintain Azure Account Console access after Global Admin access is removed?
Hello, I don't know if I should have created a separate question or added to this one.I've read the documentation and as far as I can tell, have followed it correctly but I'm still having issues accessing the Account Console unless the user I'm loggi...
- 2509 Views
- 1 replies
- 2 kudos
- 2 kudos
Hi, Could you please try https://accounts.azuredatabricks.com?accountid=(account-id) , where the account ID has to be the value in the URL? Please let us know if this helps.
- 2 kudos
- 2030 Views
- 0 replies
- 1 kudos
Databricks/spark Stickers
I was wondering if we can request free databricks/spark stickers anywhere.
- 2030 Views
- 0 replies
- 1 kudos
- 6871 Views
- 2 replies
- 3 kudos
Comparing 2 dataframes and create columns from values within a dataframe
Hi,I have a dataframe that has name and companyfrom pyspark.sql import SparkSessionspark = SparkSession.builder.appName('SparkByExamples.com').getOrCreate()columns = ["company","name"]data = [("company1", "Jon"), ("company2", "Steve"), ("company1", "...
- 6871 Views
- 2 replies
- 3 kudos
- 3 kudos
You need to join and pivotdf .join(df2, on=[df.company == df2.job_company])) .groupBy("company", "name") .pivot("job_company") .count()
- 3 kudos
- 4015 Views
- 4 replies
- 2 kudos
How to replace LF and replace with ' ' in csv UTF-16 encoded?
I have tried several code and nothing worked. An extra space or line LF is going to next row in my output. All rows are ending in CRLF, but some rows end in LF and while reading the csv, it is not giving correct output. My csv have double dagger as d...
- 4015 Views
- 4 replies
- 2 kudos
- 2 kudos
val df = spark.read.format("csv") .option("header",true) .option("sep","||") .load("file load") display(df) try this
- 2 kudos
- 2961 Views
- 3 replies
- 9 kudos
one of the date datatype format issue in pysaprk
if anyone has encountered this date type format - 6/15/25 12:00 AM could you mention the right formatting to be used in Pyspark.Thanks in advance!
- 2961 Views
- 3 replies
- 9 kudos
- 9 kudos
Without legacy, it will also work.SELECT to_timestamp('6/15/23 12:00 AM', 'M/dd/yy h:mm a')
- 9 kudos
- 9458 Views
- 1 replies
- 0 kudos
Resolved! How to read a local file using Databricks( file stored in your own computer)
without uploading the file into dbfs? Thanks!
- 9458 Views
- 1 replies
- 0 kudos
- 0 kudos
In my opinion, it doesn't make sense, but...you can Mount SMB Azure file share on a Windows Machine https://learn.microsoft.com/en-us/azure/storage/files/storage-how-to-use-files-windows and then mount the same folder on databricks using pip install ...
- 0 kudos
- 2714 Views
- 2 replies
- 2 kudos
How to delete duplicate tables?
Hi Everyone,Accidently imported duplicate tables, guide me how to delete themusing data bricks community edition
- 2714 Views
- 2 replies
- 2 kudos
- 2 kudos
Hi @Mahesh Babu Uppala​ You can use the following method to delete only the duplicate tables%scala val tables = spark.sql("""SHOW TABLES""").createOrReplaceTempView("tables") val temp_tables = spark.sql("""select tableName from tables where tableName...
- 2 kudos
- 4904 Views
- 4 replies
- 18 kudos
Resolved! Limit resource when create cluster in Databricks on AWS platform
Hi team,Could you please help check on my case? I always failed at this step Thanks
- 4904 Views
- 4 replies
- 18 kudos
- 18 kudos
Thanks all your answer. The problem come from AWS side. Don't know why the first ticket they said that the issue didn't come from AWS
- 18 kudos
- 2834 Views
- 1 replies
- 1 kudos
Ganglia not working with custom container services
Setup:custom docker container starting from the "databricksruntime/gpu-conda:cuda11" base image layer10.4 LTS (includes Apache Spark 3.2.1, Scala 2.12)multi-node, p3.8xlarge GPU computeWhen I try to view Ganglia metrics I am met with "502 Bad Gatewa...
- 2834 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi @James W​ , Ganglia is not available for custom docker containers by default. This is a known limitation. However, you can try this experimental support for ganglia in custom DCS:https://github.com/databricks/containers/tree/master/experimental/ub...
- 1 kudos
- 2294 Views
- 1 replies
- 1 kudos
base64 encode is not matching with Oracle's base64 encode
Hi , base64 encode is not matching with Oracle's base64 encode. please see below result. Could anyone help me on this?In Azure Databricks: encoded= base64.b64encode(b'952B8D04E5CFB9BE')output is - b'OTUyQjhEMDRFNUNGQjlCRQ=='In Oracle: select utl_enco...
- 2294 Views
- 1 replies
- 1 kudos
- 1 kudos
Oracle handles base64 encoding a little bit differently.Please check this link to understand what's the difference:https://dba.stackexchange.com/a/129134
- 1 kudos
- 1783 Views
- 3 replies
- 4 kudos
Did not received badge
I have completed my data bricks lakehouse fundamentals but did not received badge. Please help in this issue.
- 1783 Views
- 3 replies
- 4 kudos
- 4 kudos
Hi @kalle preetham​ 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.Tha...
- 4 kudos
| User | Count |
|---|---|
| 1611 | |
| 768 | |
| 348 | |
| 286 | |
| 252 |
