I'd say far better explanation than any other GBQ tutorial, really nice sir, is it possible to make the same concept using IaaS like terraform in gcp , please 🙏
Hi, you always post very very 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?
hello, I have a question. Do one need to learn Big Data as pre requisite to learn GCP Data Enginner services, like BigQuery, BigTable etc. ? Plz suggest.. TY.
You need to have a date field in your table if you simply want last one month data you can have a created_date column to be added for each record moreever you can partition your table month wise for cheaper reads.
Its a good question but unfortunately i havent worked on Snowflake but I am planning to explore it in my own capacity and will share my novice learnings and comparison with Big Query
Hi Brother, In the google cloud platform cloud shell editor, I was written one code, but I was facing a Chrome driver issue. I was written python code in my local IDE(visual studio code ) code is working and the file I was pushing into the google cloud bucket. the same script I was running into google could shell editor, asking for chrome driver executable, needs to be a path like that error I was facing. Did you know how to overcome this error ? please tell me if you have any solution.
@@ITkFunde i request you to please create more videos regarding data engineering perspective on GCP as well. also do include dataproc,dataflow, partition, bucketing etc, please
This query will give the same result : SELECT tagst, count(*) as tag_count FROM `bigquery-public-data.stackoverflow.posts_questions`, UNNEST(split(tags,"|")) as tagst WHERE EXTRACT(YEAR FROM creation_date) >= 2008 GROUP BY tagst ORDER BY tag_count desc LIMIT 10
Man!! Great video!!
Amazing session .. thank you very much.
Sir ppl still don't know much about cloud once tis subject gets into the curriculum ur going to be top on youtube channel for gcp
Thanks Arshiya hope it helps every one
You were Excellent, thank you.
Very good video! Thanks a lot!
Very neatly explained the BigQuery concept along with a good demo. Thank you, its very helpful.
Precisely explained for a layman
Thanks Deepak
I learnt a ton from this thank you!
thanks for teaching in a simple way! amazing !!
this is very helpful lab session on GBQ.
Thanks Yagnik
Great job
good one
I'd say far better explanation than any other GBQ tutorial, really nice sir, is it possible to make the same concept using IaaS like terraform in gcp , please 🙏
Hi Rawin thanks its a good idea I will pit it in my list
@@ITkFunde sir I have 2 database and want to compare 2 table and find unmatched records. Can you please reply how to do it.
Your tutorials and explanations are clear to understand and concise, make more on ML pipelines in GCP
very nice explanation
Thanks Rajiv
Sampson was the strongest man on Earth. Hercules is a myth. Thx.
Thanks , this was helpful.
Excellent video, thank you!
Hi, you always post very very 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?
hello, I have a question. Do one need to learn Big Data as pre requisite to learn GCP Data Enginner services, like BigQuery, BigTable etc. ? Plz suggest.. TY.
Excellent
Sir, Is the query similar to what we mysql query becoz here we also use sql but unnest function is not there?
Nice video . Please post more videos on GCP.
Awesome
Thanks Shahnawaz ☺️
Big query saves data date wise how can i retrieve one month data in big query, will i have to join all tables first
You need to have a date field in your table if you simply want last one month data you can have a created_date column to be added for each record moreever you can partition your table month wise for cheaper reads.
Nice
Sir thanks for this video. Which one is better Snowflake or Big query please explain
Its a good question but unfortunately i havent worked on Snowflake but I am planning to explore it in my own capacity and will share my novice learnings and comparison with Big Query
No further videos uploaded on gcp?
Sorry mate due to multiple request I am currently making vidoe series on networking but would soon switch to GCP. Thanks for your feedback 🙏
Hello ,
Is there any full tutorial on Google BigQuery ?
If any can you please provide here the link.
It would be very helpful to learn Google BQ.
Good..Can you give LIVE demo session...?..Reply..
Are you continuing this series? Only 9 vdo I can see. Outstanding vdo by the way Sir.
Really helpful video.Can you please suggest a good comprehensive course on BigQuery ?
Coursera offers some comprehensive courses and also affliated with Google
Hi Brother, In the google cloud platform cloud shell editor, I was written one code, but I was facing a Chrome driver issue. I was written python code in my local IDE(visual studio code ) code is working and the file I was pushing into the google cloud bucket. the same script I was running into google could shell editor, asking for chrome driver executable, needs to be a path like that error I was facing. Did you know how to overcome this error ? please tell me if you have any solution.
can you send me the eact error with error code ?
@@ITkFunde yes..i will send you
@@ITkFunde How can i send that image Bro?
send on anshultiwari353@gmail.com
@@ITkFunde please check sir..I was sended issue in your email
Please create full course if possible, waiting from bottom of my hart .... :-)
Thanks
How to train Recommandation Model from google analytics event.
Do you have more tutorials on big query :)
I would like to learn bigquery. Will you please teach me. I need to learn this immediately.
At 1.58 .. I think its atlas not hercules.
Really helpful.❤️❤️..sir could please create some more video for data migration...like kafka server payload to cloud bucket...demo
Thanks Moushmi sure thanks for your support I have plans to do a data series in future
@@ITkFunde i request you to please create more videos regarding data engineering perspective on GCP as well. also do include dataproc,dataflow, partition, bucketing etc, please
How can I download this
Sir How To Connect Mircosoft SQL Server Database / Table into Google Sheet through BigQuery?
please sir upload more videos on gcp..
Any contact for online class?
Hello sir do you know how to reach sub collections in firestore to bigquery
Vedio content is not clear. Subject and explaination is good but presentation is not visible
Dear sir ,
If give me 17 chapter gcp certificate
From you. After complete classes.
Kaladhar muakonda
text
Poor explanation as some where you write whole query and didn’t explain and skip that part.
This query will give the same result :
SELECT tagst,
count(*) as tag_count
FROM `bigquery-public-data.stackoverflow.posts_questions`, UNNEST(split(tags,"|")) as tagst
WHERE EXTRACT(YEAR FROM creation_date) >= 2008
GROUP BY tagst
ORDER BY tag_count desc
LIMIT 10
Thanks for the detailed explanation!