Writing Data into DataBricks

Question

Hi All,

I'm trying to load the data from SQL to Databricks and have referred the following:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Configure-a-Databricks-Connection/ta-p/414235?lightbox-message-images-414235=62794iB37B4ADF99286522

I'm able to connect to the databricks through the Alteryx but not able to write to it.

Error (I have tried both the outputs CSV and AVRO):

Error: Data Stream In (9): Executing PreSQL: "CREATE TABLE sample-jai
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
STORED AS INPUTFORMAT
'org.apache.had..." : [Simba][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error running query: org.apache.spark.sql.catalyst.parser.ParseException:
mismatched input '-' expecting <EOF>(line 1, pos 19)

hhaigh1 · Accepted Answer

Hi @jbudati

It looks like it doesn't like the - (dash) in the table name. I would try a table name with only letters.