197 karma · joined May 29, 2022
I disagree though it is activated immediately, or at least to me with venv I always have to activate it explicitly.
also business rules, no?
Also, what's the benefit of Python then in this case? Ergonomically, Go isn't shabby, Rust is another story though.
It's a cool example, but really an antipattern. Nowadays everyone gets analysts want access to raw data, since they know which aggregations they need best, whereas data engineers stay away from pre-aggregating and focus on building self-service data access tooling. Win-win this way.
How about building a duckdb accessible catalog on top of s3? Like instead of read_parquet, you would select from tables, which themselves would be mapped to s3 paths aka external tables.
In theory, it sounds great, but in practice you indeed lose database-specific operators, you should restrain from using database-specific optimisations, etc...