ChaoticKitten
PowerBI/PowerQuery can't connect to Postgres database due to ssl validation error
@volcanicislander
Thank you for the messages!
It's a splendid idea that could work in a pinch I believe. I'm specialized in Data Engineering so naturally I found a solution that's a bit overkill but works for my needs - in this case creating a flow that takes sql queries, runs them against the DB securely and saves encrypted files locally as parquet.
Upsides:
Parquet is smaller than csv
Total processing time is roughly a few seconds because I did a bit of extra wizardry with the database queries
I unencrypt and unpack the parquet files directly in PowerBI
Downsides:
The DAG is not flexible enough for quick emergency analytics
Parquet is finicky
Still not a direct connection
Better alternatives would be to:
* use SQLAlchemy or something similar straight in PowerBI's python.
* go your way with downloading certificates locally
* creating an intermediary database locally and daisy chaining the queries between railway and local
20 replies
MySQL Flask connection stopped working
I'm thinking about migrating the tables because obviously there's some issues with that as well - since they forced some tabular changes as well that make running servers in lower versions connected to 8.4.0 tables
17 replies
MySQL Flask connection stopped working
Naturally I'd love to upgrade my code's security and the provider closing down on an auth method is a pretty big sign to move into the direction they want us to - but it seems my code won't budge.
17 replies