Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

getting error in output tool while creating table

Sree2527
5 - Atom
hi, I am trying to create a simple table using output tool based on the input tool fields and throwing below error. 
 
Error: Output Data (2): Error creating table "schema.table": [Simba][BigQuery] (70) Invalid query: Type not found: char at [1:54]
CREATE TABLE `schema`.`table` (`location_nam` char(16384),`tim_zone_bq_id` char(16384))
Could you please provide any solution for this.
 
2 REPLIES 2
HomesickSurfer
12 - Quasar

Hi @Sree2527 

 

I will need more insight to your workflow, however, have you tried chaining TABLE, LAYOUT and RENDER tools instead of the output tool?  This offers more features and customization.

mceleavey
17 - Castor
17 - Castor

Hi @Sree2527 ,

 

if you're trying to write to Google Big Query there are tools that allow you to do that.

 

You can download them HERE.

 

M.



Bulien

Labels