Google Cloud Arcade Facilitator Program

It's time for Trivia July Week 3, the lab is live and start completing it Asap⏰

[Quick Help] Quick help in solving a Lab Task 3 & Task 5 Lab Name: Offloading Financial Mainframe Data into BigQuery and Elastic Search (Trivia July 2023) Task 3: Create a BigQuery dataset and import data from Cloud Storage Given Command: bq query --use_legacy_sql=false \ "CREATE OR REPLACE VIEW $GOOGLE_CLOUD_PROJECT.mainframe_import.account_transactions AS ( SELECT t.*, a.* EXCEPT (id) FROM $GOOGLE_CLOUD_PROJECT.mainframe_import.accounts AS a, $GOOGLE_CLOUD_PROJECT.mainframe_import.transactions AS t WHERE a.id = t.account_id )" Actual Working Command: bq query --use_legacy_sql=false \ "CREATE OR REPLACE VIEW \$GOOGLE_CLOUD_PROJECT.mainframe_import.account_transactions\ AS ( SELECT t.*, a.* EXCEPT (id) FROM \$GOOGLE_CLOUD_PROJECT.mainframe_import.accounts\ AS a, \$GOOGLE_CLOUD_PROJECT.mainframe_import.transactions\ AS t WHERE a.id = t.account_id )" Task 5: Create a Dataflow job reading from BQ and pushing to Elastic Given Command: # enter these values by hand into the cloud shell (one by one). export CONNECTION_URL=<< your cloud ID from step 1.13 >> export API_KEY=<< your API key from step 1.10 >> # to create and run a dataflow job, # cut and paste the following 7 lines into the cloud shell. gcloud dataflow flex-template run bqtoelastic-date +%s --template-file-gcs-location gs://dataflow-templates-us-central1/latest/flex/BigQuery_to_Elasticsearch --region us-central1 --num-workers 1 --parameters index=transactions,maxNumWorkers=1,query="select * from $GOOGLE_CLOUD_PROJECT.mainframe_import.account_transactions",connectionUrl=$CONNECTION_URL,apiKey=$API_KEY Actual Working Command: # enter these values by hand into the cloud shell (one by one). export CONNECTION_URL=<< your cloud ID from step 1.13 >> export API_KEY=<< your API key from step 1.10 >> # to create and run a dataflow job, # cut and paste the following 7 lines into the cloud shell. gcloud dataflow flex-template run bqtoelastic-date +%s --template-file-gcs-location gs://dataflow-templates-us-central1/latest/flex/BigQuery_to_Elasticsearch --region us-central1 --num-workers 1 --parameters index=transactions,maxNumWorkers=1,query="select * from \$GOOGLE_CLOUD_PROJECT.mainframe_import.account_transactions\",connectionUrl=$CONNECTION_URL,apiKey=$API_KEY Thank you! Happy Learning😁

[Quick Update] Issue with Lab HTTP Google Cloud functions in Go Lab in Level 1 Hi everyone, there is an on going issue in this lab where the progress is not getting as completed. The issue is currently reported and should be soon fixed. We will update you on the same. Thank you!! Happy Learning😁

Do not forget to share your badges and milestone completions on LinkedIn❤️

Hi Everyone! ✨ Let's utilize our free time to complete the remaining Levels & Trivia. ✅️ ⏰ Last 8 Days Left to complete all the Levels & Trivia for the July month. 🦾 We will give you the direct links to Youtube videos for labs which will help you go in the right direction. 🔴 If you haven't started it yet, Do start it as soon as possible & try to complete it before the timeline 🔴 👉🏻 For all updates, join our Announcement channel: https://t.me/arcadewithcloud 👉🏻 For all queries, join the discussion channel: https://t.me/+iOGMxGM8gEg1Yzg9 Happy Learning!!

🦾 Content to Post on LinkedIn with screenshots ✅️ Hello, #Connections!👋🏻 I'm thrilled to share that I've successfully enrolled and completed Level (1/2/Trivia) in the "Google Cloud Arcade Facilitator Program" organized by @Google Cloud and @Qwiklabs.✨ 👉🏻If you haven't joined yet !! - 𝐄𝐧𝐫𝐨𝐥𝐥 𝐍𝐨𝐰 - https://lnkd.in/dt5UuDkp - 𝐑𝐞𝐟𝐞𝐫𝐫𝐚𝐥 𝐂𝐨𝐝𝐞 - AF23-BE5-1AA Thanks to our facilitator/Mentors @Durgacharan Nayak and @Piyush Sharma for mentoring me to get this wonderful opportunity. ✨🙌🏻 Join me in this exciting adventure and level up your cloud expertise with Google Cloud Arcade Facilitator program! 💪🌤️🔝 #googlecloudarcadefacilitatorprogram #googlecloud #arcadeprogram #google #googlecloudplatform #googlecloudskillsboost #opportunity #googlecloudready

Hi everyone,👋 Celebrate! - You have been successfully enrolled & completed Level (1/2/Trivia) in the program🥳 ➡️ Let your friends, peers, professors, and recruiters know about it!✨ 👉🏻Just follow these simple steps: 1. Take a screenshot of your selection email on your phone. 📱 2. Share the screenshot on your social media i.e LinkedIn, Instagram, etc 3. Add the content I am providing below to post it on LinkedIn along with the screenshot. 4. Feel free to change the content but Don't forget to mention/tag us😊, so that we can repost your posts. 🔗 Let your profile catch everyone's attention! Make the efforts worth it! ✅🥳 Happy Learning 😊

Enroll now in the Google Cloud Arcade Facilitator Program https://docs.google.com/forms/d/e/1FAIpQLSd_50_XP6hRmZgIf88wTxgytOm2zkeH9iVPFAOIsAW6ENwMOA/viewform Fill this form Referral Code: AF23-BE5-1AA Announcement channel: https://t.me/arcadewithcloud Discussion group: https://t.me/+iOGMxGM8gEg1Yzg9 Who can join❓ -Students pursuing B.Tech/BCA/BSc etc. -Working professionals -Anyone with a curiosity to learn Cloud Connect with our Facilitators: Durgacharan Nayak - https://www.linkedin.com/in/durgacharan-nayak Piyish Sharma (Tricky Man🤩)- https://www.linkedin.com/in/piyush-sharmaaa See you in the cloud☁️

[Announcement] Start your Arcade journey now ✅️ 🦾 The Participants who have *enrolled themselves for the Arcade but haven't started doing any labs, If he/she won't increase their progress percentage from 0% till 22nd July 2023, will be disqualified from the Arcade Program. 🤝 Check your emails for the same! ➡️ If you haven't started yet, start it ASAP! Join Announcement channel for all updates: https://t.me/arcadewithcloud For doubts and queries, kindly join the discussionc channel: https://t.me/+iOGMxGM8gEg1Yzg9 See you in the ☁️ Durgacharan & The Arcade Facilitator Team

👋 Good Morning, #Tech Enthusiasts! 🦾 Important Note: ⚠️ Only 15 Days Left to complete all the Levels, Trivias for this game of the month. ✅️ If you haven't started it yet, Do start it as soon as possible & complete it Join Announcement channel for all updates: https://t.me/arcadewithcloud For doubts and quesries, kindly join the discussion channel: https://t.me/+iOGMxGM8gEg1Yzg9 See you in the ☁️! Durgacharan and the Arcade Facilitator Team

[Quick Help] Quick help in solving this Lab Lab Name: REDACTING SENSITIVE DATA WITH CLOUD DATA LOSS PREVENTION Lab ID: GSP864 Quest Name: Protect Sensitive Data with Data Loss Prevention Issue: Samples directory does not exist Cause of Issue: nodejs-dlp repo is deprecated on 13th July 2023 Affected Task: Task 1 Solution: Step 1: - In cloud shell, clone the deprecated repository: git clone https://github.com/googleapis/nodejs-dlp - Enter the deprecated repository cd nodejs-dlp - Checkout to commit ce4a029 git checkout ce4a029 - Now the directory should be available, enter it and install node dependencies cd samples && npm i - Continue with Step 3 of Task 1 Thanks, Durgacharan

[Announcement] Redeem your monthly subscription ✅️ Hi everyone!! For those who are facing with the credits issues. Please follow the following steps. 1. Go to the following URL - bit.ly/gcaf2-credits. 2. Log-in and click on "Start Lab". Complete the "A Tour to Qwiklabs & Google Cloud" lab. (Spend atleast 6 minutes & get a score of 100) 3.End the lab and you will be credited with another 1 month pass 4. If you run into quota issues then please reach out to arcade-facilitator@google.com For all updates, join our Announcement channel: https://t.me/arcadewithcloud For doubts and queries, please join the Telegram Discussion: https://t.me/+iOGMxGM8gEg1Yzg9 Please feel free to ask your questions in discussion group for any clarifications. Happy Learning 😊 See you in the ☁️

[Announcement] Issues with subscription and credits ✅️ Hi everyone!! We are receiving many queries related to the credits and the monthly subscriptions. 🦾 You need to wait for 24 hrs for receiving the mail regarding claiming your credits and getting the monthly subscription. 🦾 If you have waited for 24 hrs and still if you are not able to get the credits then please contact to the chat bot which is present in the help tab of each labs. 🦾 You can also write and email to arcade-facilitator@google.com For all updates, join our Announcement channel: https://t.me/arcadewithcloud Still if you have any doubts feel free to put your questions in the discussion group: https://t.me/+iOGMxGM8gEg1Yzg9 Happy learning!! See you all in cloud☁️ Durgacharan & the Arcade Facilitator Team

Just a quick reminder!! Do not forget to miss out the Trivia Quest for July month Quest link: https://www.cloudskillsboost.google/quests/329?utm_source=gcaf-site&utm_medium=website&utm_campaign=gcaf23 Skill bagde link: https://www.cloudskillsboost.google/quests/118?utm_source=gcaf-site&utm_medium=website&utm_campaign=gcaf23 Join our Announcement channel: https://t.me/arcadewithcloud See you in the ☁️ Durgacharan & the Arcade Facilitator Team

[Announcement]Deadline for the program extended to 28th July✅ Hii everyone! We came bearing some good news here. 🙂 We have decided to keep the enrolment form open until 28th July 2023 11:59 PM IST and have added more seats to the program so that more users can join the program. 🎊 So use this extra time to enroll more of your friends. [VERY IMPORTANT] Note: While, we have kept the enrolment date open till 28th July, that means users who enrol near the end of the enrolment period, will have less time to complete the July Games and Trivia. And if they are not able to complete those by July end, then they will NOT be able to achieve their 3rd and 4th Milestone. 🚫 Hence we request the users to complete their Games and Trivia first before the month ends so that they do not miss out on it. ✔️ As always, feel free to reach out if you have more questions and all the best. 🙂 Join Announcement channel for more updates: https://t.me/arcadewithcloud See you in the cloud☁️, Durgacharan & the Arcade Facilitator Team

[Announcement] Points collection and Prizes redemption Hi everyone! We know that a lot of you have been having questions about the points and swags/prizes. ✔️ The entire program completion will give you multiple points as per your games completions. 😍 Bonus Point: Earn more points in order to get more prizes🤩 Check details here: https://bit.ly/gcaf-points-system Join Announcement channel for more updates: https://t.me/arcadewithcloud See you in the cloud☁️ Durgacharan & The Arcade Facilitator Team