dumb question on how to allow users to do analytics
hi team! im not there yet but im curious how can i offer analytics for my users. let's assume my user wants to click a button to generate a chart of the revenue per month for the past 12 months.
after reading some threads, i see folks here talking bout airbyte, dagster, duckdb, etc..
what's the correct mental model to think about this?
is it the case that i stream data out of convex via airbyte (cloud) to another server that hosts the duckdb? which means i can then set up my convex service to make an API call to the duckdb service for the revenue data?
pls feel free to correct my wrong understanding. thanks!
after reading some threads, i see folks here talking bout airbyte, dagster, duckdb, etc..
what's the correct mental model to think about this?
is it the case that i stream data out of convex via airbyte (cloud) to another server that hosts the duckdb? which means i can then set up my convex service to make an API call to the duckdb service for the revenue data?
pls feel free to correct my wrong understanding. thanks!
