My skillset is primarily on Oracle database and unix, so snowflake is literally very new to me, .... as in a couple of days
I am currently ingesting data from Oracle into snowflake cloud via blob storage. Some of the 30yr old data is afragmented so needs some fixing. This would have been easy within my comfort zone using pl/sql to deal with the issues that can't be resolved with sql. Absolutely no chance of cleansing the data at oracle source so needs to be done at the staging side in snowflake.
Question is what is the best progaming language to use within snowflake for data cleansing?, someone mentioned python but just wanted to be sure that gives just as much flexibility as pl/sql.
Also what is the best 3rd party too to run queries in snowflakes, the web interface is just not my cup of tea
Thanks
I am currently ingesting data from Oracle into snowflake cloud via blob storage. Some of the 30yr old data is afragmented so needs some fixing. This would have been easy within my comfort zone using pl/sql to deal with the issues that can't be resolved with sql. Absolutely no chance of cleansing the data at oracle source so needs to be done at the staging side in snowflake.
Question is what is the best progaming language to use within snowflake for data cleansing?, someone mentioned python but just wanted to be sure that gives just as much flexibility as pl/sql.
Also what is the best 3rd party too to run queries in snowflakes, the web interface is just not my cup of tea
Thanks
Comment