Zero ETL Data Federation from BigQuery to AlloyDB Code Vipassana S 15 Complete Guide #codevipassana

Added: 2026-05-30

[00:00:00]So all the guys, welcome back to the channel. In this video, we'll cover another code lab for the Google Cloud season 15. What is it? Let's cover it in detail complete step-by-step from start till submission.

[00:00:10]And if you don't know about this opportunity, you can just check the playlist link in the description, or you can navigate to the playlist directly.

[00:00:16]From there, I've covered the code lab one and about the event, too. You can see over here.

[00:00:20]Now, the most important thing is that how to set up. First of all, you have to come to number two.

[00:00:25]Open the console.

[00:00:26]If you're doing it for the first time, you have to create a project ID. Well, that I just click on new project. List a project name over here. Select the trial billing account. If you're not seeing the trial billing account, you need to activate the trial. Means you have to just activate using your own details.

[00:00:41]I've to do it. I've shared a video how to claim the trial credits. You can watch that video and complete the challenge without any issue.

[00:00:48]Now, once you have created the project ID, you have to just move to the next step. Okay. If you're facing any billing related issue, just come to the billing section.

[00:00:58]Go to manage billing account.

[00:01:02]Go to your projects.

[00:01:05]And from here, you can just click on these three dots and change the billing account accordingly if you're facing issue, okay? And set it.

[00:01:12]Now, let's come directly to the main task of this particular code lab.

[00:01:17]So, first of all, you have to just go to the number four, okay?

[00:01:21]From here, you have to copy this link.

[00:01:23]And just open it on a new tab.

[00:01:26]Now, from here, just come to number four.

[00:01:29]Click on this one click.

[00:01:32]It will simply activate, and here we'll be deploying the load DB cluster.

[00:01:39]So, you can see it is starting.

[00:01:43]Now, from here, just come back again.

[00:01:47]Here it is. Just run this SSH command.

[00:01:53]Paste it like this.

[00:01:55]And hit enter.

[00:01:59]Paste, hit enter.

[00:02:03]Now wait for a few seconds.

[00:02:07]Click on this particular link.

[00:02:14]Now here it's asking for the project ID and billing details.

[00:02:18]Let's come directly over here.

[00:02:20]You can just click on a lot of setup.

[00:02:23]Now here enter the project ID. I'll find it.

[00:02:26]Just click on the home section. You can see project ID is there. You can copy it. Or if you're having multiple project ID, from here you can just copy the ID.

[00:02:35]So let's copy it.

[00:02:37]Paste it.

[00:02:39]Let the region be same. Now for database password you can type anything.

[00:02:46]Okay.

[00:02:47]Or I think there is a password option also.

[00:02:53]Okay, they have not given. So whatever password you are entering, make sure you remember it because it will be better.

[00:03:01]And just click on start deployment.

[00:03:04]Now this will take around Okay, so it's showing GCloud session is not active.

[00:03:12]So we need to perform this particular thing. Just copy this command.

[00:03:20]Open a new tab.

[00:03:25]Set the project first of all.

[00:03:31]Just paste this command. GCloud space auth space login.

[00:03:35]Type Y hit enter.

[00:03:37]Copy this link.

[00:03:40]Select your student ID.

[00:03:43]Sorry.

[00:03:44]Continue.

[00:03:46]Allow.

[00:03:49]Copy it from here.

[00:03:52]And just paste it. Hit enter.

[00:03:55]Now, what we have to do? We have to come back again and retry.

[00:04:06]Okay, so let's redo this particular step.

[00:04:13]Copy it.

[00:04:14]Directly copy this repository command.

[00:04:20]Paste it. Hit enter.

[00:04:38]Now, this is done. Okay.

[00:04:41]Come again.

[00:04:44]Here it was. Just run this SSH command.

[00:04:49]Paste it over here. Hit enter.

[00:04:56]Okay, so it's already running. First of all, we need to close it. Control C.

[00:05:02]Come over here.

[00:05:04]Paste it. Hit enter.

[00:05:14]Now again, copy the project ID.

[00:05:25]Enter the password.

[00:05:32]You can see now it is starting the work.

[00:05:37]Now here you can see we are getting the resource error.

[00:05:41]So, first of all, let's see whether the cluster is created or not.

[00:05:50]>> Just type AlloyDB.

[00:06:03]Cluster is created.

[00:06:09]If you just open the AlloyDB Studio, you don't have access because instance is not ready.

[00:06:18]Okay.

[00:06:19]So, what you need to do, come back again, change the region, and retry it if you're getting the resource error.

[00:06:33]So, finally it is done. Now, let's come directly to the AlloyDB section. You can see it is created.

[00:06:41]So, just open it.

[00:06:48]So, from here, click on this AlloyDB Studio.

[00:07:04]Select the database, user, enter the password which you used to create the cluster, okay?

[00:07:13]And authenticate yourself.

[00:07:16]Now, once you have done it, you can see here we have BigQuery table. So, click on it, connect to BigQuery table.

[00:07:25]Select the data set.

[00:07:28]Multiple tables are there. Let me just check which table we have to add.

[00:07:34]Just select the allergen.

[00:07:47]>> So, let's do one thing. First of all, open untitled query.

[00:07:51]Come back again.

[00:07:53]From number six, copy the first query.

[00:08:00]Paste it.

[00:08:01]Run over here.

[00:08:04]We are getting this type of error.

[00:08:11]Click on fix.

[00:08:16]Now, from here, just click on accept and run.

[00:08:20]It is done.

[00:08:22]Now, click on connect.

[00:08:24]From here, just select a data set.

[00:08:28]Select a table.

[00:08:31]And now, enter any of the destination.

[00:08:37]And click on connect.

[00:08:54]Okay, I got it what we have to do. Just come directly.

[00:08:58]I am I am admin. Open it.

[00:09:03]So, from here, just click on this pencil icon.

[00:09:09]Add a big query.

[00:09:14]Data viewer.

[00:09:18]Already is there. Okay.

[00:09:21]Data viewer and user.

[00:09:49]>> Save it.

[00:09:51]Come back again.

[00:09:54]The Cloud Shell page.

[00:09:57]Open a new tab.

[00:10:02]And here we have to run this command.

[00:10:05]So, for the cluster name, we have to just copy this cluster.

[00:10:14]Okay, so instance name we have to copy.

[00:10:26]Region.

[00:10:40]Cluster name.

[00:10:48]Copy entire command.

[00:10:54]Sorry, copy entire comment. Sorry, command.

[00:10:58]Paste over here. Hit enter.

[00:11:02]Okay, so it's asking to authenticate.

[00:11:06]Let's come over here.

[00:11:09]Press Ctrl C.

[00:11:12]Run it directly.

[00:11:14]It is enabled. Okay.

[00:11:17]Now, come back.

[00:11:21]And let's try to connect it.

[00:11:36]>> Okay, so let's see. Then stands first of all.

[00:12:05]It's updating. We have to wait for the update to propagate.

[00:12:18]Let's try to authenticate again.

[00:12:38]Connected.

[00:12:50]It's still taking a lot of time.

[00:12:52]So, it took around 30 minutes for the status to get updated. You can see the flags is also added and it's on.

[00:12:59]Now, from here we have to go to the Loyalty B Studio.

[00:13:04]Select the database, user, and authenticate.

[00:13:12]Now, in the description box of this video, I've shared one GitHub repository. From there, you'll find the command. So, which one we have to run?

[00:13:20]From here, just copy like this.

[00:13:25]Okay.

[00:13:31]Up to here.

[00:13:34]Paste it.

[00:13:36]Run it like this.

[00:13:38]This is executed.

[00:13:40]Now come over here. From here you can see seven number.

[00:13:44]Just copy this query.

[00:13:47]And simply paste it like this and run it.

[00:13:54]Now here you can see output is generated. It is same from the first code lab.

[00:13:59]Now from here first of all you have to sign in to the result validator. I'll share the link in the description.

[00:14:06]Now once you have signed in, you have to just upload it.

[00:14:10]Select the event. Select the session.

[00:14:14]Here you have to just update it, okay.

[00:14:17]So from here what you need to do, you can see multiple options are there.

[00:14:21]From Alloy DB Studio you have to navigate to the overview page, okay.

[00:14:27]Now you have to take the screenshot of this particular page only.

[00:14:33]So just take it.

[00:14:44]And simply upload over here.

[00:14:58]So here you can see it is successfully approved. That means we have successfully completed this particular challenge, okay.

[00:15:06]Now for the remaining solution you can see first one is done. Second one is also done. More three are remaining. If you just come and check.

[00:15:15]Let me just show you.

[00:15:17]You bear it was.

[00:15:22]Here it is, okay.

[00:15:24]The second done, only three are remaining which will be also live very soon. So, stay tuned till then. Thank you. Goodbye and have a great day ahead.