How to get classes ?

Can we execute the complex CTE queries in polars. I'm unable to do so, if possible could you provide any example of complex query. for eg: query = """WITH sales_2017 AS ( SELECT SUM(TotalNetAmount) as TotalSales_2017 FROM salesorder WHERE EXTRACT(year FROM CAST(OrderDate AS TIMESTAMP)) = 2017 AND EXTRACT(month FROM CAST(OrderDate AS TIMESTAMP)) BETWEEN 1 AND 3 ), sales_2016 AS ( SELECT SUM(TotalNetAmount) as TotalSales_2016 FROM salesorder WHERE EXTRACT(year FROM CAST(OrderDate AS TIMESTAMP)) = 2016 AND EXTRACT(month FROM CAST(OrderDate AS TIMESTAMP)) BETWEEN 1 AND 3 ) SELECT TotalSales_2017, TotalSales_2016 FROM sales_2017 , sales_2016""" getting error : ColumnNotFoundError: TotalSales_2016

Nice explanation bro

very slow and session is sleepy

Music is very annoying .. Looks like its DJ

I think this process is not valid in todays date. Can anyone suggest a way to transform s3 to RDS in current scenario?

bhai thoda zor bol le

How do we do this with the new interface?

How to capture the response in tkafkaoutput whether the messages are published or not?

Thoda jor se bolde bhai. Khud ko samjha raha hai ?

When I click on the launch matillion etl it displays an error saying timed out. It doesn’t loads the page. What is the solution for it? I stuck at 6.45

Hi Sir kindly advise me whether this course is covered with big queries and how to create models in dbt interfaces

I wanted to learn dbt ...is this course covered for dbt and big query as well

Hi kindly share your email id to get more details of the dbt

irritating background music

Hi, need your advice why the messages doesn't appear in tLogRow and tFileOutputDelimeted? What do I need to check?

Pls speak louder

get rid of the horrible music. sounds like a bad porno

Hi, Can you please explain how to use a while loop in dbt script to use in bigquery?

Thank you for sharing. Great video

This is an advertisement which is 1 min and 5 seconds long. It could be done in 30 seconds but the guy talks slow.

thank you for advertising your course.

finally, I found that t_assert..👌👌

why music??? :(

aa music endi rayya thala neppi dengutundi.. nuvvu nee lavadaalo music.................

speak up!!!

Hey man are you working previously as DJ.. as music is like I am attending any disco.... no need for this background noise... very distracting... keep it simple.

Music is very very annoying and terribly disturbingly unnecessary. Thanks for the video!!

I am not able to launch the instance. Can you please assist?

Hi brother send me your contact number

Please get rid of the music - it adds nothing and is extremely distracting.

hello sir

Please how did you create the Oracle instance?

Love the music! Wish more tutorials had it

Good Job !!

GooD to see this usefull components vedio in your channel

Good We except more from you bro

Good bro Take a scenario and explain them It will very usefull for the new learners

Simple way and easy to understand Beginers Looking for more stuff from you Brother

Can you brief me about what is the need of glue I’m new to data engineering .

Hi, thanks for the tips. Follow the steps shown in the video. However, in my case I need to write to an oracle on premises (external database). I created the jdbc connection (it works), I created the crawler pointing to S3(ok), I created the crawler pointing to oracle(ok). I created the Glue job reading from s3 and targeting oracle. However, when running the job, it generates the following error: Thread-5 WARN JNDI lookup class is not available because this JRE does not support JNDI. JNDI string lookups will not be available, continuing configuration. java.lang.ClassNotFoundException: org.apache.logging.log4j.core.lookup.JndiLookup at java.net.URLClassLoader.findClass(URLClassLoader.java:382) Thread-5 INFO Log4j appears to be running in a Servlet environment, but there's no log4j-web module available. If you want better web container support, please add the log4j-web JAR to your web archive or server lib directory. how to enable log4j?

Do some more video bro DBT and snowflake

Jim , I am viewing ur channel now to get some idea on glue

please remove the background music

In your previous video you had selected the ETL role for the DB permissioning. The explanation in this requested follow-up I would've found most helpful if you demonstrated the creation and setup of the ETL role + policy. In your previous video which was great and generally very comprehensive, this was the only part which I think someone could become stuck on when following along and building this small s3-glue-rds pipeline. This video was good to show what roles where involved but still leaves the setup a mystery. it would be great if you demonstrated this. Thank you for your hard work.

Where you used classifier in crawler?

very good of work! would u mind if I send questions?

Nice ..but background music its getting disturbance

if we learn dbt do we need to still learn other ETL tools like matillion etc

thanks brother great video, can we use same technique to load data from s3 to redshift