Null column values display as NaN

Null column values correctly display as NaN in Databricks SQL....

Retrieve queries owned by a disabled user

How to retrieve queries owned by a disabled user in Databricks SQL....

Job timeout when connecting to a SQL endpoint over JDBC

Increase the SocketTimeout value in the JDBC connection URL to prevent thread requests from timing out....

Slowness when fetching results in Databricks SQL

Ensure that cloud fetch is enabled for best performance when using ODBC/JDBC to fetch results....

ZORDER results in "Hilbert indexing can only be used on 9 or fewer columns" error

OPTIMIZE ZORDER BY command has a hard limit of nine columns....

Cannot customize Apache Spark config in Databricks SQL warehouse

You can only configure a limited set of global Spark properties when using a SQL warehouse....

SQL warehouse launch fails to start with "PERMISSION_DENIED"

Provide the owner with unrestricted cluster creation permissions or workspace admin permissions....

Update the Databricks SQL warehouse owner

Learn how to use the API to transfer ownership of a SQL warehouse to a new owner...

Unable to use dynamic variable passing to create a function in Databricks SQL Warehouse

Use a Python UDF in a notebook to dynamically pass the table name as a variable, then access the function in a notebook or DBSQL. ...

Error running parameterized SQL queries in Databricks Connect with VS Code

Pass the SQL parameter in Databricks Connect using string interpolation. ...

Databricks SQL ANSI enablement guide

Learn how to enable ANSI SQL for your existing Databricks workloads....

spark.rpc.message.maxSize error after running DESCRIBE HISTORY in SQL warehouse

You must limit or prune the query when using DESCRIBE HISTORY on large history logs....

DeltaInvariantViolationException: Exceeds char/varchar type length limitation error when writing a Delta table

...

Redshift queries using Lakehouse Federation taking longer than expected

Make JDBC fetchsize adjustments or use the COPY UNLOAD method....

PySparkAssertionError: Received incorrect server side session identifier for request

You must detach and reattach to reset the state....

Error 'View/Table Does Not Exist' during model or query runtime in SQL Analytics

Use the command ALTER VIEW to update the view definition....

Unable to read external Hive Metastore tables on SQL warehouses

Manually set the appropriate Apache Spark configurations in your admin settings for SQL warehouses....

Using percentile() to work with large datasets causing memory issues or OOM errors

Use approx_percentile() instead. ...

Databricks SQL Warehouse query finish with cache is not populating ‘open in Spark UI’ option

When a query uses 100% of the cache, there are no corresponding Spark jobs or stages to display in Spark UI....

Jobs in SQL Warehouse returning 403 error

Modify the service account permissions, regenerate the token, and verify permissions are set....

Serverless query still running after canceling

Run the CANCEL command and configure a query timeout....

Photon ran out of memory while executing query

Ensure up-to-date statistics on all tables, simplify complex queries, or use Databricks Runtime 13.3 LTS or above. ...

‘Query timeout due to inactivity’ error when using the SQL execution API

Obtain a statement ID from the pending POST API call and make a GET API call instead. ...

ORC tables not recognized when processed in serverless warehouses

Recreate the ORC table as an Apache Spark format ORC table with "USING ORC" instead....

Filtering data with char(255) datatype column does not retrieve a result

Remove the blank space from the right side of the column, cast the column name as a string type, or upgrade to Databricks Runtime 15.4 LTS or above. ...

COPY INTO not loading new data to destination table

Use the ‘force’ = ‘true’ option in COPY_OPTIONS....

Changing ANSI mode inline doesn’t work when querying a view

Recreate the view with the ANSI mode you need, or use try_cast, try_add, or try_divide in query operations that are not ANSI compliant. ...

Using double quotes in a query causes a syntax error

Enable the doubleQuotedIdentifiers setting in your Spark configuration and set spark.sql.ansi.enabled to true....

New columns added to a table are not reflecting in a view

Rebuild the existing view or recreate the view using WITH SCHEMA EVOLUTION....

Not receiving emails from DBSQL alerts

Unblock noreply@databricks.com email from block list....

Error [DELTA_MERGE_INCOMPATIBLE_DECIMAL_TYPE] when performing a merge operation in Databricks Runtime 14.3 LTS or above

Set spark.sql.legacy.decimal.retainFractionDigitsOnTruncate to true or use the cast function to explicitly cast the columns to a specific decimal type....

Find long running queries in your SQL warehouse

Use the query history feature....

Creating a temporary view inside a function returns an [INVALID_TEMP_OBJ_REFERENCE] error

Make the function temporary so both the function and the temporary view have the same lifespan and session scope....

You want to declare temporary variables inside a function in Databricks SQL

Use CTEs to declare temporary variables....

Query using COPY INTO using a direct file directory pattern fails with “ERROR: Job aborted due to stage failure” OOM error

Use INSERT INTO with read_files() instead....

ETL jobs failing in Databricks SQL when casting Oracle NUMBER columns to Delta tables

Store numeric values with precision greater than DECIMAL(38,8) as strings and use Python’s decimal module via UDFs for high-precision arithmetic....

DOUBLE data type-defined columns lose precision for values exceeding 15 significant digits

Convert the column from DOUBLE to DECIMAL(p,s) using ALTER TABLE to preserve full numeric precision....

Using parse_json and explode to flatten data returns [DATATYPE_MISMATCH.UNEXPECTED_INPUT_TYPE] error

Use the variant_get or variant_explode function to cast the payload to ARRAY first....

SQL warehouse will not launch after upgrading to serverless

Remove the overriding runtime version from the SQL warehouse configuration....

PERMISSION_DENIED error while trying to start a SQL warehouse

Make sure the SQL warehouse owner is an active member of the workspace....

How to pass parameters from workflow to a SQL notebook

Streamline dynamic SQL execution with parameterized queries and workflow configurations....