To get the most detailed information about individual table storage details in Snowflake, the TABLE STORAGE METRICS view should be used. This Information Schema view provides granular storage metrics for tables within Snowflake, including data related to the size of the table, the amount of data stored, and storage usage over time. It's an essential tool for administrators and users looking to monitor and optimize storage consumption and costs.
References:
* Snowflake Documentation: Information Schema - TABLE STORAGE METRICS View

In Snowflake, Data Shares can be created and managed in two primary ways:
* Via the Snowflake Web Interface (UI): Users can create and manage shares through the graphical interface provided by Snowflake, which allows for a user-friendly experience.
* Via SQL commands: Snowflake also allows the creation and management of shares using SQL commands. This method is more suited for users who prefer scripting or need to automate the process.
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html

To convert rows in a relational table to a single VARIANT column and unload the rows into a file in JSON format, you can use the COPY command in combination with the OBJECT_CONSTRUCT function. The OBJECT_CONSTRUCT function converts the row into a JSON object stored in a VARIANT column, and the COPY command can then be used to unload this data into a JSON file.
:
Snowflake Documentation: OBJECT_CONSTRUCT
Snowflake Documentation: COPY INTO <location>
Top of Form
Bottom of Form

To change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse, the warehouse must be in a suspended state. This ensures that no operations are disrupted during the modification process.
Suspend the Warehouse:Ensure that the warehouse is suspended.
ALTER WAREHOUSE my_warehouse SUSPEND;
Alter the Warehouse:Modify the warehouse to be Snowpark-optimized.
ALTER WAREHOUSE my_warehouse SET WAREHOUSE_TYPE = 'SNOWPARK-OPTIMIZED'; Resume the Warehouse:Resume the warehouse to make it operational.
ALTER WAREHOUSE my_warehouse RESUME;
References:
Snowflake Documentation: Creating Snowpark-Optimized Warehouses
Snowflake Documentation: ALTER WAREHOUSE

When initiating a session in Snowflake, the system determines the current role based on the user's connection details and role assignments. If a user specifies a role during the connection, and that role is already granted to them, Snowflake sets it as the current role for the session. Alternatively, if no role is specified during the connection, but the user has a default role assigned, Snowflake will use this default role as the current session role. These mechanisms ensure that users operate within their permissions, enhancing security and governance within Snowflake environments.
Reference:
Snowflake Documentation: Understanding Roles