- 3826 Views
- 9 replies
- 5 kudos
I am preparing for the data analyst exam and I need as many resources as I can get to fully prepare. Hands-on labs will be welcome as well
I am preparing for the data analyst exam and I need as many resources as I can get to fully prepare. Hands-on labs will be welcome as well
- 3826 Views
- 9 replies
- 5 kudos
- 5 kudos
Hi,Kindly refer to the materials below:Videohttps://info.databricks.com/dc/kvtpV3WYob2etSFEoxuDGMYVc6afyrIMgIW50ZzIbvpUgj2uOQyz91VsFjIVPsTMDcYAQ8K0HTbFHGKunTHn_tZmFrrG7SaByl8pfwUNMIZfHhQHiMHwQEKzYSwtM9Vr6hKVl28RlEsSlOluDqaxKqoLcg8-qEwq4xtnrG8zKMEOSpQ...
- 5 kudos
- 1970 Views
- 3 replies
- 5 kudos
Databricks Cross cloud
We have service with AWS Databricks. We are doing the same replica on GCP Databricks. Here we required all the services and functionalities should be run in AWS and AWS Databricks. The only thing data should be stored on the GCP Storage. Simply funct...
- 1970 Views
- 3 replies
- 5 kudos
- 5 kudos
no, right now i don't think they are supporting this type of architecture
- 5 kudos
- 2895 Views
- 4 replies
- 4 kudos
Databricks dashboard alias URL
Can we create a alias URL for databricks dashboard ?
- 2895 Views
- 4 replies
- 4 kudos
- 4 kudos
yes it is possible , you have to create DNS for your databricks and map it to your workspace URL
- 4 kudos
- 1763 Views
- 1 replies
- 2 kudos
#00244807 and #00245872 Ticket Status - HIGH Priority
Dear @Vidula Khanna​ Vidula, Databricks team, @nadia Elsayed​ @Jose Gonzalez​ @Aden Jaxson​ What is the SLA/ETA for normal priority ticket and HIGH priority ticket? I created tickets #00244807 on 7th Dec and #00245872 but haven't received any u...
- 1763 Views
- 1 replies
- 2 kudos
- 2 kudos
you can only create high-priority tasks if you have an enterprise plan.as a normal user you can only create normal tasksif you have enterprise plan then you can escalate case .databricks team will revert you soon there.
- 2 kudos
- 5436 Views
- 1 replies
- 1 kudos
Resolved! Masking A Data Column
Is there a way to mask the data in a column in a table from specific users or user groups?
- 5436 Views
- 1 replies
- 1 kudos
- 1 kudos
yesthis doc will be helpful for you -- https://www.databricks.com/blog/2020/11/20/enforcing-column-level-encryption-and-avoiding-data-duplication-with-pii.html
- 1 kudos
- 1038 Views
- 1 replies
- 0 kudos
Materials for preparing data bricks professional exam.
Hi All, Is there any book / materials for studying for data bricks professional certification ?Thank You !!!
- 1038 Views
- 1 replies
- 0 kudos
- 0 kudos
please check databricks academy,there you will find the right courses
- 0 kudos
- 1089 Views
- 2 replies
- 1 kudos
i need a regex to get whole word with parentheses
SELECT '(CC) ABC' REGEXP '\\b\\(CC\\)\\b' AS TEST1, 'A(CC) ABC' REGEXP '\\b\\(CC\\)\\b' AS TEST2, 'A (CC)A ABC' REGEXP '\\b\\(CC\\)\\b' AS TEST3, 'A (CC) A ABC' REGEXP '\\b\\(CC\\)\\b' AS TEST4, 'A ABC (CC)' REGEXP '\\b\\(CC\\)\\b' AS TES...
- 1089 Views
- 2 replies
- 1 kudos
- 1 kudos
get whole word "(CC)"I had already written the outputexpected outuput '(CC) ABC' REGEXP <<regex>> = TRUE'A(CC) ABC' REGEXP <<regex>> = FALSE'A (CC)A ABC' REGEXP <<regex>> = FALSE 'A (CC) A ABC' REGEXP <<regex>> = TRUE 'A ABC (CC)' REGEXP <<regex>> = ...
- 1 kudos
- 977 Views
- 1 replies
- 0 kudos
- 977 Views
- 1 replies
- 0 kudos
- 0 kudos
use python formatting
- 0 kudos
- 1303 Views
- 1 replies
- 2 kudos
execute sql server agent jobs from Databricks notebook
Is it possible to execute sql server agent job from Databricks notebook?
- 1303 Views
- 1 replies
- 2 kudos
- 2 kudos
i dont think this type of feature is available there
- 2 kudos
- 961 Views
- 1 replies
- 3 kudos
Note book formatting
I am using DBR 10.4 LTS instance can anyone help me formatting the code.I have tried with format python error pop up with upgrade to DBR 11.2 any other alternative to this?
- 961 Views
- 1 replies
- 3 kudos
- 3 kudos
please give us a code by that we can help you
- 3 kudos
- 2186 Views
- 1 replies
- 0 kudos
Driver restarts and job dies after 10-20 hours (Structured Streaming)
I am running a java/jar Structured Streaming job on a single node cluster (Databricks runtime 8.3). The job contains a single query which reads records from multiple Azure Event Hubs using Spark Kafka functionality and outputs results to a mssql dat...
- 2186 Views
- 1 replies
- 0 kudos
- 0 kudos
its seems that when your nodes are increasing it is seeking for init script and it is failing so you can use reserve instances for this activity instead of spot instances it will increase your overall costor alternatively, you can use depended librar...
- 0 kudos
- 1392 Views
- 1 replies
- 0 kudos
Databricks job parameterization
I am configuring an Databricks jobs using multiple notebooks having dependency with each other. All the notebooks are parameterized and using similiar parameters. How can i configure the parameter on global level so that all the notebooks can consume...
- 1392 Views
- 1 replies
- 0 kudos
- 0 kudos
actually, it is very hard but if you want to use an alternative option you have to change your code and use a widget feature of data bricks.May be this is not a right option but you can still explore this doc for testing purpose https://docs.databric...
- 0 kudos
- 4405 Views
- 1 replies
- 2 kudos
What's the crontab notation for every other week for Databricks Workflow scheduling?
Hello,I need to schedule some of my jobs within Databricks Workflow every other week (or every 4 weeks). I've scoured a few forums for find what this notation would be, but I've been unfruitful in my searches.Is this scheduling possible in crontab? I...
- 4405 Views
- 1 replies
- 2 kudos
- 2 kudos
For every seven days starting from Monday, you need to use 2/7. From my experience, that generator works best with databricks https://www.freeformatter.com/cron-expression-generator-quartz.html
- 2 kudos
- 2953 Views
- 6 replies
- 19 kudos
Can anyone let me know, Is there anyway In which we can access different workspace delta tables in a workspace where we run the pipelines using python...
Can anyone let me know, Is there anyway In which we can access different workspace delta tables in a workspace where we run the pipelines using python?​
- 2953 Views
- 6 replies
- 19 kudos
- 19 kudos
@Hemanth A​ go to the workspace you want data from, in warehouse tab you will find connectivity in that copy host name, http path and generate token for it, by this credentials you can access the data of this workspace in any other workspace.
- 19 kudos
- 5243 Views
- 3 replies
- 15 kudos
Resolved! How to count the number of campaigns per day based on the start and end dates of the campaigns in SQL Spark Databrick
I need to count the number of campaigns per day based on the start and end dates of the campaignsInput Table: Out needed (result):How do I need to write the SQL command in databricks to get the above result? thanks all
- 5243 Views
- 3 replies
- 15 kudos
- 15 kudos
Just create an array with sequence, explode it, and then group and count:WITH cte AS (SELECT `campaign name`, explode(sequence(`Start date`, `End date`, interval 1 day)) as `Date` FROM `campaigns`) SELECT Count(`campaign name`) as `count uni...
- 15 kudos
| User | Count |
|---|---|
| 1611 | |
| 768 | |
| 348 | |
| 286 | |
| 252 |
