SNOW's AI tools are driving workload growth and platform usage, but scaling deployments and rising competition may decide its next phase.