วีดีโอ

sure. mail me if you have any queries . ysreenu.mba@gmail.com

oh, Voice reducing while uploading in youtube. dbt anni videos upload chesanu bro.

😢​@@64techskills

Thank you for your query. The file data has been sorted, and you can see sort operation in the 15 lines of code, data_list.sort().

​@@64techskills in my case I have 5000 rows both in file and table there are 4 columns in the file as below 14510;14510;0;Data 23276;23276;0;asdf 23323;23323;0;asdd 10022;10022;11;Heg and following in db table ch_num. BP_num. 13453 14510 0 Data x23276 23276 0 asdf 34673 23323 0 asdd 48116 48116 0 sassd 60913 60913 0 sadas x14510 14510 0 sasda 34564 23276 0 sdasd x23323 23323 0 dsasd I only want to compare first 4 rows with the 5000 rows in table but PROBLEM is that How I can arrange/sort rows in db table and file as the both rows in file and db table are not sorted as in your case one data is sorted. Please ask me if this is not clear

@@64techskills Can we sort on the basis of first three columns both in file and in db if yes what sort funtion would be used for sorting on the basis of first three columns. any tip would be appreciated

@@64techskills Thankyou so much for response but if you want to sort on the basis of first 3 columns then what will you do, any help will be appreciated

@@64techskills Can we sort on the basis of first 3 columns, any help will me appreciate

Agreed. there is no difference in using a local database instead of Snowflake. We decided to connect to a local database because we need to create a Snowflake account every 30 days. Once we have covered all the topics then we will start integrating Snowflake with real-time scenarios.

Sure. I will post soon.Thanks for watching.

give me ur number, i will call u

Here is the current end-to-end flow of my project: 1. We transform a CSV file to create a raw file. 2. The raw table is used to create a staging table. 3. We then create a fact table using the staging table and apply all business rules. 4. Finally, we create tests for the staging and fact tables (target table). Afterwards, we configure and run each step using Python scripts with the Control-M tool. each project has its own unique setup environment. will create and share end to end flow soon.

@@64techskills bro mimmalini connect avvali ante ela, if possible

please share ur number to ysreenu.mba@gmail.com, i will call u

Ans is NO. bcz dbt is not etl tool , it will work ontop of datawarehouse. you have to use any other etl tool like hivedata,firvetran, IICS etc...

once virtual env created , you need to activate using below command .\dbt_venv\Scripts\Activate.ps1. please follow the below steps. 64techskills.blogspot.com/2024/01/how-to-install-dbt-in-windows-and.html

Thanks. sure will do