How to Forward Data from Aspects LRS (Ralph/ClickHouse) to an External Database

Hi @Omer_Hameed! I’m so happy to hear everything is working well for you. I don’t believe we currently have any documentation about getting data out of Clickhouse, your best bet would be to look at the CH or SQL documentation. From a quick Google search, it seems like most articles are about getting data INTO clickhouse, so you may have to export data to a csv and then import into SQL.

I would recommend using the CH data over Ralph because the data in CH is the result of pulling out important fields from the original xAPI strings and performing many transformations to populate various data tables (enrollments, video watches, problem attempts, engagement, etc). If you have questions on where to find different data within Clickhouse, you can refer to the dbt docs here, the Aspects documentation here, or post your question for the community and use the Aspects tag.

Hope this helps!