วีดีโอ

great

Thank you brother

Good content and Keep it up and maintain below 9 min

Good explanation

Can you please make a video on CTE with 2 or 3 examples.

Great video. If you could explain why we are replacing the values with Mean, Quantile etc. would have been beneficial. And also could you please make a standalone video on Visualisation with Python or any other visualisation tool.

how much time does it take to respond ??

Very good job saad, it was a beautiful project work with many common functions covered. thank you.

Your instructions worked for me. I got the call from support. Thanks for saving my time.

Hi Saad, I am getting error ‘ Unable to start program DTS’ while running a SSIS package on my local. Can you please help? It’s urgent.

great video sir

Thanks, you help me a lot🎉)))

Simple and straight explanation. Worked on windows. Also taken help from Chat -GPT when my PIP was not working because the Scripts directory, where `pip` is located, is not in my system's PATH environment variable

Really helpful. Thank you.

hi i want to download it for postgresql and oracle database but it is not supporting

At last python -m notebook completed but it is opening in vlc media player

hey, can u show congfig.yaml ?

Thanks for the valuable info Saad Thankyou so much again !!

THANKS I followed same steps and its worked.

Bro , i got same error . I also tried to reach out team using support case as you did but it didnot worked

which bank account works i heard that most of the credit, debit card doesn't work so can you please give any recommendations on this as i want to make a bank account for it but don't have any idea which one is going to work good.

thanks in many video there is no this solution,

Thanks bro, I even learnt more than expected

Thank you so much !

can we save model output to .txt file ?

Can we create a .txt file where this df data is stored ?

Thanks alot

bro, i need one dataset for my college project.that is cybercrime. coud u give the link for that.

Bhai thanks so much ..

Buddy this worked and I got the call from there support. JazakAllah!

Cowdamnit!!! Thank you man.

Thank you sir. Helped alot 😊

Good tutorial!

Good video thanks. Only thing i would do differently is give less permission to the service account. Probably Big Query User & Big Query Data editor roles are enough.

Saad thanks for helping us out, But which version of python supports dbt plz let me know

Thanks saad Now my account is open with your video .I am very glad to like and subscribe your channel .Have a great journey

There is couple adjustments made in the policies you can use this : { "Version": "2012-10-17", "Statement" : [ { "Effect": "Allow", "Action": [ "s3:PutObject", "s3:GetObject", "s3:GetObjectVersion", "s3:DeleteObject", "s3:DeleteObjectVersion" ], "Resource": "arn:aws:s3:::bucketName/*" }, { "Effect": "Allow", "Action": "s3:ListBucket", "Resource": "arn:aws:s3:::bucketName", "Condition": { "StringLike": { "s3:prefix": "*" } } } ] }

informative video with demo

Good one bro Can you create timestamp file which update whenever job runs using python

python -m notebook Thank u it works!!!!!! btw tell me pip install jupyter kaha pe install ho rha .. c drive mei? ya app k taur par

how many records will support in dbt if csv file

Thank you sir for this video

Same error but still not resolved according to Customer Support they are try to contact me but they could not than I requseted my for alternate number still they are not able to call me ,

Superb sir, thanks lot 💯

Hi Sir, Thank you for this video. I am trying to automate the file transfer ( AUTO-INGEST ) process but its not working. here is the steps and script i took so far. My Event notification is not working . when ever a new file come to folder its not able to detect that. //CREATED TABLE CREATE OR REPLACE TABLE SPOTIFY_DB.PUBLIC.ALBUM ( album_id string, name string, release_date string, total_tracks int, url string) // create integration link between s3 and snowflake create or replace storage integration s3_init_spotify TYPE = EXTERNAL_STAGE STORAGE_PROVIDER = S3 ENABLED = TRUE STORAGE_AWS_ROLE_ARN = '<ARN ROLE>' STORAGE_ALLOWED_LOCATIONS = ('s3://Spotify_data/transformed_data') COMMENT = 'Creating connection to S3' DESC integration s3_init_spotify -- ( from this i created IAM role and provided the 'STORAGE_AWS_IAM_USER_ARN' and 'STORAGE_AWS_EXTERNAL_ID' //make connection by creating the STAGE CREATE OR REPLACE stage MANAGE_DB.external_stages_schema.SPOTIFY_Album URL = 's3://Spotify_data/transformed_data/album_data' STORAGE_INTEGRATION = s3_init_spotify FILE_FORMAT = MANAGE_DB.file_format_schema.csv_fileformat LIST @MANAGE_DB.external_stages_schema.SPOTIFY_Album //Creating the PIPE and STAGE for Automating the file transfer part create or replace schema manage_db.pipes create or replace pipe manage_db.pipes.Album_pipe AUTO_INGEST =TRUE as COPY INTO SPOTIFY_DB.PUBLIC.ALBUM FROM @MANAGE_DB.external_stages_schema.SPOTIFY_Album Project Execution Flow Lambda Trigger (every week) -> Run spotify_api_data_extract code (Extract Data from Spotify Top 50 - Global Playlist using spotipy library) -> Stores Raw Data in AWS S3 -> Trigger Transform Function -> Run spotify_transformation_load_function code (Transforms the data) -> Stores Transformed Data in AWS S3(Which then sends event notification to snowpipe) -> Triggers the Snowpipe which then extracts the data from transformation buckets and loads them in respective tables in Snowflake -> Data stored in snowflake can be queried for Analysis Will you please help me on that?

Please also attach the source files in future

can we create a view using dbt seed?

@SaadQureshiOfficial Can you please provide some insight on how we can increase the overall perm size of this instance?

Can you explain the first command snowsql -c training...??? What is training here?

Bro, Pakistan k mobile no. mai International calls tu allow nhi hoti, Tu wo allow ksy krwain?