Hi ! As a newbie to the database world, I've built a DuckDB database using a few scripts to create tables and load .txt files into them. All is great except that 2 of the 20 tables created had no data after the data import script ran. I've checked, rechecked, and double-checked for spelling issues, because it's usually that or out-of-place punctuation, but nothing was found. I created log files for the database creation and loading scripts. The creation script shows that all the necessary tables are there. The import log is completely void. Any thoughts? Have a great day! Todd P.
Hi, that sounds strange indeed! To start off, is there anything different about the two .txt files that ended up empty after import? Are said files definitely non-empty? One other thing to check: are you using relative paths or absolute paths in the import script? Did the script's working directory change between when it worked (18 tables) and when it didn't (2 tables)? One common gotcha with DuckDB is that if a file path doesn't resolve to anything, the import can load zero rows without erroring.
Thanks Yana! I'll inspect for those issues. Im also going to setup a test database and try to load the two problem tables manually without using the script.. and see what happens. Ill probably learn something in the process! ๐
Good luck! If you have any questions in the meantime, feel free to drop them here too ๐โโ๏ธ
.png)