switch to using snowflake id