community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Extracting the DDL

Highlighted
Alteryx Partner

I have a very unique problem - I need to extract the DDL and save along with the data in the workflow.

 

Attached are 2 files, the CSV and the workflow to process it - basically to set the datatypes to the proper format.

 

But obviously saving as CSV means that you lose the datatypes that have been defined.

 

I understand that I really need to write to a database in order to get the proper DDL, but is there a way to get generic/ANSI SQL - something that might work as a CREATE TABLE in (almost) any RDBMS ?

Pulsar

Hi @cmcclellan

 

While there may be an automated way to do this type of thing that i'm not aware of, I've always built up the required SQL as a string.  I'd start with the Field Info tool to get the required metadata for the dataset and then add in the correct boiler plate for ANSI-SQL Create, Insert, Update etc.

 

Dan

Alteryx Partner

That's EXACTLY what I was looking for :) :) 

 

I've used Field Info before, but for some reason I just didn't think of it in this case :)

Labels