It would help to know if you mean ALL of upstate NY, or only the part where you live.....
Upstate consists of more than 45,000 square miles. To completely flood that area would take an completely unimaginable quantity of water. To flood the Adirondacks, the water would need to be more than 5,000 feet deep.
Albany, Syracuse and Rochester are up to about 500 feet above sea level. Binghamton is 800 feet or so.
Tsunamis are very rare, if they happen at all, in the Atlantic ocean. It is so unlikely that there would be any such an event as to consider it impossible. To have a tsunami that would make it into Upstate NY is many orders of magnitude less likely.
If you look at a map, it will be clear that any tsunami will either have to cross all of Massachusetts, or go across Long Island, and over Connecticut to get to the upstate area. Anything coming straight down the Long Island Sound and parallel to the South Shore will go into New Jersey rather than go up the Hudson River Valley.
If there was an impact of a large enough meteor or asteroid near to the east coast to generate the kinds of waves that could overtop any of those barriers, then it is quite likely that everything within many hundreds of miles of the coast will be dead anyway.