You need to use “ls -la” to list the hidden files in your home (i.e ~) directory. These config files are “.bashrc”, “.inputrc”, “.profile”, etc. In computing, a hidden folder or hidden file is a folder or file that does not display by default when showing a directory/file listing. In Unix-like operating systems, any file or folder that starts with a dot character is to be treated as hidden.…

Unix is a very powerful tool to automate monotonous & manual tasks. Here is a real-life example for data engineers & software engineers. If you are not familiar with Shell scripting the code may look complex, but if you dissect as shown below it becomes easier.

Problem statement: Given the below sample input file where there can be a “,” in the content itself.…

Q01 How will you go about to list all the table names used in a number of sql scripts for a given database say MY_DB_1?
A01 Let’s say you have a number of sample sql scripts like

test.sql: