Calgary : what is the use case ?

[simonaubert_bd]

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

[ShankerV]

@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

[ShankerV]

@simonaubert_bd 

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....

Many thanks

Shanker V

[Felipe_Ribeir0]

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.

[Felipe_Ribeir0]

Here i found an explanation that seems to make sense https://www.theinformationlab.co.uk/2014/05/23/alteryx-tools-focus-calgary-tools/

[simonaubert_bd]

@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.