Hi
I have sql data which is more than 34 GB , at present I'm using input tool to extract data into alteryx
my end goal is to create yxdb
it is taking more than 30 mins to extract data
is there anyway where i can extract data quickly.
Why are you creating the yxdb though?
Do you need all the fields and rows?
If you must have a yxdb, I would be using inDB tools to filter down to the values you want before pulling into local memory.
I have removed few columns
I need all the rows because I have to do joint with other table
is there any way for this?
Hi @BRRLL99,
Is there a particular reason why you need all 34GB of data in the yxdb?
If not, like cmcclellan suggested, you can use the IN-DB tools to select, filter, and aggregate the data to make it much smaller and then save it to yxdb.
