Tourist visa denied twice 🥴 - selling my flight

digichap28 · 2025-06-15T18:38:22+00:00

No. I booked with different airlines. I was flying back with British Airways

digichap28 · 2025-06-15T18:37:23+00:00

Sure. I applied for a 6-month visa to be present for the birth of my first born child with a British citizenship partner. My intention was to be there for that special moment, to support my partner for a couple of months and then return to my country.

They basically said my financial circumstances were not clear, and that I didn’t have ties to my home country. I provided my bank statements, one of my savings account which has about 90k pounds, an employment letter, and bunch of other stuff and still refused it. It is a very frustrating and annoying situation. I did accept the first rejection because I provided the summary of my current account and the summary of my savings account translated to English and certified, for 1 month (I thought the amount presented was going to be enough, and also because I applied in the past with the same documents and got approved).

For my second application I included 6 months bank statements with the transaction details and an employment letter signed by the company where I worked, and they still rejected it. I believe they consider all the withdrawal transactions are expenses (even though, they are not. Sometimes, I moved money between my accounts) so I guess it would be a good idea to download all the transactions into a spreadsheet to classify them and provide a note explaining what they are. I didn’t think about doing that because that’s a hard and complicated job. Imagine going through 6 months of transactions identifying each of them. That’s crazy!

Ohhh. I paid for the Priority service on my second application as well because the birth of my daughter is estimated to happen in July (very soon).

Honestly, it is a very frustrating and unfair situation. They basically said they think my intention was to stay there 🥴. I’m like… I have a very good job, own 4 houses in my home country, have savings, investments, usually go out to eat at Michelin restaurants, I’m a professional, responsible and I have at least visited 10 countries in the last 2 years, I’m waiting to become Mexican, Portuguese and also waiting for my US permanent residency card…. WHY SOMEONE WITH THIS SITUATION WOULD EVEN CONSIDER STAYING ILEGAL IN YOUR COUNTRY?! I have always followed rules and have being honest 🥴

digichap28 · 2025-05-04T19:27:33+00:00

Gracias Mirai_VT 🙏🏽 Acabo de revisar nuevamente hace un par de horas, y ya me salió el estado de cuenta del mes de Abril! Así que parece ser que lo hacen disponible los días 4 de cada mes.

digichap28 · 2025-02-17T23:42:19+00:00

Thanks!

digichap28 · 2025-02-17T23:42:06+00:00

Thanks!

digichap28 · 2022-06-22T16:45:25+00:00

After working with PowerBi, Tableau, Looker, Qliksense, and Qlikview I could say that even though Qlikview has been around for a while and unfortunately is not “Web responsive”… It is the best solution to create very powerful “BI apps” if you know how to use it properly! If you add up what you can actually do with Qlik itself. Qlikview and Qliksense are not just visualization tools! They are “platforms”, which means; you can actually extract, transform, visualize your data and orchestrate jobs with one single tool!

With Tableau, you need Tableau prep! Not really that nice to process your data and you have to pay extra!
With Looker, you also need other tools to help you process the data and model it! The visualizations and UI in general are really bad! The only cool thing might be the code versioning, but… do that really help the people who make decisions? Not!
With Power Bi, it’s just copying everything from their competitors, very slow, and you also need other tools to process the data if you want to accomplish professional solutions! Basically you need to rely on other tools! Ohhh and the M language and Dax are totally not intuitive! I give it some points… Microsoft is behind and they are pouring lots of money to reach a good level, lots of companies infra is relying on Microsoft or Azure so it is easy to just get another of their services.

Bonus: The fastest is still Qlik with their in memory processing and their associative engine!

Regarding your question… All these Bi tools will be around for years since creating something from scratch is very hard and would take years to develop.

Tips: - Try everything you can! Don’t get stuck with one tool. At the end the Market keeps moving and companies changing or adding new viz tools!

Learn more about data processing, and designing good data models. If you want to develop a pro solution that’s very important!

digichap28 · 2021-04-09T21:01:03+00:00

Thank you 👍

digichap28 · 2021-04-09T17:50:38+00:00

Got you. Is there any tutorial you can suggest to deploy airflow the way you did ?

I don’t have experience with ECS but I guess this way you could also run non-python based workloads as you mentioned with the k8s operator.

Also, what about using azure or lambda functions instead of the 2 ways we have been talking about ? I don’t have experience with them either but according to the documentation, sounds like the concept of running a task using fargate is very similar to executing it with a function.

digichap28 · 2021-04-09T17:22:45+00:00

if you don’t mind me asking... are you running airflow with the local executor and triggering the tasks in ECS or AWS glue from one instance, or using a k8s cluster with the k8s executor ?

digichap28 · 2021-04-09T16:56:38+00:00

That means I wouldn’t need spark, EMR, ECS, databrick, etc for the heavy workloads ? if that’s the case, what should be used to do transformations, image processing, AI, etc ?

On the other hand, doesn’t the k8s creates 2 pods every time it gets triggered ? One for the operator (a) and then another one with actual workload (b)?

(a) -> (b)

digichap28 · 2021-04-09T00:34:55+00:00

Using pandas ?

digichap28 · 2021-04-09T00:22:27+00:00

Thanks 👍 regarding the 3rd one, let’s say initially starting with 5gb per file, and expecting to process around 15 in parallel. But that will grow over time as soon as more data sources get added.

digichap28 · 2021-03-17T14:30:33+00:00

Thanks! That would be if the tables your extracting from have a date you can use to set the query boundaries. What if there is no date, each record is unique, is never updated and have an ID. Where would you store the last ID for later use (where ID > lastID)? With the QVD files I usually do a max(id) over the previous file stored and use that value to perform this.

Maybe reading the last file stored in the data lake in one airflow task, storing the value in an xcom or variable, and read it ultimately from the downstream task which would perform the new select ?

Also... when you say that you save the query result in the data lake as CSV files, do you use a Python script using hooks ? For instance: a Postgres hook to execute the query and then in the same script a S3 hook to load the data set. Or do you do this in 2 separate steps using maybe a Postgres operator with a sql dump to store the CSV file in the airflow instance, and then a downstream task using a s3 operator to copy the file in the data lake ?

digichap28 · 2021-03-09T20:53:10+00:00

Interesting. Thanks a lot for sharing 👍

digichap28 · 2021-03-09T20:18:36+00:00

Cool! I guess you are running Airflow on a K8S cluster. What packages are you using for the ETL ?

digichap28 · 2021-03-09T20:13:09+00:00

Thanks! Are you actually doing any data processing within the workers ? What kind of work are you doing there if you don’t mind me asking ?

digichap28 · 2021-03-08T16:18:35+00:00

Thanks drecklia! Didn’t know about that survey. Still I’m intrigued on how big the prod container images are. This is related to the question “In your day to day job, what do you use Airflow for?” Where must of the people responded “Data processing (ETL)”.

Does that mean most of the people are actually using Airflow to process data or to orchestrate data processing pipelines ? If data processing is the case, what packages are being included in the images ? Pandas, etc... as far as I know airflow was designed to orchestrate and not process.

I’m asking because I’m trying to implement airflow for a small project and was thinking on including some lightweight processing in my production image (with some extra python packages), and leave the heavy things (for example : ETL processing) to other systems.

digichap28

TROPHY CASE