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.
I came across one requirement where there is around 23 M records at source((MS SQL) and every time i need to pull the data from SQL Server for alteryx workflow which is very time consuming .
I am looking for any way / better way to append data in .yxdb file in recent version of alteryx or any other better approach to append data. Volume of data around 23 Millions and every day around 20 K record will be added.
Thanks for your reply, but i do not want data to be maintain in separate yxdb file as from maintenance stand point we need to maintain data for last several year for analysis purpose, Any idea on appending data in calgary (.cycb ) or open source data SQLite, Any better approach which suits such requirement.