Distinguish active and dead jobs

Learn how to distinguish between active and dead Databricks jobs....

Spark job fails with Driver is temporarily unavailable

Job failure due to Driver being unavailable or unresponsive....

How to delete all jobs using the REST API

Learn how to delete all Databricks jobs using the REST API....

Job cluster limits on notebook output

Job clusters have a maximum notebook output size of 20 MB. If the output is larger, it results in an error....

Job fails, but Apache Spark tasks finish

Your job fails, but all of the Apache Spark tasks have completed successfully. You are using spark.stop() or System.exit(0) in your code....

Job fails due to job rate limit

Learn how to resolve Databricks job failures due to job rate limits....

Create table in overwrite mode fails when interrupted

Learn how to troubleshoot failures that occur when you rerun an Apache Spark write operation by cancelling the currently running job....

Apache Spark Jobs hang due to non-deterministic custom UDF

Learn what to do when your Apache Spark job hangs due to a non-deterministic custom UDF....

Apache Spark job fails with Failed to parse byte string

Apache Spark job fails with a Failed to parse byte string error....

Apache Spark UI shows wrong number of jobs

Apache Spark UI shows the wrong number of active jobs....

Apache Spark job fails with a Connection pool shut down error

Apache Spark job fails with a java.lang.IllegalStateException: Connection pool shut down error....

Job fails with atypical errors message

Job run is throttled and fails due to observing atypical errors message....

Apache Spark job fails with maxResultSize exception

Refactor your code, increase the driver maxResultSize, or enable Cloud Fetch....

Databricks job fails because library is not installed

Learn how to prevent Databricks jobs from failing due to uninstalled libraries....

Job failure due to Azure Data Lake Storage (ADLS) CREATE limits

Learn what to do when your Databricks job fails due to Azure Data Lake Storage CREATE limits....

Job fails with invalid access token

Jobs that run more than 48 hours fail with invalid access token error when the dbutils token expires....

How to ensure idempotency for jobs

Learn how to ensure that jobs submitted through the Databricks REST API aren't duplicated if there is a retry after a request times out....

Streaming job has degraded performance

Streaming job has poor performance after stopping and restarting from same checkpoint....

Task deserialization time is high

Configure cluster-installed libraries to install on executors at cluster launch vs executor launch to speed up your job task runs....

Pass arguments to a notebook as a list

Use a JSON file to temporarily store arguments that you want to use in your notebook....

Uncommitted files causing data duplication

Partially uncommitted files from a failed write can result in apparent data duplication. Adjust VACUUM settings to resolve the issue....

Multi-task workflows using incorrect parameter values

If parallel tasks running on the same cluster use Scala companion objects the wrong values can be used due to sharing a single class in the JVM....

Job fails with Spark Shuffle FetchFailedException error

Disable the default Spark Shuffle service to work around a FetchFailedException error....

Users unable to view job results when using remote Git source

Databricks does not manage permission for remote repos, so you must sync changes with a local notebook so non-admin users can view results....

Single scheduled job tries to run multiple times

Ensure your cron syntax is correct when scheduling jobs. A wildcard in the wrong space can produce unexpected results....

Add custom tags to a Delta Live Tables pipeline

Manually edit the JSON configuration file to add custom tags....

Update notification settings for jobs with the Jobs API

You can use the Jobs API to add email notifications to some, or all, of the jobs in your workspace....

Stop all scheduled jobs

Use the included sample code to stop all of your scheduled jobs in the workspace....

Notebook stopping with file read error even if operation or command is still executing

Consider using Databricks Jobs for long-running operations. ...

Permissions error when trying to run job clusters

Ensure that the service principal has the 'Service Principal User' role....

Idle clusters causing inefficient resource use and increased costs

Set file arrival triggers....

Error when trying to create more new jobs than the limit quota

Confirm the amount of jobs you have in your workspace, then identify and delete the jobs you do not need....

Databricks cannot access a notebook in GitHub

Check your file type or GitHub credentials and permissions....

Unable to pass a param string value of more than 65,535 characters in a workflow using a JAR in a job

Pass the param using a text file in Workspace FileSystem (WSFS). ...

Trigger a job as a specific user with "Run As"

Use the UI or API to run a job as a specific user....

Need to see job creator when investigating a job but can only see service principal

Leverage the API to retrieve job creator details....

'Cluster does not support jobs workload' error during notebook or job run

Use a cluster policy that allows the dbutils.notebooks.run API, or run the code directly within a notebook to avoid the API. ...

Getting NullPointerException when using dbutils.secrets.get in jar jobs

Include the necessary dependencies for dbutils....

Filter condition in the for each task type not filtering correctly

Use param = :Param instead. ...

Jobs running longer than expected with 'Metastore_Down' events in event log

Run the VACUUM command to remove stale files, adjust the catalog update thread pool size in Databricks Runtime 14.3 LTS and above, or for read-only metastore databases, disable Delta catalog updates. ...

Previously working jobs now failing to execute with METASTORE_DOES_NOT_EXIST error

Only use the Databricks update job API to update the job cluster....

“No module named” error for dependent libraries within a job task

Set the libraries at the compute level for all-purpose compute, share libraries between tasks in non-serverless job clusters, or select from other options provided....

Job to insert Parquet file to table fails with error (FAILED_READ_FILE.PARQUET_COLUMN_DATA_TYPE_MISMATCH)

Fix the Parquet file’s schema to match the table’s schema....

String aggregation queries failing with data type mismatch error on serverless compute

Use explicit casting or disable ANSI_MODE....

Job with string data failing with [CAST_OVERFLOW_IN_TABLE_INSERT] overflow error

Change the data type of the source to an equivalent type as the target....

How to fetch the CREATE job JSON using an API call instead of the UI

Use the ‘settings’ key in the ‘/api/2.1/jobs/get’ API endpoint....

JDBC write operation fails with HiveSQLException error: The background threadpool cannot accept new task for execution

Change the spark.hive.server2.async.exec.threads, spark.hive.server2.async.exec.wait.queue.size, and spark.hive.server2.async.exec.keepalive.time configs to handle more concurrent asynchronous queries. ...

Error “number of currently active jobs exceeds hard limit of spark.databricks.maxActiveJobs” when trying to run an API request

Optimize job design first to the extent possible, then change the spark.databricks.maxActiveJobs setting to N, depending on your needs. ...

Can’t edit jobs created using Databricks Asset Bundles (DABs) using the UI

Disconnect the job from the source to make the job editable in the UI, or programmatically change the edit_mode field to “EDITABLE”....

Inconsistent job performance with shuffle-intensive workloads

Use an instance series with locally-attached NVMe SSD....

Invalid cron syntax error when scheduling multiple values in a job’s day-of-week field

Use job linkage to manage each day-of-week requirement individually....

Apache Airflow-triggered jobs terminating before completing

Increase the job timeout threshold on the Airflow side....

Unable to select a single node cluster when using the default job compute policy

Create a custom job policy....

The dbt option is missing from menu options during job creation

The dbt task option appears in the jobs UI only if your workspace is on the premium or enterprise tier with Databricks Repos (Git integration) enabled....

Cannot see API-created jobs in job run and job tabs in the UI

Either retrieve the job information also using the jobs/runs/get API, or use the Jobs API to create searchable jobs....

How to prevent a job hanging at an external API call step

Add timeouts and error handling. ...

Apache Spark job failing with SparkException: Job aborted due to stage failure error on dedicated compute

Execute queries involving fine-grained access control (FGAC) on standard compute....

Concurrent execution of CREATE OR REPLACE FUNCTION statements leads to intermittent ROUTINE_NOT_FOUND errors

Avoid recreating UDFs frequently, implement retry logic, or use explicit DROP and CREATE for UDFs....

How to configure a service principal with Git credentials for jobs with Git source

Add Git credentials for a service principal using the API....