Hello! we are trying to use Fivetran for ingesting different sources into the data lake so we will have multiple connectors. We would like to know what are the recommendations when selecting the SQL warehouses. Since the new serverless SQL warehouses are capable of autoscaling, we were wondering if having a single Destiny(since the idea is to have a catalog by environment so we will have multiple schemas into the same catalog but coming from different sources) would be enough. We would like to understand pros/cons for not only performance but also cost.
Thanks!
