This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The highly anticipated Alteryx Community tradition is back! We hope you'll join us!
This would be a game changer!
Thanks for the tip ned, we will give SQLite a try today. It's really great.
I think a few of users were trying to read write and then append back to yxdb.
SQLLite works like a charm! Really encourage other users to try this.
Thank you Ned! Been wondering about that!
Ned- Thanks for your response and I understand where you are coming from. One difficulty we face (and one that I bet is quite common) is that any setting up of additional software requires IT / admin rights for installation, maintenance, etc. I can't even download SQLite to try it out without IT's involvement. Hence, being able to append to the native Alteryx database would save us a fair amount of startup time.
That said, we will look into SQLite as a way of appending, as this is a function we need. Our files are too large to continue appending as CSV, XLSX, but our organization isn't really big enough to maintain a true enterprise data warehouse.
You don't need to download SQLite. It is built in to the Alteryx Input and Output tools. No drivers or anything required.
Ned - correct me if I'm wrong, but I see about a 3x increase in file size if I go from YXDB to SQLLITE. Does that seem right? My input is simply a YXDB. No tools in between. Just a YXDB input and a SQLLITE output. But the file size goes from about 50MB to 150MB.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.