I dont understand the reason for

Question

I dont understand the reason for <https orion docs prefect io collections catalog |Collections> For example there is a SQLAlchemy Collection which can use `prefect sqlalchemy database sqlalchemy execute` to send a SQL statement to a DB But I can do that with with the sqlalchemy python library directly and write flows around that I must be missing the point

Michiel Verburg · Answer

I also do not understand the use case yet to be completely honest with you sweat smile

Anna Geller · Answer

Collections are entirely optional Their main purpose is easy integration with a wide variety of systems without you having to write that code e g code to talk to SQL alchemy

Anna Geller · Answer

Think of it the same way as any Python package sure you could use CSV reader but you could also import a CSV file in a single line of Pandas Additionally collections have blocks which allow to combine business logic with secure configuration and credentials data

merlin · Answer

I guess sqlalchemy isnt the best example I see the slack alert one incudes decorators its convenient to use the collection vs write similar code for each application edit <https khuyentran1401 github io prefect alert |prefect alert> labelled as Alert on Collections page This makes the usage more clear to me Thanks again