Тёмный

Import Multiple CSV Files (Data Files) to SQL Server With Python (Source Code In Description) 

Jie Jenn
Подписаться 64 тыс.
Просмотров 8 тыс.
50% 1

If you are building a data pipeline, and one of the tasks is to upload bunch data files to a database table, then you will probably find this automation script useful.
📑 Source Code: learndataanaly...
📘 Learn more about BULK INSERT: learn.microsof...
► Microsoft SQL Server 2022 database system download
www.microsoft....
► SQL Server Management Studio download
learn.microsof...
► If you need a sample database to play around with, also check our the AdventureWorks sample database provided by Microsoft.
• How to download and im...
📺 How To Build A MS SQL Server SQL Query Tool Using Excel: • Building A MS SQL Serv...
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/...
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🛒 By shopping on Amazon → amzn.to/2JkGeMD
👩‍💻 Follow me on Linked: / jiejenn
🌳 Becoming a Patreon supporter: / jiejenn
✉️ Business Inquiring: RU-vid@LearnDataAnalysis.org
#sqlserver #sqlserver2022 #python #pythonprogramming

Опубликовано:

 

12 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 12   
@TheSelfemployedInvestor
@TheSelfemployedInvestor Год назад
This is really helpful! Also, is there a way to import all the files into a different table each, like the script creating a new table for each file to add to the database? Thanks! Great content!
@jiejenn
@jiejenn Год назад
You can. One approach is to use the IF statement to direct which table each dataset should go into.
@TheSelfemployedInvestor
@TheSelfemployedInvestor Год назад
@@jiejenn okay, but for that I have to create each table first correct? I need to create like 140 tables haha, I thought I could make the script create each table and then insert the file in the table it created and so on with the 140 files
@Kr0n0Z616
@Kr0n0Z616 Год назад
awesome work mate!! Thank you,, you helpe me a lot, I'm a little confused abuot the necessary steps to create the connection and upload the data from your computer, is it no necessary to give a path from the folder??
@jiejenn
@jiejenn Год назад
os.getcwd() will return the file directory. os.path.join() will let you concate the paths into a single string.
@ullaasmenon
@ullaasmenon Год назад
Loved it! Thanks so much for sharing this. Exactly what I was looking for. Saved me a lot of time to build it myself. I owe you one! :)
@jiejenn
@jiejenn Год назад
Glad the video helped!
@florencerumbidzaihlupo3074
@florencerumbidzaihlupo3074 Год назад
how do l archive the files that l have loaded
@user-sj2xb4cv6i
@user-sj2xb4cv6i 7 месяцев назад
is it for mysql?
@jiejenn
@jiejenn 7 месяцев назад
No, it is for SQL Server.
@user-sj2xb4cv6i
@user-sj2xb4cv6i 7 месяцев назад
I need to apply it to MySQL, can you develop it?@@jiejenn
@user-sj2xb4cv6i
@user-sj2xb4cv6i 7 месяцев назад
@@jiejenn Could you do it for mysql?
Далее
Вопрос Ребром - Булкин
59:32
Просмотров 1,1 млн
How Strong is Tin Foil? 💪
00:26
Просмотров 48 млн
Learn Python With This ONE Project!
55:04
Просмотров 1,8 млн
Cursor Is Beating VS Code (...by forking it)
18:00
Просмотров 95 тыс.