วีดีโอ

How I can get the metadata of yesterdays table

Start with google

Really helpful 🎉

Your speech is very good understandable God bless you...

Hi, you post informative videos. One Que. I have an Excel365 file which has data from the odbc connection, which updates automatically in scheduled intervals, how can I sync that Excel data into Google Sheets with auto updates?

Can you plz make a video on how to sort and filter data in a spreadsheet. Thank you. I like your videos

Well done. This is awesome. Thank you

Great demonstration, thank you!

When I added those IPs in Namecheap A records my website stopped working..

I can't find domain verification in GCP.. What shall I use now?

Right now I am facing a issue while retrieving metadata about (region specific ) data it is showing some error which is saying “ Access Denied: Table famous-design-417916:region-us.INFORMATION_SCHEMATA: User does not have permission to query table famous-design-417916:region-us.INFORMATION_SCHEMATA, or perhaps it does not exist in location US. ”

Firstly I would like to appreciate the way you are teaching , it’s good

Hi, do google charges for load balancer in this case and how much is the charge.

In my experience using the load balancers this way is a very expensive solution. Im paying about 20 eur per month per website. Im looking for an alternative solution that is cheaper

Great Video..! Thanks Ma'am

Can you make word document for this please and share

great one!!!

how did you get that IP i mean from where, i know it need to be external IP but i have tried copy mine external IP and paste inside DNS A and it dosent work..

GREAT VIDEO!!!

How to get user email who access our view under our project id?

Thanks for this direct and simple to follow tutorial. ❤❤❤

Good work

Mam in this query region-us means why u are used this region-us in that query

i am not able to find domain verification from google closud ?

After 2 Year GCP seems little more different , Good to update this with latest GCP UI

How could i connect this to sheets?

Great Video!

This is bad, a much cleaner way to do this is by using CTE recursive.

This is perfect! Thank you for this complete tutorial \o/

how to use it from my local desktop. i can't connect it

Awesome! Congrats for the videos! Keep posting to the BigQuery series please!!! Cheers

Thank you much for the tutorial! Just what I need it. Now, how can you create an new table from the results in a way you can do it scheduled? I believe that would be using STORE PROCEDUREs with this scripting, but I don't know what would be the syntax to store the results into a final TABLE that can be reconstructed every time I run the PROCEDURE. I tried using SCHEDULED QUERIES but the scripting is not allowed there. Any help would be much appreciated.

Excellent video ma'am, really impressed with your teaching style. And a proposal 🤣 If your age is between 24 to 29 and ur unmarried, I am ready to marry you😉

Thansk, can I use this with a CTE?

Awesome 👍🏻👍🏻👍🏻

Excellent and thorough tutorial. Thank you very much!

Would this be a RESPONSIVE Website?

WHAT OTHER WAY NOT USE HTTP(S) Load Balancing? THIS SERVICE COST VERY HIGH, TKS

WHAT OTHER WAY NOT USE HTTP(S) Load Balancing? THIS SERVICE COST VERY HIGH, TKS

You are a life saverrrrr!! Thank you soo much for this!!!

Domain verification is not the same now in GCP console. Could you please share how to verify with the new settings?

I get an error. Invalid format specifier character "R" in FORMAT string. Anyone can help? DECLARE MONTHS STRING; SET MONTHS = ( SELECT CONCAT('("', STRING_AGG(DISTINCT cast(MONTH as string), '", "'), '")'), FROM ( select distinct date_trunc(jakarta_data_date, month) MONTH, from `data-gojek-id-mart.corporate_strategy.detail_booking` a where jakarta_data_date >= date_sub(date_trunc(current_date('Asia/Jakarta'), month), interval 3 month) order by 1 ) ); select MONTHS; EXECUTE IMMEDIATE format(""" SELECT * FROM ( select date_trunc(jakarta_data_date, month) AS MONTH, sa.service_area_name AS CITY, regexp_extract(UPPER(a.service_type_name),'(CAR|RIDE|FOOD)') as service_type_name, count(distinct order_no) AS BOOKING, from `data-gojek-id-mart.corporate_strategy.detail_booking` a left join `data-gojek-id-presentation.location.dim_service_area` sa on a.service_area_id = sa.service_area_id where jakarta_data_date >= date_sub(date_trunc(current_date('Asia/Jakarta'), month), interval 3 month) and (upper(a.service_type_name) like '%RIDE%' OR upper(a.service_type_name) like '%CAR%' OR upper(a.service_type_name) like '%FOOD%') and upper(sa.service_area_name) = 'BANDUNG' group by 1,2,3 ) PIVOT (SUM(BOOKING) FOR MONTH in(%s))""", MONTHS);

Exactly what I was looking for with an easy-to-understand example! Thanks!

Thank you for the wonderful explanation. Is there a similar way by which we can dynamically aggregate string columns in bigquery sql? Usually we would just use Select STRING_AGG(col_1), col_2 From table1 Group BY col_2. What if the number of columns are increasing dynamically?

Thank you!!!! It reallly helps a lot.

This is amazing! Thank you so much!!

very well explained

Great video. Thank you!

Thanks Mam After onetime uploading how to update the index.html page

Thanks, Google's guide was horrible, this is much better.