procedure to ingest the data from exterstage with schema inferring.
no need to write big queries.
pass the table name stage and location, it will generate the sql for you and will ingest the data.
Note: Your stage should be created at same schema as the procedure, In our case it should be in public. Also you need to create the file format.
This code cannot be used without consent of the owner. Please find the steps to get consent see file(steps.txt)