Writing Data into DataBricks

[jbudati]

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-Conne...

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)

[HenrietteH · Accepted solution]

Hi @jbudati 

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