- 16162 Views
- 5 replies
- 7 kudos
Passing proxy configurations with databricks-sql-connector python?
Hi,I am trying to connect to databricks workspace which has IP Access restriction enabled using databricks-sql-connector. Only my Proxy server IPs are added in the allow list.from databricks import sql connection = sql.connect( server_hostname ='...
- 16162 Views
- 5 replies
- 7 kudos
- 7 kudos
Is there any resolution for the above setting up proxy with databricks sql connector
- 7 kudos
- 5881 Views
- 4 replies
- 0 kudos
Resolved! How to enable Databricks Apps User Authorization?
Hi All,I am working on implementation of user authorization in my databricks app. but to enable user auth it is asking:"A workspace admin must enable this feature to be able to request additional scopes. The user's API downscoped access token is incl...
- 5881 Views
- 4 replies
- 0 kudos
- 0 kudos
Hi All, We can find this setting under Previews. Go to workspace>click your username>Previews
- 0 kudos
- 1562 Views
- 1 replies
- 0 kudos
databricks Data Engineer associate
Hi everyone , can anyone guide me about any test papers or any test materials anyone can go through for the databricks data engineer associate exam
- 1562 Views
- 1 replies
- 0 kudos
- 0 kudos
Hello @Ipshi! You can find resources for the Databricks Certified Data Engineer Associate exam in the Getting Ready for the Exam section of the exam-specific webpage on the website. This section includes a detailed list of topics covered and sample q...
- 0 kudos
- 3828 Views
- 4 replies
- 0 kudos
Blank Page after Logging In
On Feb 8 Singapore time, our Singapore workspace displayed a blank page (no interface or content) after login. Meanwhile our workspace in Tokyo reason worked normally. This lasted whole day and none of our troubleshooting yielded any clues. Then ever...
- 3828 Views
- 4 replies
- 0 kudos
- 0 kudos
After logging in, I’m getting a white screen, and it won’t load. I’ve tried clearing my cache and switching browsers, but nothing seems to work. This feels like something that really needs to be looked into. Has anyone figured out a way to fix it?
- 0 kudos
- 1282 Views
- 1 replies
- 0 kudos
feature store delta sharing
Hi, I have 2 workspaces one for data engineers and one for data science team and I need to create in data engineering workspace the bronze and silver.I want to built them a feature store should I do it from data science workspace or data engineering ...
- 1282 Views
- 1 replies
- 0 kudos
- 0 kudos
I like the idea of using Feature Store with Delta Sharing, but I’m a bit worried about its limits like no partition filtering and no streaming support. These could cause problems with performance and scaling in real situations.
- 0 kudos
- 10093 Views
- 12 replies
- 0 kudos
Permission issue in Fundamentals of the Databricks Lakehouse Platform Quiz
Hi ,I am getting this Error,when i am trying to give the exam ofFundamentals of the Databricks Lakehouse Platform.403FORBIDDENYou don't have permission to access this page2023-05-20 12:37:41 | Error 403 | https://customer-academy.databricks.com/I al...
- 10093 Views
- 12 replies
- 0 kudos
- 0 kudos
Hello, everyone! We are sorry to hear you're having trouble accessing the Quiz. Please note that the Lakehouse Fundamentals course has been replaced by Databricks Fundamentals along with the updated content.Try logging into your account directly by u...
- 0 kudos
- 1675 Views
- 1 replies
- 0 kudos
Delta Live Table (Streaming Tables) for excel (.xlsx, .xls)
What's the native way to ingest excel files using a streaming table? I wish that when the excel files land in unity catalog, it can pick up those and load it in to the Streaming Table. Data is Small, so we can afford some kind of UDF, but we really n...
- 1675 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @NathanC0926 Ingesting Excel files with streaming tables requires a combination of Databricks Autoloader(for file discovery and exactly-once processing) and a custom UDF for Excel parsing.Here's the native approachKey Features of This Solution1. E...
- 0 kudos
- 2109 Views
- 3 replies
- 1 kudos
Notebook ID in DESCRIBE HISTORY not showing
We've recently installed Databricks 14.3 LTS with Unity Catalog and for some reason that is escaping me the Notebook Id is not showing up when I execute the DESCRIBE HISTORY SQL command. Example below for table test_catalog.lineagedemo.lm_lineage_tes...
- 2109 Views
- 3 replies
- 1 kudos
- 1 kudos
Hi @RameshRetnasamy first off thank you so much for taking the time to reply to my question. In my case they were indeed created via Notebooks, but I'll re-evaluate on my end as I might've missed something. If the issue persists, I'll re-assert the q...
- 1 kudos
- 1884 Views
- 4 replies
- 0 kudos
Not able create and start a cluster
Hi Team,I am trying to use community edition for learning below is my URL detailshttps://community.cloud.databricks.com/compute/interactive?o=2059657917292434Due to some reason my clusters are taking nearly 45 to 60 minutes for creation and after if ...
- 1884 Views
- 4 replies
- 0 kudos
- 0 kudos
Hi @nikhilj0421 still the same issue, i could see its working till spark 15.4 LTS above 15.4LTS whatever version i useits not woring i am not able to create any cluster.
- 0 kudos
- 3671 Views
- 1 replies
- 0 kudos
Spark Streaming Job gets stuck in the "Stream Initializing"
Hello all,I am having an issue with my Spark Streaming Job. It is stuck at "Stream Initializing" stage.Need your help here to understand what is happening inside the "Stream Initializing" stage of Spark Streaming job which is taking so long. Here are...
- 3671 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @hao-uit, do you see any kind of load on the driver and event logs? Also, what libraries you have installed on your cluster?
- 0 kudos
- 60305 Views
- 7 replies
- 8 kudos
how to read the CSV file from users workspace
Hi!I have been carrying out a POC, so I created the CSV file in my workspace and tried to read the content using the techniques below in a Python notebook, but did not work.Option1:repo_file = "/Workspace/Users/u1@org.com/csv files/f1.csv"tmp_file_na...
- 60305 Views
- 7 replies
- 8 kudos
- 8 kudos
Hi @Dev ,Generally, What happens spark reader APIs point to the DBFS by default. And, to read the file from User workspace, we need to append 'file:/' in the prefix.Thanks
- 8 kudos
- 1460 Views
- 0 replies
- 0 kudos
An Equivalent Implementation of XIRR in Excel within PySpark
IntroductionIRR is a common method used by financial personnel to evaluate the financial benefits of project investment, and its formula is as follows.In excel, you can use the XIRR function to calculate the IRR of non-periodic cash flows easily.But ...
- 1460 Views
- 0 replies
- 0 kudos
- 6261 Views
- 7 replies
- 1 kudos
parameterized ALTER TABLE SET TAGS
I would like to use parametrized sql queries to run SET TAGs commands on tables, but cannot figure out how to parameterize the query to prevent SQL injection. Both the `?` and `:key` parameter syntaxes throw a syntax errorBasically, I'd like to do th...
- 6261 Views
- 7 replies
- 1 kudos
- 1544 Views
- 1 replies
- 0 kudos
Merge Performance Issues
The issues we are currently facing in our project is Slow Merge Performance.Production database has 50 billion records (Historical data), data is partitioned(date) but not indexed.Incremental data is has close 250 to 500 million records. Incremental ...
- 1544 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @Harshul, 1. Yes, if configured properly, INSERT OVERWRITE helps maintain data consistency. You can deduplicate incremental data using ROW_NUMBER() and use INSERT OVERWRITE with replaceWhere for efficient daily bulk updates.2. Usually lower, since...
- 0 kudos
- 4552 Views
- 12 replies
- 3 kudos
Resolved! Databricks Rest api swagger definition not handling bigint or integer
I want to test create a custom connector in a Power App that connects to table in Databricks. The issue is if I have any columns like int or bigint. No matter what I define in the response in my swagger definition See below), it is not correct type...
- 4552 Views
- 12 replies
- 3 kudos
- 3 kudos
Hi @lingareddy_Alva This might warrant another post to keep the conversation focussed, but I found a couple of things with the custom connector that make it a bit cumbersome to use.1) I don't seem to be able to have two post operations under /statmen...
- 3 kudos
| User | Count |
|---|---|
| 1645 | |
| 793 | |
| 584 | |
| 349 | |
| 287 |
