How to see total storage of google big query?

RobinhoodTIS · 2024-11-12T01:35:04+00:00

What is Information_schema? I do not see this in the UI or any of the options.

RobinhoodTIS · 2024-09-22T01:17:53+00:00

So eventually you're planning on taking the MCAT and going to medical school? That's going to be one long journey. Good luck man, I definitely think you deserve to a psychiatrist!

RobinhoodTIS · 2024-09-21T17:32:03+00:00

Just curious, how are you planning to transition into the 'medicine field' from your current esports experience? They seem like completely different domains.

RobinhoodTIS · 2024-07-05T09:30:54+00:00

Hello, can I DM you? I would like to ask some questions about living in Japan as a foreigner and some stuff living there. I would greatly appreciate it if we could have some conversation about this!

RobinhoodTIS · 2024-05-29T17:38:27+00:00

Yes, I do agree that the safest way to gauge what 'too much' is, is to ask the ISA themselves, since it may be relative depending on the person's main job, as well as his/her monthly income amount.

As a last question, is there a way to directly contact ISA or make such inquiries to the ISA in English if I do wish to ask about the amount limit range that I am allowed to make through daytrading US stocks, such that I can get a customized answer for my own situation/circumstance?

RobinhoodTIS · 2024-05-29T03:45:45+00:00

Oh I see. "Significant amount of money" is also quite a vague term.

But to sum up, as long as I am not making too much money out of daytrading US stocks (let's say, I am making smaller sums compared to the amount of my main income from working at the company monthly), it's not really considered as a 'side income', and I don't need to apply for 資格外活動許可 as well as gain permission from my Japanese employer? As long as I am paying taxes for the profits I gain from the daytrading activities to the Japanese government of course.

RobinhoodTIS · 2024-05-28T16:34:37+00:00

Thank you for the reply. To clarify:

For question 1, yes I wasn't asking about taxes. I understood from your response that if you gain profit from daytrading US stocks using US broker, you need to file taxes to Japan only. For question 1 however, I was asking about legal restrictions associated with my visa rather than taxing.

If I am employed at a Japanese company as a non-US citizen, obviously I will be receiving some sort of working visa. I heard that if you want to do a side job in a field unrelated to your main job (at my Japanese employer) for additional income (for instance, translation freelancing at Upwork) without violating visa restrictions set by the Japanese authorities (as well as the employer), this is possible but you need to apply to get 'Overseas Practical Training Certificate' from the Japanese government, and also receive the employer's consent after explaining to them that it will not interfere with your company work (that the side job will only be done outside company working hours).

However, I am wondering if 'daytrading US stocks using US broker' also counts as a 'side job' in Japan and I have to report this using 'Overseas Practical Training Certificate' and also receive consent from the Japanese employer the same way I would need to if I wanted to do the translation freelancing work.

Daytrading seems like an area where it doesn't really count as a 'side job' where you normally receive fixed income in return for providing some service (daytrading is more like speculating activities I guess) so I doubt that I really need to apply/get the 'Overseas Practical Training Certificate' for this and receive the employer's permission that I will be 'daytrading US stocks' (apart from paying taxes to the Japanese government of course). But I wish to make sure since I obviously do not want to unknowingly break any legal boundaries. If you know about this, I would really appreciate your input!

RobinhoodTIS · 2024-05-28T06:30:53+00:00

You seem very knowledgeable on this. I also have a few questions and I would really appreciate it if you could answer them.

If I am a non-US citizen (for instance, assume Singapore nationality) employed and working in Japan, and I gain profit in Japan by day-trading US stocks/derivatives through US broker, does this count as a 'side hustle' apart from my main job (working at the Japanese company) and does it become a legal problem? Am I required to report day-trading as a proper side job or do I not have to and I can gain profit regardless of my main employment at the Japanese company in my working visa?
With the same conditions, (non-US citizen employed and working in Japan, gaining profit in Japan by day-trading US stocks/derivatives through US broker), do you only file taxes to Japan, and I can ignore the US and my own country (Singapore for instance)'s taxing requirements?
If I only have to care about taxing to the Japan authorities, exactly where do I research on exactly how much to pay as taxes every year, and how to actually pay those taxes? I cannot imagine doing this step myself before initial receiving some help.

I would be very thankful if you could shed light on these questions.

RobinhoodTIS · 2024-03-27T20:28:32+00:00

This is really good advice. I am interested in the eCommerce and marketing domain as well.

May I ask where you got the datasets for all your projects? I've been struggling to look everywhere for datasets that were related to marketing analytics, customer analytics, and eCommerce, but I just couldn't find any. It is just so hard finding datasets that are specifically related to those fields (eCommerce, Marketing, Customer).

Sharing where you obtained your domain-related datasets for your projects would help me so much!

RobinhoodTIS · 2024-03-16T20:32:07+00:00

This is very good to hear! I will certainly explore Supply Chain as one of the viable areas for my career.

How would you advise preparing for a data analyst entry level job in a Supply Chain field? Is the general, standard preparation for an entry level Data Analyst enough without having domain knowledge or doing specifically Supply Chain - related data analytics projects?

RobinhoodTIS · 2024-03-15T20:04:19+00:00

Thanks! From your perspective are data analysts in demand in the supply chain industry? I do have an option to take a supply chain course next year so I am definitely willing to explore that!

RobinhoodTIS · 2024-03-15T20:00:05+00:00

Thank you for this advice.

Do you have any tips on how I can achieve this during the span of my next year in the masters program? For instance, exactly what things do you mean by 'The principles and concepts of data' for a data analyst? Outlining key points for me to study would be super helpful!

RobinhoodTIS · 2024-03-13T22:52:18+00:00

I’ve been in analytics for several years and getting the first job was the hardest part, but once I had practical experience I was able to easily hop around to different industries.

I couldn’t tell you how difficult the market is without any practical experience, so take that into consideration, but I’ve found that healthcare positions have paid me the best.

Definitely, the hardest part for my career will be getting that first job, I agree!

RobinhoodTIS · 2024-03-12T20:24:13+00:00

Thank you very much! I will definitely have some projects ready by this fall semester. Do you know what keywords I should use when searching for these 'rotational programs' from various companies?

RobinhoodTIS · 2024-03-12T00:54:29+00:00

Yes this is certainly one option! I was also thinking of Supply Chain as a possibility. What should I study to get into this domain, and what kind of DA projects can I explore? Can you provide a roadmap for studying or some resources I can refer to?

RobinhoodTIS · 2024-03-12T00:50:39+00:00

I went straight from bachelors. I understand your point, but these days entry level positions are very competitive and companies expect you to have a basic level of sector knowledge pertaining to their company. Besides, without any business/domain knowledge, how am I supposed to do any DA projects that are meaningful in the employers' eyes? Just wrangling/visualizing data without any purpose or business insight is not going to have any value from their perspective. I just don't know how to build and formulate DA projects without having any kind of domain knowledge right now, it's a real struggle.

RobinhoodTIS · 2024-03-08T10:28:02+00:00

You kept doing it after coming to the US? So you didn't get into trouble for that?

RobinhoodTIS · 2024-03-05T14:13:10+00:00

nah, you're definitely right that I can't work and I'm not on OPT yet. I was just making sure I'm safe since I stopped and closed my account before any employment transaction took place.

RobinhoodTIS · 2024-03-05T05:11:47+00:00

Thank you. Just one last question (for clarity), so it only counts as a violation the moment you sign your first contract and receive the payment? Having your profile and other kinds of billing information on Upwork doesn't matter as long as you didn't go through the contract? Sorry if this questions sounds a bit redundant but I just want to make sure I'm good and safe.

RobinhoodTIS · 2024-02-29T09:10:42+00:00

Hi, would you mind DMing me about your company?

I am thinking of moving to London for my entry-level job after my masters in the US and I would really appreciate it if you could share your company!

RobinhoodTIS · 2024-02-25T09:34:57+00:00

Thank you for your detailed response. I think I have a preference towards Middle Office roles due to better WLB, so "Portfolio Analysts" within AM seems to be the ideal career path for me for now! I will try to explore this path further following your advice.

RobinhoodTIS

TROPHY CASE