Пікірлер
@namansingh5933 6 күн бұрын
i have written the same password as snowflake account in SNOWSQL but the command prompt is giving wrong password error. what could i do?
@jake115577 16 күн бұрын
Is it possible to create a custom airflow provider? Great video btw!🎉
@jayantpanigrahi7532 17 күн бұрын
Thank you sir for the video. You are saying point to point things which are the crucial things to know. It really reminding my training time. Sir I would love to know about it whether is there any Video course on Udemy regarding Snowflake taught by you?
@atulbisht9019 18 күн бұрын
this series was really helpful for me....thanks for making this
@saikoushalnakka7625 21 күн бұрын
Very Simple Explanation Loved it
@ammanbasher 24 күн бұрын
Nice series, is this complete or do you have somewhere complete course for airflow?
@anhhung4737 25 күн бұрын
sorry but my Docker doesn't show any logs and localhost 8080 is not responding. Can you help T.T
@aymenhouidi6964 27 күн бұрын
When I run the command: dbt debug I get this error: Encountered an error loading local configuration: dbt_cloud.yml credentials file for dbt Cloud not found. Download your credentials file from dbt Cloud to `C:\Users\aymenh\.dbt` Can you help me solve this problem?
@mrp12-ii 28 күн бұрын
Fantastic playlist. So well made!! Thank you!
@sandeshbidave565 28 күн бұрын
How to achieve incremental insert in dbt without allowing duplicates base on specific columns?
@Bobthetomado 28 күн бұрын
0:28 c'mon guys. ASSET
@Bobthetomado 28 күн бұрын
It would be helpful to show how to revert the table back to a timestamp
@Bobthetomado 28 күн бұрын
Hate to be this guy but 2:34 has Tina in the AP partition AD the EU partition when she should only be in the EU partition
@abdulshakurchannel9050 28 күн бұрын
Thanks for this great series of lectures. How can we get the data used for explanations
@gokul2555 29 күн бұрын
Team, I need ER diagram, DDL and data for learning
@syedazher5708 Ай бұрын
Hi bro i want learn sql like this like industry expert where can i learn? on internet only basic explaination available can please me the resources link to learn sql like industry expert.
@SleekData Ай бұрын
Dear Friends - Got questions like these? How can we use SQL for data transformations? Can SQL handle all types of data transformations? If so, check out this video! You can jump to 2 min 30 sec to see how SQL and CTEs play a powerful role in data transformations. kzbin.info/www/bejne/eZyUi3R-ebeJZpo
@TheBdemba16 Ай бұрын
Dude these videos are killer. Hope you got more on the way. Best content ive seen on dbt and airflow
@GireeshPuthumana Ай бұрын
Your videos are very simple and easy to follow along for newcomers and for those who seek to refresh their Snowflake knowledge. Thank you.
@mustafabohra2070 Ай бұрын
Tons of blessings towards you.
@StephenRayner Ай бұрын
Straight to the point thank you.
@SleekData Ай бұрын
Dear Friend, Glad you like them! To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@StephenRayner Ай бұрын
@@SleekData a video on meltano + DBT would be epic. Also dbt + local LLM. E.g cleaning up bad contact model with first name last name salutation, dob, multiple address fields. But having really bad data quality e.g name not split up, email, phone and name in wrong places e.g in random address fields etc.
@amiyakumarnayak8286 Ай бұрын
Please upload the Notes
@SleekData Ай бұрын
Dear friend - Pls check if this helps: sleek-data.blogspot.com/2024/08/airflow-tutorial-deferrable-operators.html To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, we would be so grateful! Once again thank you for your encouragement.
@sassydesi7913 Ай бұрын
awesome! wish you could make a video everyday. to the point. great work
@SleekData Ай бұрын
Dear Friend, Glad you like them! To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@soralmeister754 Ай бұрын
is snowflake suitable for small businesses ?
@SleekData Ай бұрын
Yes, snowflake fits in for all size of companies.
@ThànhNguyễnViệt-f8u Ай бұрын
Hi Sleek, Im trying to open the localhost but it doesn't response. When View Details, it says "SyntaxWarning: invalid escape sequence '\d'"
@SleekData Ай бұрын
Dear Friend Please double-check the Docker Compose file. You should expose port 8080 from a container to the host. You can refer to the previous video in the playlist. Try all possibilities: 127.0.0.1:8080 127.0.0.1:8080 127.0.0.1:8080 localhost:8080 localhost:8080 Also, please open the command prompt and type ipconfig and hit enter. You will get your IPv4 Address. For example, if it is 192.168.56.1, then please try all possibilities with that IP address: 192.168.56.1:8080 192.168.56.1:8080 192.168.56.1:8080
@maheshdave7429 Ай бұрын
One of the few playlists I binged watch and did practical as well. Thank you so much for great content. I am waiting for Airflow video.
@SleekData Ай бұрын
Dear Friend, Glad you like them! pls check above link for airflow playlist. kzbin.info/aero/PLc2EZr8W2QIAI0cS1nZGNxoLzppb7XbqM To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@kumaran3534 Ай бұрын
Helpful!😊
@SleekData Ай бұрын
Dear Friend, Glad you like them! To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@roamthelostworld Ай бұрын
I don't see any sample file here
@SleekData Ай бұрын
Dude - here you go: sleek-data.blogspot.com/2024/08/snowflake-storage-layer-key-concepts.html To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@-PhamSonHoangPhuc Ай бұрын
Your video is very interesting, so what is the difference between spark and dbt?
@SleekData Ай бұрын
Dear Friend, Glad you like them! Spark: Apache Spark is a distributed data processing framework designed to handle large datasets efficiently. For instance, if you need to process 10 million records, Spark distributes these across 10 nodes, each processing 1 million records, thereby speeding up the overall computation time. Databricks is a well-known platform built on Spark. dbt: dbt (data build tool) is not a data processing platform but a SQL-based framework for developing and managing data transformations. It helps you write and maintain SQL code that is then executed on data processing platforms like Databricks, Snowflake, or Synapse. dbt converts your SQL code into a format compatible with these platforms, but it does not perform the actual data processing. To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@-PhamSonHoangPhuc Ай бұрын
@@SleekData oh , thanks for your explanation
@Deepjungle80 Ай бұрын
Do i still need python version 3.11 or lower to operate DBT?
@SleekData Ай бұрын
Dude - Pls refer below: always choose or upgrade to the one in green, worst case yellow... devguide.python.org/versions/
@HajiTech-or3pf Ай бұрын
Hy, I love the tutorials! Where is the db in the video used,
@SleekData Ай бұрын
Dear friend - Just sign up for free snowflake DB: signup.snowflake.com/
@HajiTech-or3pf Ай бұрын
@@SleekData Thanks for reply, the snowflake doesn't have the OMS which you used
@dineshmanick Ай бұрын
Your Videos are super cool, please include the Queries in video description Might be useful to your viewers like me.
@SleekData Ай бұрын
Dear Friend, Glad you like them! The link for SQLs is already provided in the desc: sleek-data.blogspot.com/2024/04/snowflake-stages-hands-on-data-loading.html To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@HoangQuocat-xp5eu Ай бұрын
I do exactly what you do but when i run the final code this happens "airflow.exceptions.AirflowConfigException: Cannot use relative path: `sqlite:///C:\Users\Admin/airflow/airflow.db` to connect to sqlite. Please use absolute path such as `sqlite:////tmp/airflow.db`".
@SleekData Ай бұрын
Dude - could you try this in airflow.cfg? sql_alchemy_conn = sqlite:////C:/Users/Admin/airflow/airflow.db if it did not work, pls erase all and start from scratch, step by step and side by side.
@bishop9168 Ай бұрын
The docker file ran successfully but the docker-composer.yml file gives a 'version' obsolete message, any assistance will be appreciated.
@SleekData Ай бұрын
dude - please check below in your system docker-compose --version and accordingly try to Update the Compose File Version: version: 'x.y'
@basavapn6487 Ай бұрын
Great video,Short and crisp.well explained
@SleekData Ай бұрын
Dear Friend, Glad you like them! To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@basavapn6487 Ай бұрын
@@SleekData sure ,will share it.
@varsharaj6492 Ай бұрын
So Updating a record alone basically follows SCD 2 in a stream by preserving the history ???
@SleekData Ай бұрын
Dude You have to get change data from the stream, then use it in the merge - please refer below links for more details... www.snowflake.com/blog/building-a-type-2-slowly-changing-dimension-in-snowflake-using-streams-and-tasks-part-1/ www.snowflake.com/blog/building-a-type-2-slowly-changing-dimension-in-snowflake-using-streams-and-tasks-part-2/
@miguelmaken Ай бұрын
Nice info I'm from Colombia, You doing great!
@SleekData Ай бұрын
Dear Friend, Glad you like them! To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@epuriraghavendra3847 Ай бұрын
Can you please share the slides
@SleekData Ай бұрын
Sorry dude, don't have them with me now.
@pretty_pets_07 Ай бұрын
Thanks for creating these videos. This is very helpful for beginner level also explanation is super. Keep trying to do more videos .
@SleekData Ай бұрын
Dear Friend, Glad you like them! To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@yannawutkimnaruk7189 Ай бұрын
This series is really useful for a beginer like me. Thank you.
@SleekData Ай бұрын
Dear Friend, Glad you like them! To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@SanthoshDevadurga Ай бұрын
Can someone please provide me the insert statements (with data).
@SleekData Ай бұрын
Dude - pls check sleek-data.blogspot.com/2023/10/blog-post.html also with these ddls, pls ask chat gpt to give you some sample inserts. Good Luck. To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@kaarrannayeer 2 ай бұрын
Great short playlist for someone who needs to quickly jump start into airflow easily. Thanks a lot for the effort !!
@SleekData Ай бұрын
Dear Friend, Glad you like them! To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@SMD_Azhar 2 ай бұрын
After creating models data will be refreshed automatically? These models have upto date data ?
@SleekData Ай бұрын
dbt run --select customers dbt run Dude - you will have to schedule one of these commands either using your scheduler (via dbt cli) or you have to use dbt cloud to schedule your jobs as per the requirement.
@zainammad6432 2 ай бұрын
Nice series, the best thing about this series is in every video along with the theoretical concepts there is relevant practical example
@SleekData Ай бұрын
Dear Friend, Glad you like them! To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@jonathan.matheus 2 ай бұрын
thanks dude, I spent 2 days trying to find how to do it step by step without any complicated context going on, appreciated
@SleekData Ай бұрын
Dear Friend, Glad you like them! To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@himanshu2787 Күн бұрын
my print random quote failed can u help ?
@VishalChandra-ku1qu 2 ай бұрын
How do we access the Astronomer Docs?
@SleekData Ай бұрын
are you asking for this? :) www.astronomer.io/docs/
@udayveerbhadauria1659 2 ай бұрын
I've run into a bit of an issue. Whenever I try to run the snapshot, it keeps saying 001003 (42000): SQL compilation error: syntax error line 1 at position 41 unexpected '.13'. syntax error line 1 at position 41 unexpected '.13'. syntax error line 1 at position 56 unexpected '<EOF>'. I don't know what the problem is. Can you help?
@SleekData Ай бұрын
Dude - Without specific code that's causing the issue, it's difficult to troubleshoot. However, I suggest checking the SQL syntax of your model and reviewing the dbt logs for more detailed information.
@anshikatyagi1194 2 ай бұрын
Thank you. This video saved my day. The Snowflake documentation wasn't really helpful.
@SleekData Ай бұрын
Dear Friend, Glad you like them! To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@prakashmudliyar4834 2 ай бұрын
Labs demo should be a little slow. Give the audience sometime to grasp what's happening
@SleekData Ай бұрын
Dear Friend, Thanks for your feedback. To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, it would be so grateful! Thank you for your encouragement.
@sassydesi7913 2 ай бұрын
Great as always ❤️
@SleekData Ай бұрын
Dear Friend - Thank you for your kind words! We're delighted to hear that you're enjoying our content. To stay updated with our future videos, consider subscribing and sharing with your friends. Your support means a lot to us. Thanks again for your encouragement!