1. Go to Google Cloud Console

πŸ‘‰Β console.cloud.google.com

Make sure you're logged into your Google account.

image.png

2. Create a new dataset

Navigate to BigQuery β†’ your project β†’ Create Dataset.

image.png

image.png

3. Create tables users and logins

Upload the provided CSV files to your dataset. Use the option: Create Table β†’ Upload β†’ CSV

Data: https://drive.google.com/drive/folders/1ATPhtzZ_2PiAFua1-qu3llyqKUsTG4qq

image.png

image.png

4. You’re ready!

Now you can start writing your first SQL queries πŸš€

image.png