- 2492 Views
- 1 replies
- 0 kudos
Optimize and Vaccum Command
Hi team,I am running a weekly purge process from databricks notebooks that cleans up chunk of records from my tables used for audit purposes. Tables are external tables. I need clarification on below items1.Should I need to run Optimize and Vacuum c...
- 2492 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi Ramakrishnan83,1. Vacume commands only work with delta tables, Vacume command will delete the parquet files older than the retention period which is by default 7 days. Optimize will rather club the files in case any special serial is provided.2. ...
- 0 kudos
- 2615 Views
- 2 replies
- 1 kudos
Resolved! How can I Learn Databricks Data Pipeline in Azure environment?
Hello Esteemed Community,I have a fundamental question to ask, and I approach it with a sense of humility. Your guidance in my learning journey would be greatly appreciated. I am eager to learn how to build a hands-on data pipeline within the Databri...
- 2615 Views
- 2 replies
- 1 kudos
- 1 kudos
Hey @kazinahian I completely understand your hesitation and appreciate your approach to seeking guidance! Embarking on a learning journey can be daunting, especially when financial considerations are involved. I'm happy to offer some advice on buildi...
- 1 kudos
- 6550 Views
- 4 replies
- 1 kudos
Error. Another git operation is in progress.
I am getting an error every time I try to view another branch or create a branch. Sometimes this has happened in the past, but usually seems to fix itself after about 10-30 minutes. This error has been lasting for over 12 hours, so I am now concerned...
- 6550 Views
- 4 replies
- 1 kudos
- 1 kudos
I had the same problem and I could resolve it by creating the repo again with a trailing ".git" in the Git repository URL.For example, use thishttps://gitlab.mycompany.com/my-project/my-repo.gitnot this:https://gitlab.mycompany.com/my-project/my-repo...
- 1 kudos
- 3630 Views
- 3 replies
- 0 kudos
Unable to enable entitlements to account groups in a workspace
Currently, I am both an account administrator and also a workspace administrator in Databricks.When I try to enable the entitlements "Workspace access" and "Databricks SQL access" to account groups I am receiving the error "Failed to enable entitlem...
- 3630 Views
- 3 replies
- 0 kudos
- 0 kudos
Hi @Arnold_Souza, The error "Failed to enable entitlement.: Group not found" that you're experiencing when trying to enable the entitlements “Workspace access” and “Databricks SQL access” for account groups is likely due to the fact that Identity Fed...
- 0 kudos
- 6151 Views
- 4 replies
- 0 kudos
CSV Reader reads quoted fields inconsistently in last column
I just opened another issue: https://issues.apache.org/jira/browse/SPARK-46959It corrupts data even when read with mode="FAILFAST", i consider it critical, because basic stuff like this should just work!
- 6151 Views
- 4 replies
- 0 kudos
- 0 kudos
either: [ 'some text', 'some text"', 'some text"' ]alternatively: [ '"some text"', 'some text"', 'some text"' ]probably most sane behavior would be a parser error ( with mode="FAILFAST").just parsing garbage without warning the user is certainly not...
- 0 kudos
- 2457 Views
- 2 replies
- 0 kudos
Resolved! Databricks Asset Bundles - Manage existing jobs
Hello,we are starting to experiment with Databricks Asset Bundles, especially to keep jobs aligned between workspaces. Is there a way to start managing existing jobs, to avoid erasing previous runs history?Thank you,Tommaso
- 2457 Views
- 2 replies
- 0 kudos
- 2740 Views
- 1 replies
- 0 kudos
Resolved! Type 2 SCD when using Auto Loader
Hi there! I'm pretty new to using Auto Loader, so this may be a really obvious fix, but it's stumped me for a few weeks, so I'm hoping someone can help! I have a small csv file saved in ADLS with a list of pizzas for an imaginary pizza restaurant. I'...
- 2740 Views
- 1 replies
- 0 kudos
- 0 kudos
So, I figured out what the issue was. I needed to delete checkpoint folder. After I did this and re-ran the notebook, everything worked fine!
- 0 kudos
- 1700 Views
- 1 replies
- 0 kudos
SOAP API - Connection
HelloWe have a workflow in our team to perform usual monthly tasks to be ran on the first working day of the month.Each of the ~20 users will run a clone of this workflow most likely all around the same time but with different options. Because we don...
- 1700 Views
- 1 replies
- 0 kudos
- 0 kudos
maybe you can set a lock before call SOAP APIpython - Using a Lock with redis-py - Stack Overflow
- 0 kudos
- 1906 Views
- 1 replies
- 0 kudos
create an array sorted by a field
How do i create an array from a field while applying sorting?how do I do this in data brick since databricks does not support order by in array_agg? same is possible in Snowflake and(Array agg) or Redshift(listagg). SELECT ARRAY_AGG(O_ORDERKEY) WITH...
- 1906 Views
- 1 replies
- 0 kudos
- 0 kudos
%sql SELECT array_sort(array_agg(col) ,(left, right) -> CASE WHEN left < right THEN -1 WHEN left > right THEN 1 ELSE 0 END) arr_col FROM VALUES (3), (2), (1) AS tab(col); https://docs.databricks.com/en/sql/language-manual/functions/array_sort.h...
- 0 kudos
- 1835 Views
- 2 replies
- 0 kudos
Python Databricks how to run all cells in another notebook except the last cell
I have a Python Databricks notebook which I want to call/run another Databricks notebook using dbutils.notebook.run()... but I want to run all the cells in the "called" notebook except the last one.Is there a way to do a count of cells in the called ...
- 1835 Views
- 2 replies
- 0 kudos
- 0 kudos
In the alternative way, you can use dbutils.notebook.run to pass the parameters, and use dbutils.widgets.get in another notebook to get the parameter values,and determine the parameter values to decide whether to execute codes in the specified cellh...
- 0 kudos
- 3225 Views
- 1 replies
- 0 kudos
Resolved! Differences Between "TEMPORARY STREAMING TABLE" and "TEMPORARY STREAMING LIVE VIEW" in DLT
Hello Databricks community,I'm seeking clarification on the distinctions between the following two syntaxes:CREATE OR REFRESH TEMPORARY STREAMING TABLECREATE TEMPORARY STREAMING LIVE VIEWAs of my understanding, both of these methods do not store data...
- 3225 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @Kai, The two syntaxes you're asking about, CREATE OR REFRESH TEMPORARY STREAMING TABLE and CREATE TEMPORARY STREAMING LIVE VIEW, are used in Delta Live Tables and have distinct purposes. CREATE OR REFRESH TEMPORARY STREAMING TABLE: This syntax i...
- 0 kudos
- 4793 Views
- 5 replies
- 0 kudos
Resolved! Databricks asset bundles job and pipeline
Hello, I'm looking to create a job which is linked to a delta live table. Given the job code like this: my_job_name: name: thejobname schedule: quartz_cron_expression: 56 30 12 * * ? timezone_id: UTC pause_stat...
- 4793 Views
- 5 replies
- 0 kudos
- 0 kudos
@RyHubb You can specify the variable of the ID and it will be materialized at deploy time. No need to do this yourself. An example is at https://github.com/databricks/bundle-examples/blob/24678f538415ab936e341a04fce207dce91093a8/default_python/...
- 0 kudos
- 6890 Views
- 7 replies
- 0 kudos
Resolved! How to load xml files with spark-xml ?
Hello,I cannot load xml files.First, I tried to install Maven library com.databricks:spark-xml_2.12:0.14.0 as it is told in documentation, but I could not find it. I only have HyukjinKwon:spark-xml:0.1.1-s_2.10, with this one I have this error: DRIVE...
- 6890 Views
- 7 replies
- 0 kudos
- 4118 Views
- 2 replies
- 1 kudos
DBT JOBS FAILING
HI ,we have dbt workflow jobs and its been failing randomly from last few days with below error. is there any known issue for this , any help on the root cause will be helpful.Encountered an error: Runtime Error Database Error __init__() got an une...
- 4118 Views
- 2 replies
- 1 kudos
- 1 kudos
setting dbt-databricks==1.7.3 solved this issue but now we randomly get the below error . it gets fixed after restrating the cluster sometimes. but is there any permanent solution for this ? from dbt.events import types_pb2 File "/databricks/python3/...
- 1 kudos
- 1485 Views
- 1 replies
- 0 kudos
Restore sql editor
any Options restore sql editors query after workspace was accidentally deleted and restored
- 1485 Views
- 1 replies
- 0 kudos
- 0 kudos
@Andyt If the workspace is accidentally deleted, there is not way to retrieve content from SQL editor.
- 0 kudos
| User | Count |
|---|---|
| 1611 | |
| 768 | |
| 348 | |
| 286 | |
| 252 |
