sql data into Alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
