Hello,Ok, it may be a stupid question : why should one use Calgary? What is the use case ? Does it perform better than yxdb? Is it even like a database?Best regards,Simon
@simonaubert_bd
Upto my knowledge, Calgary database engine within Alteryx gives us the ability to create a large indexed database that provides rapid retrieval of data and/or counts.
Many thanks
Shanker V
Found this article, which might be useful containing all the details which we were looking for.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Create-a-Calgary-Database/ta-p/511848#:~:text=A%20Calgary%20Database%20is%20a,read%20in%20all%20the%20data.
Good question! Even knowing the basic theory behind it, i cant really say a particular situation where this would be really useful and never knew someone really using it to ask about.
If someone could share a known use case and explain why cagalry was the choice instead of using yxdb/flat file/database, it would be cool.
Here i found an explanation that seems to make sense https://www.theinformationlab.co.uk/2014/05/23/alteryx-tools-focus-calgary-tools/
@ShankerV @Felipe_Ribeir0 Thanks. I found that too but it seems reaaaaaaaally a niche usage.If I want to use it with Alteryx, yxdb is fine and there is no limits in file size while Calgary is less than 2 Billions rows.If not to be used with Alteryx specifically, I would use a vertica/monetdb or something like that.
