ChaoticKitten
ChaoticKitten
RRailway
Created by ChaoticKitten on 5/15/2024 in #✋|help
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
RRailway
Created by ChaoticKitten on 7/1/2024 in #✋|help
Build issues
Keeping this open in case the team wants to investigate the hiccup
14 replies
RRailway
Created by ChaoticKitten on 7/1/2024 in #✋|help
Build issues
And it seems it got removed in the end
14 replies
RRailway
Created by ChaoticKitten on 7/1/2024 in #✋|help
Build issues
It also seems like removing the 10 mins building image is not doing anything. Hopefully not incurring any costs.
14 replies
RRailway
Created by ChaoticKitten on 7/1/2024 in #✋|help
Build issues
The build time went off the rails for a project this small
14 replies
RRailway
Created by ChaoticKitten on 7/1/2024 in #✋|help
Build issues
all i did was add jwt to requirements and minimal code modifications
14 replies
RRailway
Created by ChaoticKitten on 7/1/2024 in #✋|help
Build issues
Image stuck in initializing
14 replies
RRailway
Created by ChaoticKitten on 7/1/2024 in #✋|help
Build issues
f3f3aa54-1f32-4a2a-9e9a-61d26191712d
14 replies
RRailway
Created by ChaoticKitten on 6/9/2024 in #✋|help
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
RRailway
Created by ChaoticKitten on 6/9/2024 in #✋|help
MySQL Flask connection stopped working
The redeploy was meant to rebuild the image with a more recent version of mysql and nothing else. The deployments are as basic as they come with no modifications on my end.
17 replies
RRailway
Created by ChaoticKitten on 6/9/2024 in #✋|help
MySQL Flask connection stopped working
Well before the redeploy roughly 5 months, but the most recent redeploy that screwed things up was 6 days ago
17 replies
RRailway
Created by ChaoticKitten on 6/9/2024 in #✋|help
MySQL Flask connection stopped working
There was no other flag previously, yes
17 replies
RRailway
Created by ChaoticKitten on 6/9/2024 in #✋|help
MySQL Flask connection stopped working
No description
17 replies
RRailway
Created by ChaoticKitten on 6/9/2024 in #✋|help
MySQL Flask connection stopped working
No description
17 replies
RRailway
Created by ChaoticKitten on 6/9/2024 in #✋|help
MySQL Flask connection stopped working
Attempted but doesn't seem to have an effect
17 replies
RRailway
Created by ChaoticKitten on 6/9/2024 in #✋|help
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
RRailway
Created by ChaoticKitten on 6/9/2024 in #✋|help
MySQL Flask connection stopped working
f3f3aa54-1f32-4a2a-9e9a-61d26191712d
17 replies
RRailway
Created by ChaoticKitten on 5/15/2024 in #✋|help
PowerBI/PowerQuery can't connect to Postgres database due to ssl validation error
Seems like power bi really doesn't like ssl :-? I'll try to dig something up just so there's some documentation around
20 replies
RRailway
Created by ChaoticKitten on 5/15/2024 in #✋|help
PowerBI/PowerQuery can't connect to Postgres database due to ssl validation error
Note for support person: My availability will be probably a bit limited in the next 18 hours, but I will do my best to answer texts
20 replies
RRailway
Created by ChaoticKitten on 5/15/2024 in #✋|help
PowerBI/PowerQuery can't connect to Postgres database due to ssl validation error
Previously a MySQL connection worked, about an year ago
20 replies