While writing the Snowpark code in a Snowsight Python worksheet, how can I select a specific schema? I know I can manually select it using the UI, but I want to select it programmatically.

I have string inputs like below select query

I’m trying to create a sequence into Snowflake for a table ID, I need it to increase 1 by 1 (1,2,3,4,…), how ever when I create it and try sequence.nextval it increases (1,101,201,301…) and I don’t know why.

I set the session tag with “ALTER SESSION SET QUERY_TAG = ‘%s’;”; but i get from VERACODE sql injection issue and to resolve that issue i need to use a prepared statement. but Snowflake for now doesn’t support the prepared statement for ALTER.
Do they intend to support that, if yes when, and if not how i resolve that issue in Veracode?

I’m trying to create a SQL function like below, I was passing databasename, schemaname and table name as input. I was not able to use the input database name for the information_schema

I am trying to load the data into a internal stage using the snowsql put file command.