- 5009 Views
- 1 replies
- 0 kudos
Azure Databricks: Cannot create volumes or tables
If I try to create a Volume, I get this error:Failed to access cloud storage: AbfsRestOperationException exceptionTraceId=fa207c57-db1a-406e-926f-4a7ff0e4afddWhen i try to create a table, I get this error:Error creating table[RequestId=4b8fedcf-24b3-...
- 5009 Views
- 1 replies
- 0 kudos
- 0 kudos
It seems like you are encountering issues with accessing cloud storage while trying to create a volume and a table in Databricks on Azure. The errors you are seeing, AbfsRestOperationException and INVALID_STATE.UC_CLOUD_STORAGE_ACCESS_FAILURE, indica...
- 0 kudos
- 4466 Views
- 15 replies
- 4 kudos
spotify API get token - raw_input was called, but this frontend does not support input requests.
hello everyone, I'm trying use spotify's api to analyse my music data, but i'm receiving a error during authentication, specifically when I try get the token, above my code.Is it a databricks bug?pip install spotipyfrom spotipy.oauth2 import SpotifyO...
- 4466 Views
- 15 replies
- 4 kudos
- 941 Views
- 1 replies
- 0 kudos
dbt writing parquet from Volumes to Catalog schema
I have ran into a weird situation, so I uploaded few parquet files (about 10) for my sales data into the Volume in my catalog, and run dbt againt it , dbt went successful and table was able to be created however when i upload a lot more parquet files...
- 941 Views
- 1 replies
- 0 kudos
- 0 kudos
When dealing with a large number of Parquet files (about 2500 in your case), the system might be running into resource limitations or timeouts. This can happen due to the sheer volume of data being processed at once. The failure might be due to insuf...
- 0 kudos
- 2187 Views
- 2 replies
- 0 kudos
VIEW JSON result value in view which based on volume
Hello guys!I have the following case:It has been decided that the json file will be read from a following definition ( from volume) , which more or less looks like this: CREATE OR REPLACE VIEW [catalog_name].[schema_name].v_[object_name] AS SELECT r...
- 2187 Views
- 2 replies
- 0 kudos
- 0 kudos
You must be getting the below error: [CONFIG_NOT_AVAILABLE] Configuration spark.sql.legacy.json.allowEmptyString.enabled is not available. that's because in a warehouse this config is not configurable. SQL editor won't be the best choice for this. ...
- 0 kudos
- 4413 Views
- 3 replies
- 0 kudos
UC Volumes: writing xlsx file to volume
How to write a DataFrame to a Volume in a catalog?We tried the following code with our pandas Dataframe:dbutils.fs.put('dbfs:/Volumes/xxxx/default/input_bestanden/x test.xlsx', pandasDf.to_excel('/Volumes/xxxx/default/input_bestanden/x test.xlsx')) T...
- 4413 Views
- 3 replies
- 0 kudos
- 0 kudos
I was able to upload, using dbutils.fs.cp('/FileStore/excel-1.xlsx', 'dbfs:/Volumes/xxx/default/xxx/x_test.xlsx') Maybe space in the name is causing an issue for you.
- 0 kudos
- 181 Views
- 0 replies
- 0 kudos
Databricks cluster selection
Compute is one of the largest portions of cost in Databricks ETL. There is not written rule to handle this. Based on experience I have put some thumb rule to set the right cluster. Please check below. https://medium.com/@infinitylearnings1201/a-compr...
- 181 Views
- 0 replies
- 0 kudos
- 1991 Views
- 4 replies
- 0 kudos
Migration of Synapse Data bricks activity executions from All purpose cluster to New job cluster
Hi,We have been planning to migrate the Synapse Data bricks activity executions from 'All-purpose cluster' to 'New job cluster' to reduce overall cost. We are using Standard_D3_v2 as cluster node type that has 4 CPU cores in total. The current quota ...
- 1991 Views
- 4 replies
- 0 kudos
- 0 kudos
I also see a difference in Photon, Enable Photon for workloads with large data scans, joins, aggregations, and decimal computations. Photon provides significant performance benefits over the standard Databricks Runtime.
- 0 kudos
- 2627 Views
- 1 replies
- 0 kudos
I am getting NoneType error when running a query from API on cluster
When I am running a query on Databricks itself from notebook, it is running fine and giving me results. But the same query when executed from FastAPI (Python, using databricks library) is giving me "TypeError: 'NoneType' object is not iterable".I can...
- 2627 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @Nastia , can you please share the entire stacktrace and the query that you are running. There is currently not much detail with which I can help you understand this. But it is totally possible it is a bug that's causing this, because there shoul...
- 0 kudos
- 774 Views
- 3 replies
- 2 kudos
Databricks Job API: The job must have exactly one owner
Hi Team,I'm trying to set the Job Permission using the Databricks Job API but getting the below error.{"error_code": "INVALID_PARAMETER_VALUE","message": "The job must have exactly one owner."} I first tried to get the job permission using the below ...
- 774 Views
- 3 replies
- 2 kudos
- 2 kudos
Hi , I have tried the same approach but it ddint work for me. Iam using api/2.0 with PUT Request
- 2 kudos
- 6740 Views
- 2 replies
- 0 kudos
Pivot in Databricks SQL
Hi Team,I have a table that has a key column (column name) and value column (value of the column name). These values are generated dynamically and wanted to pivot the table.Question 1: Is there a way that we can do this without specifying all the col...
- 6740 Views
- 2 replies
- 0 kudos
- 0 kudos
PySpark can help to list the available columns .Please find the demo snippets as below Image 1. Image 2
- 0 kudos
- 619 Views
- 4 replies
- 1 kudos
Procedure of retrieving archived data from delta table
Hi all,I am currently researching on the archive support features in Databricks. https://docs.databricks.com/en/optimizations/archive-delta.htmlLet say I have enabled archive support and configured the data to be archived after 5 years and I also con...
- 619 Views
- 4 replies
- 1 kudos
- 1 kudos
@Walter_C Thank you for your reply. However, there are some part that might need your further clarification.Assume I already set the delta.timeUntilArchived to 1825days (5years) and I have configured the lifecycle policy align with databricks setting...
- 1 kudos
- 314 Views
- 2 replies
- 0 kudos
To identify deleted Runs in Workflow.Job UI in "system.lakeflow"
Hi,I executed a few runs in a Workflow.Jobs UI. I then deleted some of them. I am seeing the deleted runs in "system.lakeflow.job_run_timeline". How do i know which runs are the deleted ones? Thanks
- 314 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi @AlleyCat , Hope you are doing well! The jobs table includes a delete_time column that records the time when the job was deleted by the user. So to identify deleted jobs, you can run a query like the following: SELECT * FROM system.lakeflow.jobs ...
- 0 kudos
- 567 Views
- 3 replies
- 0 kudos
How to bring in databricks dbacademy courseware
I have created an account in dbacademy and signed up for advanced data engineering with databricks course. Also, I have subscribed to Vocareum lab as well. During the demo, tutor/trainer opened 'ADE 1.1 - Follow Along Demo - Reading from a Streaming ...
- 567 Views
- 3 replies
- 0 kudos
- 0 kudos
So, it appears that we no longer make the notebooks available with self-paced training. They are not available for download.
- 0 kudos
- 1504 Views
- 2 replies
- 0 kudos
Deploying Overwatch on Databricks (AWS) with System Tables as the Data Source
IntroductionOverwatch is a powerful tool for monitoring and analyzing your Databricks environment, providing insights into resource utilization, cost management, and system performance. By leveraging system tables as the data source, you can gain a c...
- 1504 Views
- 2 replies
- 0 kudos
- 0 kudos
hi @jiteshraut20, Thanks for your post. From my set up, validation seems to work.Wrote 32 bytes. Validation report has been saved to dbfs:/mnt/overwatch_global/multi_ow_dep/report/validationReport Validation report details Total validation count: 35 ...
- 0 kudos
- 732 Views
- 6 replies
- 0 kudos
Hive metastore federation, internal and external unable to connect
I enabled the internal hive on the metastore federation using this query commandCREATE CONNECTION IF NOT EXISTS internal-hive TYPE hive_metastoreOPTIONS (builtin true);But I can't get a password or username to access the JDBC URL.
- 732 Views
- 6 replies
- 0 kudos
- 0 kudos
Not really, what I want to achieve is connecting to an external hive but I do want to configure the external hive on our server to be able to interact with the Databricks cluster in such a way that I could have access to thrift protocol.
- 0 kudos
| User | Count |
|---|---|
| 1611 | |
| 768 | |
| 348 | |
| 286 | |
| 252 |
