- 10362 Views
- 5 replies
- 14 kudos
I would like to know why CROSS JOIN fails recognize columns
Whenever I apply a CROSS JOIN to my Databricks SQL query I get a message letting me know that a column does not exists, but I'm not sure if the issue is with the CROSS JOIN.For example, the code should identify characters such as http, https, ://, / ...
- 10362 Views
- 5 replies
- 14 kudos
- 14 kudos
@CARLTON PATTERSON​ Since you have given an alias "tt" to your table "basecrmcbreport.organizations", to access corresponding columns you will have to access them in format tt.<column_name>in your code in line #4, try accessing the column 'homepage_u...
- 14 kudos
- 6841 Views
- 5 replies
- 7 kudos
Resolved! Azure Create Metastore button not available
With Unity Catalog gone GA on Azure, we are working through initial tests for setup within Databricks and Azure. However, we are not seeing the "Create Metastore" button available as indicated in documentation. We're also not seeing any additional pr...
- 6841 Views
- 5 replies
- 7 kudos
- 7 kudos
I'm facing the same issues listed above. "Create Metastore" button is unavailable for me as well.
- 7 kudos
- 2239 Views
- 0 replies
- 20 kudos
- 2239 Views
- 0 replies
- 20 kudos
- 8369 Views
- 1 replies
- 3 kudos
Is there any example or guideline how to pass JSON parameters to the pipeline in Databricks workflow?
I used this source https://docs.databricks.com/workflows/jobs/jobs.html#:~:text=You%20can%20use%20Run%20Now,different%20values%20for%20existing%20parameters.&text=next%20to%20Run%20Now%20and,on%20the%20type%20of%20task. But there is no example of how...
- 8369 Views
- 1 replies
- 3 kudos
- 3 kudos
Hi @Andre Ten​ That's exactly how you specify the json parameters in databricks workflow. I have been doing in the same format and it works for me..removed the parameters as it is a bit sensitive. But I hope you get the point.Cheers.
- 3 kudos
- 6035 Views
- 3 replies
- 6 kudos
What is the best expected starting time for a cluster when using a pool?
Hi! I'm doing some tests to get an idea of how much time could be saved starting a cluster by using a pool and was wondering if the results I get are what should be expected.We're using AWS Databricks and used i3.xlarge as instance type (if that matt...
- 6035 Views
- 3 replies
- 6 kudos
- 6 kudos
Hi @Paul Pelletier​ 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...
- 6 kudos
- 3847 Views
- 2 replies
- 1 kudos
Running jobs as a non-job owner
We have enabled Cluster, Pool and Job access, and non-job owners can not run a job even though they are administrators. This disables users from creating cluster resources.When a non-owner of a job attempts to run, they get a permission denied.My un...
- 3847 Views
- 2 replies
- 1 kudos
- 1 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...
- 1 kudos
- 3884 Views
- 3 replies
- 4 kudos
Best practice for creating queries for data transformation?
My apologies in advance for sounding like a newbie. This is really just a curiosity question I have as an outsider observing my team clash with our client. Please ask any questions you have, and I will try my best to answer it.Currently, we are stori...
- 3884 Views
- 3 replies
- 4 kudos
- 4 kudos
Hi @Nick Connors​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.Thanks...
- 4 kudos
- 2673 Views
- 0 replies
- 1 kudos
Read proprietary files and transform contents to a table - error resilient process needed
We do have data stored in HDF5 files in a "proprietary" way. This data needs to be read, converted and transformed before it can be inserted into a delta table.All of this transformation is done in a custom python function that takes the HDF5 file an...
- 2673 Views
- 0 replies
- 1 kudos
- 72744 Views
- 2 replies
- 7 kudos
Resolved! Failed to merge incompatible data types LongType and StringType
Guys, good morning!I am writing the results of a json in a delta table, only the json structure is not always the same, if the field does not list in the json it generates type incompatibility when I append(dfbrzagend.write .format("delta") .mode("ap...
- 72744 Views
- 2 replies
- 7 kudos
- 7 kudos
Hi @Tássio Santos​ The delta table performs schema validation of every column, and the source dataframe column data types must match the column data types in the target table. If they don’t match, an exception is raised.For reference-https://docs.dat...
- 7 kudos
- 4005 Views
- 1 replies
- 8 kudos
Activate gift certificate in Databricks Community Reward store
Hello all,Can anyone let me know about the "Activate Gift Certificate" option in Databricks Community Reward store? What is its purpose and how we can use it?
- 4005 Views
- 1 replies
- 8 kudos
- 8 kudos
you earn points with forum interaction. Those points can be exchanged for 'credits'.With those credits you can buy Databricks swag.Your lifetime points (so the cumulated amount of points) are not affected by this.
- 8 kudos
- 3854 Views
- 1 replies
- 1 kudos
SocketTimeout exception when running a display command on spark dataframe
I am using runtime 9.1LTSI have a R notebook that reads a csv into a R dataframe and does some transformations and finally is converted to spark dataframe using the createDataFrame function.after that when I call the display function on this spark da...
- 3854 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi @Manjusha Unnikrishnan​ Great to meet you, and thanks for your question! Let's see if your peers in the community have an answer to your question first. Or else bricksters will get back to you soon. Thanks.
- 1 kudos
- 3842 Views
- 1 replies
- 2 kudos
Delete a file from GCS folder
What is the best way to delete files from the gcp bucket inside spark job?
- 3842 Views
- 1 replies
- 2 kudos
- 2 kudos
@M Baig​ yes you need just to create service account for databricks and than assign storage admin role to bucket. After that you can mount GCS standard way:bucket_name = "<bucket-name>"mount_name = "<mount-name>"dbutils.fs.mount("gs://%s" % bucket_na...
- 2 kudos
- 8319 Views
- 4 replies
- 5 kudos
AWS quickstart - Cloudformation failure When deploying your workspace with the recommended AWS quickstart method, a Cloudformation template will be la...
AWS quickstart - Cloudformation failureWhen deploying your workspace with the recommended AWS quickstart method, a Cloudformation template will be launched in your AWS account. If you experience a failure with the error message along the lines of ROL...
- 8319 Views
- 4 replies
- 5 kudos
- 7960 Views
- 3 replies
- 10 kudos
How to use Azure Data lake as a storage location to store the Delta Live Tables?
I am trying write data into Azure Datalake. I am reading files from Azure Blob Storage however when I try to create the Delta Live Table to Azure Datalake I get error the following errorshaded.databricks.azurebfs.org.apache.hadoop.fs.azurebfs.contrac...
- 7960 Views
- 3 replies
- 10 kudos
- 10 kudos
@Kaniz Fatma​ I don't think you quite understand the question. I'm running into the same problem. When creating a Delta Live Table pipeline to write to Azure Data Lake Storage (abfss://etc...) as the Storage Location, the pipeline fails with the erro...
- 10 kudos
- 4711 Views
- 2 replies
- 6 kudos
Lakehouse Fundamentals Accreditation badge not received
Hi Team,I have successfully passed the test after completion of the course. But i have not received any badge from your side. I have just been provided a certificate. Certificate ID:ID: E-E04YDVAs mentioned in the web portals i tried accessing "http...
- 4711 Views
- 2 replies
- 6 kudos
- 6 kudos
Hi @Amarjeet Kumar​ , you will receive the badge in a day after completion. Even I received it a day after I cleared the exam. If you don't receive it the next day also, then you can raise a ticket at https://help.databricks.com/s/contact-us?ReqType...
- 6 kudos
| User | Count |
|---|---|
| 1645 | |
| 793 | |
| 586 | |
| 349 | |
| 287 |
