- 5214 Views
- 3 replies
- 0 kudos
Resolved! AmazonS3 with Autoloader consume "too many" requests or maybe not!
After successfully loading 3 small files (2 KB each) in from AWS S3 using Auto Loader for learning purposes, I got, few hours later, a "AWS Free tier limit alert", although I haven't used the AWS account for a while. Does this streaming service on ...
- 5214 Views
- 3 replies
- 0 kudos
- 0 kudos
Hi, ​​Auto Loader incrementally and efficiently processes new data files as they arrive in cloud storage. Auto Loader can load data files from AWS S3 (s3://), Azure Data Lake Storage Gen2 (ADLS Gen2, abfss://), Google Cloud Storage (GCS, gs://), Azur...
- 0 kudos
- 2380 Views
- 3 replies
- 7 kudos
Starting from #databricks runtime 12.2 LTS, implicit lateral column aliasing is now supported. This feature enables you to reuse an expression defined...
Starting from #databricks runtime 12.2 LTS, implicit lateral column aliasing is now supported. This feature enables you to reuse an expression defined earlier in the same SELECT list, thus avoiding repetition of the same calculation.For instance, in ...
- 2380 Views
- 3 replies
- 7 kudos
- 7785 Views
- 4 replies
- 23 kudos
Encrypt and decrypt personal data with Spark Databricks.We create a table that will include personal information. However, we want to hide personal id...
Encrypt and decrypt personal data with Spark Databricks.We create a table that will include personal information. However, we want to hide personal identifiers so no one can see them.We set a key. A key need to have 16, 24, or 32 bytes. 1 byte = 1 ch...
- 7785 Views
- 4 replies
- 23 kudos
- 23 kudos
@Hubert Dudek​ how can we decrypt the data outside of databricks with python? which is encrypted with aes_encrypt
- 23 kudos
- 2407 Views
- 2 replies
- 0 kudos
how to dynamically perform aggregation on all columns in a data frame even when some columns have different types like int , double string datetime or float in pyspark (i have 140-200 columns and need to perform aggregation/avg on each column)
need to aggregate all the numerical columns but need to this dynamically
- 2407 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi ​@sandeep tummala​ , Thank you for your question! To assist you better, please take a moment to review the answer and let me know if it best fits your needs.Please help us select the best solution by clicking on "Select As Best" if it does.Your fe...
- 0 kudos
- 1685 Views
- 2 replies
- 2 kudos
Resolved! newly created account not working and when changing password it is getting hangged
My community user account is not working
- 1685 Views
- 2 replies
- 2 kudos
- 8014 Views
- 4 replies
- 3 kudos
Resolved! Writing PySpark DataFrame onto AWS Glue throwing error
I have followed the steps as mentioned in this blog : https://www.linkedin.com/pulse/aws-glue-data-catalog-metastore-databricks-deepak-rajak/ but when trying to saveAsTable(table_name), it is giving an error as IllegalArgumentException: Path must be ...
- 8014 Views
- 4 replies
- 3 kudos
- 3 kudos
Hey @Raghu Bharadwaj Tallapragada​ Just wanted to check in if you were able to resolve your issue or do you need more help? We'd love to hear from you.Thanks!
- 3 kudos
- 1439 Views
- 1 replies
- 2 kudos
- 1439 Views
- 1 replies
- 2 kudos
- 2 kudos
Continuous Jobs trigger mode has been introduced recently. To prevent unnecessary resource usage and reduce cost, Databricks automatically pauses a continuous job if there are more than five consecutive failures within a 24 hour period.
- 2 kudos
- 2214 Views
- 1 replies
- 0 kudos
- 2214 Views
- 1 replies
- 0 kudos
- 0 kudos
The UNPIVOT clause is now supported by Databricks SQL. Use the UNPIVOT clause to rotate columns of a table-valued expression into column values https://docs.databricks.com/sql/language-manual/sql-ref-syntax-qry-select-unpivot.html
- 0 kudos
- 13979 Views
- 8 replies
- 8 kudos
How to enable interactive Python matplotlib figures in DataBricks?
I want to make a matplolib interactive (I can zoom in/out, etc.) in databricks. This is achieved in Jupyter notebook by the following code: %matplotlib notebookHow to achieve this in databricks?Thank you
- 13979 Views
- 8 replies
- 8 kudos
- 8 kudos
Hi there, while facing a similar issue we switched to Altair python library and it works great with Databricks. (other options can be Bokeh or Plotly).
- 8 kudos
- 3980 Views
- 1 replies
- 2 kudos
Resolved! What to do when you face this error "Please delete your streaming query checkpoint and restart"
- 3980 Views
- 1 replies
- 2 kudos
- 2 kudos
The best way is to run a full refresh.
- 2 kudos
- 1225 Views
- 1 replies
- 2 kudos
- 1225 Views
- 1 replies
- 2 kudos
- 2 kudos
You will have to do a full refresh.
- 2 kudos
- 8430 Views
- 3 replies
- 0 kudos
How to trigger workflow job tasks from Autoloader
I have configured a File Notification Autoloader that monitors S3 bucket for binary files. I want to integrate autoloader with workflow job so that whenever a file is placed in S3 bucket, the pipeline job notebook tasks can pick-up new file and start...
- 8430 Views
- 3 replies
- 0 kudos
- 0 kudos
Hi @Saravanan Ponnaiah​ Hope everything is going great.Does @odoll odoll​ response answer your question? If yes, would you be happy to mark it as best so that other members can find the solution more quickly?We'd love to hear from you.Thanks!
- 0 kudos
- 2610 Views
- 2 replies
- 1 kudos
Resolved! Font in Databricks Notebook is Greyed Out - Glitchy
The monospaced/code font in my databricks notebooks is greyed out, both in light and dark theme. I've tried playing with all the notebook settings, etc. and nothing will make the font 'normal'. I've tried Chrome and Edge, and the results are the same...
- 2610 Views
- 2 replies
- 1 kudos
- 1 kudos
I was having this exact same issue. I fixed it by uninstalling the Source Code Pro font from my Windows machine.
- 1 kudos
- 4426 Views
- 10 replies
- 1 kudos
DataBricks
How to find Mountpoints definitions
- 4426 Views
- 10 replies
- 1 kudos
- 1 kudos
Hi @Govardhana Reddy​ Glad to hear!Please mark the answer as best, it will be highly appreciable.Have a great day!Regards
- 1 kudos
- 3513 Views
- 4 replies
- 1 kudos
Resolved! How can I get date when autoloader processes the file
Hi,I am running autoloader which is running continuously and checks for new file every 1 minute. I need to store when file was received/processed but its giving me date when autoloader started. Here is my code.df = (spark .readStream .format("clo...
- 3513 Views
- 4 replies
- 1 kudos
- 1 kudos
Hi @Sanjay Jain​ , You can use the File Metadata column functionality to collect that information.Ref doc:- https://docs.databricks.com/ingestion/file-metadata-column.html
- 1 kudos
| User | Count |
|---|---|
| 1611 | |
| 768 | |
| 348 | |
| 286 | |
| 252 |
