A scoped URL expires when the persisted query result period ends, which is typically after the results cache expires. This is currently set to 24 hours

In Snowflake, the ownership privilege for a schema includes:
Automatic granting to the creator's role: The role that creates a database object within the schema automatically receives ownership of that object.
Ability to manage grants: Ownership enables the role to manage permissions and grants on the schema and its objects, allowing them to control access at the schema level.
Ownership does not directly confer query privileges or the ability to alter warehouse settings, nor is it transferable without specific privilege management actions.

The list @my_stage command in Snowflake can be used to verify if data has been uploaded to an external stage named my_stage. This command provides a list of files that are present in the specified stage2.