SQL For AWS Athena [FULL COURSE IN 40mins]

  Рет қаралды 19,704

Johnny Chivers

Johnny Chivers

Күн бұрын

Пікірлер: 30
@ws3457
@ws3457 2 жыл бұрын
Your channel is where I go for all things AWS. Thank you for doing this for us!
@JohnnyChivers
@JohnnyChivers 2 жыл бұрын
Thanks for watching buddy!
@santoshwaghmare4081
@santoshwaghmare4081 2 ай бұрын
Hats off to you Johnny! Such a well explained video. Explanation was on point. Your videos are great help for beginners like me. Thank U. New subscriber!!
@ytbart9157
@ytbart9157 2 жыл бұрын
Best channel ever, thank you so much 🤩🤩. From Paris ☺️
@JohnnyChivers
@JohnnyChivers 2 жыл бұрын
Thanks for watching buddy!
@marcosoliveira8731
@marcosoliveira8731 Ай бұрын
Love the explanations and the examples. +1
@mohammedimranmoiz9503
@mohammedimranmoiz9503 2 жыл бұрын
bro u help me alot with AWS u r 🥳
@JohnnyChivers
@JohnnyChivers 2 жыл бұрын
Thanks for watching!
@samvarghese8288
@samvarghese8288 Жыл бұрын
Clear and detailed , Thank you !
@Stonk5331
@Stonk5331 2 жыл бұрын
Great tutorial John, thank you for your effort! Gonna start working on my work project with AWS Spark and Athena from next week on. Can you suggest any tutorials or documentation for intermediate AWS sql?
@vivekpuurkayastha1580
@vivekpuurkayastha1580 2 жыл бұрын
1) Are we allowed to use managed table, which should be preferred Managed or external? Also, in case of Managed table on deletion of the table will Athena be allowed to delete the data from the S3 location which was loaded by another service ? 2) what is the relation between Athena, Hive and Presto?
@JohnnyChivers
@JohnnyChivers 2 жыл бұрын
Hi Vivek, 1) yes you can use governed tables with Athena. I don’t think it will delete the data if you drop the table as that would go against the general principles of working in these types of environments, but it should be double checked. 2) The high level answer is that Athena uses the presto engine to execute queries. And presto is a big data query engine. Hive is another type of big data query engine. However, the Hive meta store is a slightly different thing - and is a place where meta data such as table definitions are stored (I.e. the glue data catalog).
@waseemshaikh6863
@waseemshaikh6863 Жыл бұрын
Hi Johnny, great content. I wish you a lot of success. Can you please make a video on Redshift SQL as well.
@dimitrigbo823
@dimitrigbo823 11 ай бұрын
Love you mate!!!
@chandrakanthsadu4072
@chandrakanthsadu4072 Жыл бұрын
How to use listagg in Aws athena ? For example the following code in SQL LISTAGG(column1,’,’)with in group(order by column1) over (partition by column2,column3) ? Can you please help me
@professional6635
@professional6635 2 жыл бұрын
Can we restrict specific commands in Athena for users. I mean commands like INSERT, DROP TABLE or DROP DATABASE are not allowed to be accessed by everyone. Do we have this command level security in Athena ?
@hasanmougharbel8030
@hasanmougharbel8030 2 жыл бұрын
Hey there, glad to meet again. I learned about timestamp as a date data type. My question is, if i where to record timestamps of every record entered into the database. Would the sql server generate two identical timestamps given the records where run simultaneously..is that case a hypothetical one or would it happen? Thanks for taking care of this.
@dndhndn
@dndhndn 2 жыл бұрын
1) is creating data catalog (database and tables) essential for Athena & S3 interaction? 2) does creating data catalog in glue has pricing?
@jacoedp
@jacoedp 2 жыл бұрын
Hi Johnny, we love your video's, big thanks from South Africa! Quick question, we are currently landing all our data in S3 then crawling it to create or add to tales in our catalog. But your video got me wondering: Would it be easier to just write SQL queries in Athena to do this instead of crawlers? Because we find crawlers a bit of a "black box" (and does not work correctly all the time), Doing this in SQL seems like a much cleaner solution. Whats your thoughts on this ? Much appreciated . Jaco
@JohnnyChivers
@JohnnyChivers 2 жыл бұрын
Hi Jaco, yes I’ve managed table creation before using SQL statements via Athena to move away from crawlers. The only draw back is that if you add a column at a later date you either need to drop ecreate the table (and re add partitions if you are using them)…. Or write an alter table statement but to recreate the table from scratch you then need to multiple scripts. I’ve also used cloud formation to create tables as well.
@JohnnyChivers
@JohnnyChivers 2 жыл бұрын
Hi Jaco, yes I’ve managed table creation before using SQL statements via Athena to move away from crawlers. The only draw back is that if you add a column at a later date you either need to drop ecreate the table (and re add partitions if you are using them)…. Or write an alter table statement but to recreate the table from scratch you then need to multiple scripts. I’ve also used cloud formation to create tables as well.
@romioselvan-lu9mo
@romioselvan-lu9mo Жыл бұрын
I need a query in athena that i have 100 no of columns in my table. In that table i need to pic 99 columns except 1 column. Is there any possible to get data without mention 99 columns name in the query..?
@gajalakshmibabu8584
@gajalakshmibabu8584 Жыл бұрын
Have you got ans?
@JavierHernandez-xo5nb
@JavierHernandez-xo5nb Жыл бұрын
Exelente..... Para cuando los de EC2?
@davidsternberg7359
@davidsternberg7359 2 жыл бұрын
Your GitHub create table for Customers has a typo for firstname attribute. It says fistname. Other than that flawless execution of queries.
@helovesdata8483
@helovesdata8483 2 жыл бұрын
can you do a Case when?
@mohak9102
@mohak9102 2 жыл бұрын
Hey 1 quick question, is there a way to use kms managed encrypted data in athena?
@JohnnyChivers
@JohnnyChivers 2 жыл бұрын
Yes it supports both s3 and client side encryption through KMS.
@vanipriyanka7313
@vanipriyanka7313 2 жыл бұрын
what is the point in making tNice tutorialngs on the channel rack when you have a soft roll?
Apache Iceberg on AWS with S3 and Athena [FULL COURSE IN 30MIN]
28:04
Johnny Chivers
Рет қаралды 25 М.
AWS Glue Tutorial for Beginners [NEW 2024 - FULL COURSE]
53:03
Johnny Chivers
Рет қаралды 6 М.
Support each other🤝
00:31
ISSEI / いっせい
Рет қаралды 69 МЛН
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 28 МЛН
人是不能做到吗?#火影忍者 #家人  #佐助
00:20
火影忍者一家
Рет қаралды 12 МЛН
UFC 310 : Рахмонов VS Мачадо Гэрри
05:00
Setanta Sports UFC
Рет қаралды 1,2 МЛН
PySpark For AWS Glue Tutorial [FULL COURSE in 100min]
1:36:49
Johnny Chivers
Рет қаралды 91 М.
How to Query Your DynamoDB Table with SQL using Athena
26:13
Be A Better Dev
Рет қаралды 16 М.
AWS EMR Tutorial [FULL COURSE in 60mins]
1:01:06
Johnny Chivers
Рет қаралды 66 М.
AWS Glue Tutorial for Beginners [FULL COURSE in 45 mins]
41:30
Johnny Chivers
Рет қаралды 280 М.
AWS Glue Studio - Lets Get Hands On!
32:53
Johnny Chivers
Рет қаралды 17 М.
Deep Dive Into AWS Lake Formation - Level 300 (United States)
28:27
Support each other🤝
00:31
ISSEI / いっせい
Рет қаралды 69 МЛН