sql data into Alteryx

[BRRLL99]

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.

[cmcclellan]

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.

[BRRLL99]

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?

[martinding]

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.

[martinding]

@BRRLL99 

You can use the In-DB Join Tool 

You can also have a look at some tutorial videos on youtube, if these In-DB tools are new to you.

https://www.youtube.com/watch?v=GGkEd3KoMj0

https://www.youtube.com/watch?v=-Vu-IiBDbkM

[BRRLL99]

@martinding @cmcclellan 

is it possible to connect to IN DB tool with sql using IP Address

[martinding]

Hi @BRRLL99,

As far as I know, you can't just use an IP address to connect.

To connect to SQL using InDB, you will need to use the Connect In-DB tool, and you will need to choose one of the possible connections in the drop down.