Ygtjki

The Mastermind rogue in my game was well hidden when he threw a flask of holy water at a shadow demon that attacked his ally. In the moment, it made the most sense to me to allow him to use Sneak Attack while hitting the fiendish creature with the flask.

The description of Holy Water says:

As an action, you can splash the contents of this flask onto a creature within 5 feet of you or throw it up to 20 feet, shattering it on impact. In either case, make a ranged attack against a target creature, treating the holy water as an improvised weapon. If the target is a fiend or undead, it takes 2d6 radiant damage. [...]

The rogue's Sneak Attack feature says:

[...] Once per turn, you can deal an extra 1d6 damage to one creature you hit with an attack if you have advantage on the attack roll. The attack must use a finesse or a ranged weapon. [...]

Now, post-session, I'm wondering whether Sneak Attack can actually be applied to an improvised weapon. I ruled it as a ranged weapon attack since he threw it, but now that I'm thinking about it: an improvised weapon might not be considered as a ranged weapon. And that would mean that a Sneak Attack could not have triggered when hitting with the flask. Unless an improvised weapon is also a ranged weapon when used as such. In that case, it could trigger.

I'm not sure which interpretation is correct according to the books. So, can Sneak Attack be used when hitting with an improvised weapon?

Not unless you have an ability that allows Sneak Attack with an improvised weapon

The criteria for sneak attacks are clear. “The attack must use a finesse or a ranged weapon” - that is, it must have the “finesse” tag or be listed in the martial or simple ranged weapons table. Improvised weapons are neither.

Making a ranged attack does not make it a ranged weapon. Note also, you cannot make a sneak attack with a “thrown” melee weapon unless it has the “finesse” tag; so you can with a dagger but not with a hand axe.

Maybe - if it's similar enough to a qualifying weapon

You can only use Sneak Attack using finesse or ranged weapon, which means that the object you are attacking with is actually a weapon, which must be listed in Weapons table. Improvised weapon is not included in that table.

Fortunately, there is this passage from Improvised Weapon section

Often, an improvised weapon is similar to an actual weapon and can be treated as such. For example, a table leg is akin to a club. At the DM's option, a character proficient with a weapon can use a similar object as if it were that weapon and use his or her proficiency bonus.

For example, a butcher knife is not a weapon. However, it is similar to a dagger that has finesse property, so it can be used with Sneak Attack. If you have proficiency with daggers (as all Rogues should have), and the DM choose to do so, you can regard the butcher knife as a dagger. It then can be used with Sneak Attack.

Of course, your DM might regard that an object is not similar enough to be considered as 'that weapon'. In that case, you can't use Sneak Attack.

In your case, a thrown bottle is not a ranged weapon, although you are making a ranged attack with the bottle. It is not similar to any ranged weapon, or any weapon with finesse property, so as a DM I would definitely rule that you can't Sneak Attack with that.