Failure: DQL statements are not allowed.

The ELT Execute Snap does not support Data Query Language (DQL) and hence statements containing SELECT and WITH are not allowed.

Remove any DQL statements (containing SELECT, WITH) and enter one of the following statement types:

• Data Definition Language (DDL): CREATE, ALTER, DROP, TRUNCATE, RENAME and so on. 

• Data Control Language (DCL): GRANT, REVOKE

• Data Manipulation Language (DML): INSERT, UPDATE, DELETE, MERGE, CALL and so on.

No matching signature for operator = for argument types: INT64.

(Target CDW: BigQuery)

Cast any non-String Pipeline parameter used in your SQL statement to its target data type for the Snap to work as expected.

Ex: Consider using SELECT * FROM pipe.param01 WHERE id = cast( _id as INT ); instead of SELECT * FROM pipe.param01 WHERE id = _id;

Keyword RANGE is not acceptable as a column name.

(CDW: Databricks Lakehouse Platform)

[Simba][SparkJDBCDriver](500051) ERROR processing query/statement. Error Code: 0

Cannot create table ('<schema name>`.`<table name>`'). The associated location (`…<table name>`) is not empty but it's not a Delta table

(Target CDW: Databricks Lakehouse Platform)

The specified location contains one of the following:

• A non-Delta table (such as CSV, ORC, JSON, PARQUET)

• A corrupted table

• A Delta table with a different table schema

So, the Snap/Pipeline cannot overwrite this table with the target table as needed.

Ensure that you take appropriate action (mentioned below) on the existing table before running your Pipeline again (to create another Delta table at this location).

Move or drop the existing table from the schema manually using one of the following commands:

Access the DBFS through a terminal and run:

• dbfs mv dbfs:/<current_table_path> dbfs:/<new_table_path> to move the table or

• dbfs rm -r dbfs:/<table_path> to drop the table.

OR

Use a Python notebook and run:

• dbutils.fs.mv(from: String, to: String, recurse: boolean = false): boolean to move the table/file/directory or

• dbutils.fs.rm(dir: String, recurse: boolean = false): boolean to drop the table/file/directory.

[Simba][SparkJDBCDriver](500051) ERROR processing query/statement. Error Code: 0

Cannot create table ('<schema name>`.`<table name>`'). The associated location (`…<table name>`) is not empty but it's not a Delta table

(CDW: Databricks Lakehouse Platform)

A non-Delta table that currently exists is corrupted and needs to be dropped from the schema before creating a Delta-formatted table.

However, this corrupted table can only be dropped manually—by accessing the DBFS through a terminal. The Pipeline cannot perform this operation.

Drop the corrupted table and then try creating the new table in Delta format (using the Pipeline).

To drop the corrupted table, from the terminal, access the DBFS and run the following command:

dbfs rm -r dbfs:/<table_path>

Syntax error when database/schema/table name contains a hyphen (-) such as in default.schema-1.order-details.

(CDW: Azure Synapse)

Cannot execute bigger SQL queries.
The operation failed due to a quota of no more than 32500 Literals per Query, the actual value is 35080.

(CDW: Azure Synapse)

The SQL query should not exceed the maximum allowed limit of 32500 Literals per Query. 

 http://aka.ms/dwsoftlimits for more details

Fail to populate 1000 rows.

Not enough resources for query planning - too many subqueries or query is too complex.

(CDW:Big Query)

Split one large SQL query into two or more simple ones or request a higher quota limit from Google BigQuery.