- 10065 Views
- 8 replies
- 4 kudos
Resolved! Databricks SQL not displaying all the databases that i have on my cluster.
I have a cluster running on 7.3 LTS and it has about 35+ databases. When i tried to setup an endpoint on Databricks SQL, i do not see any database listed.
- 10065 Views
- 8 replies
- 4 kudos
- 4 kudos
hi @Arif Ali​ You may have to check the data access config to add the params for external metastore: spark.hadoop.javax.jdo.option.ConnectionDriverName org.mariadb.jdbc.Driverspark.hadoop.javax.jdo.option.ConnectionUserName <mysql-username>spark.had...
- 4 kudos
- 4548 Views
- 5 replies
- 8 kudos
Catch rejected Data ( Rows ) while reading with Apache-Spark.
I work with Spark-Scala and I receive Data in different formats ( .csv/.xlxs/.txt etc ), when I try to read/write this data from different sources to a any database, many records got rejected due to various issues like (special characters, data type ...
- 4548 Views
- 5 replies
- 8 kudos
- 8 kudos
or maybe schema evolution on delta lake is enough, in combination with Hubert's answer
- 8 kudos
- 8671 Views
- 5 replies
- 2 kudos
Resolved! Formatting on Databricks Alerts
Hi Guys. I have looked at the formatting options and I'm still struggling to work out how to best format the email body of a databricks alert. I want to be able to selectively choose columns from the query and dispaly them in a table. Or even if i ca...
- 8671 Views
- 5 replies
- 2 kudos
- 2 kudos
Hi @Nick Hughes​ , unfortunately, this is not available for now. We have a feature request for the same. DB-I-4105 - SQL Alerts: Formatting message body when creating Custom TemplateThis feature has been considered by our product team and it will be...
- 2 kudos
- 2795 Views
- 2 replies
- 1 kudos
Resolved! Why EC2 or EBS volumes are not getting tagged for the instances pool
Why EC2 or EBS volumes are not getting tagged for the instances pool when the tags are present for the Clusters
- 2795 Views
- 2 replies
- 1 kudos
- 1 kudos
"If a cluster is created from a pool, its EC2 instances inherit only the custom and default pool tags, not the cluster tags. Therefore if you want to create clusters from a pool, make sure to assign all of the custom cluster tags you need to the pool...
- 1 kudos
- 5295 Views
- 5 replies
- 4 kudos
Resolved! Databricks fails writing after writing ~30 files
Good day, Copy of https://stackoverflow.com/questions/69974301/looping-through-files-in-databricks-failsI got 100 files of csv data on adls-gen1 store. I want to do some processing to them and save results to same drive, different directory. def look...
- 5295 Views
- 5 replies
- 4 kudos
- 4 kudos
was actually anything created by script in directory <my_output_dir>?The best would be to permanently mount ADSL storage and use azure app for that.In Azure please go to App registrations - register app with name for example "databricks_mount" . Ad...
- 4 kudos
- 3112 Views
- 1 replies
- 1 kudos
Resolved! Best practices for working with Redshift
I have a customer with the following question - I'm posting on their behalf to introduce them to the community. For doing modeling in a python environment what is our best practice for getting the data from redshift? A "load" option seems to leave me...
- 3112 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi @Nicole Wong​ ,Have you check the docs from here? As far as I know, this might be the only way to read/write data to/from redshift.
- 1 kudos
- 11936 Views
- 4 replies
- 4 kudos
Resolved! How does Spark do lazy evaluation?
For context, I am running Spark on databricks platform and using Delta Tables (s3). Let's assume we a table called table_one. I create a view called view_one using the table and then call view_one. Next, I create another view, called view_two based o...
- 11936 Views
- 4 replies
- 4 kudos
- 4 kudos
Hi @John Constantine​ ,The following notebook url will help you to undertand better the difference between lazy transformations and action in Spark. You will be able to compare the physical query plans and undertand better what is going on when you e...
- 4 kudos
- 2924 Views
- 2 replies
- 4 kudos
Resolved! Import a notebook in a Release Pipeline with a Python script
Hi, I would like to import a python file to Databricks with a Azure DevOps Release Pipeline.Within the pipeline I execute a python script which contains this code :import sys import os import base64 import requests dbw_url = sys.argv[1] # https://a...
- 2924 Views
- 2 replies
- 4 kudos
- 4 kudos
Recently I wrote about alternative way to export/import notebooks in pthon https://community.databricks.com/s/question/0D53f00001TgT52CAF/import-notebook-with-python-script-using-api This way you will get more readable error/message (often it is rela...
- 4 kudos
- 2784 Views
- 2 replies
- 13 kudos
Resolved! something like AWS Macie to perform scans on Azure Data Lake
Does anyone know alternative for AWS Macie in Azure?AWS Macie scan S3 buckets for files with sensitive data (personal address, credit card etc...).I would like to use the same style ready scanner for Azure Data Lake.
- 2784 Views
- 2 replies
- 13 kudos
- 17958 Views
- 11 replies
- 2 kudos
- 17958 Views
- 11 replies
- 2 kudos
- 2 kudos
Hi @ahana ahana​ ,Did any of the replies helped you solve this issue? would you be happy to mark their answer as best so that others can quickly find the solution?Thank you
- 2 kudos
- 2097 Views
- 2 replies
- 2 kudos
- 2097 Views
- 2 replies
- 2 kudos
- 2 kudos
Hi @Christopher Shehu​ , if @Piper Wilson​ 's response helped you to solve your question? would you be happy to mark her answer as best so that others can quickly find the solution in the future.
- 2 kudos
- 8919 Views
- 4 replies
- 2 kudos
Resolved! Read JSON with backslash.
Hello guys.I'm trying to read JSON file which contains backslash and failed to read it via pyspark.Tried a lot of options but didn't solve this yet, I thought to read all the JSON as text and replace all "\" with "/" but pyspark fail to read it as te...
- 8919 Views
- 4 replies
- 2 kudos
- 2 kudos
@orian hindi​ - Would you be happy to post the solution you came up with and then mark it as best? That will help other members.
- 2 kudos
- 6794 Views
- 8 replies
- 0 kudos
Hi All, I am trying to read a csv file from datalake and loading data into sql table using Copyinto. am facing an issue   Here i created one table wit...
Hi All,I am trying to read a csv file from datalake and loading data into sql table using Copyinto.am facing an issue Here i created one table with 6 columns same as data in csv file.but unable to load the data.can anyone helpme on this
- 6794 Views
- 8 replies
- 0 kudos
- 0 kudos
Thanks Werners for your Reply,How to pass schema(ColumnName && Types) to CSV file ??
- 0 kudos
- 8016 Views
- 4 replies
- 3 kudos
Resolved! Pyspark logging - custom to Azure blob mount directory
I'm using the logging module to log the events from the job, but it seems the log is creating the file with only 1 lines. The consecutive log events are not being recorded. Is there any reference for custom logging in Databricks.
- 8016 Views
- 4 replies
- 3 kudos
- 3 kudos
@karthick J​ - If Jose's answer helped solve the issue, would you be happy to mark their answer as best so that others can find the solution more easily?
- 3 kudos
- 1140 Views
- 0 replies
- 0 kudos
SQL server error
What is SQL Server 80004005 error? How to fix?
- 1140 Views
- 0 replies
- 0 kudos
| User | Count |
|---|---|
| 1614 | |
| 771 | |
| 349 | |
| 286 | |
| 253 |
