May be a slightly different use case but moving from BigQuery to managed Clickhouse on clickhouse.com has been pretty great. Easy data injection, super fast querying, lots of control over the environment, and a nice SQL console for quickly looking at the data.