Tracking DDL Changes in Snowflake: A Real-World Solution By Sachin MittalOctober 8, 2024 Snowflake Javascript procedure
Migrating Source Views to Snowflake – Discrepancy in View Definition By Sachin MittalSeptember 11, 2024September 11, 2024 Snowflake Javascript procedure
Warehouse Grants Summary Report By Sachin MittalAugust 29, 2024August 29, 2024 Snowflake Javascript procedure
Data Synchronization with Dynamic Procedures By Sachin MittalAugust 9, 2024 Snowflake Javascript procedure
Dynamic Table Creation Using File Headers By Sachin MittalJuly 31, 2024 Snowflake Javascript procedure
Automating Warehouse Usage Reports in Snowflake By Sachin MittalJuly 11, 2024July 11, 2024 Snowflake Javascript procedure
Automating Business Day-Specific Tasks with Snowflake By Sachin MittalJune 27, 2024June 27, 2024 Snowflake Javascript procedure
Use Case for Loading Daily Feeds into Snowflake By Sachin MittalJune 16, 2024June 16, 2024 Snowflake Javascript procedure
Tasks Failure Recovery in Snowflake with RETRY LAST By Sachin MittalJune 12, 2024 Snowflake Javascript procedure
Analyzing Table Usage in Stored Procedures By Sachin MittalJune 3, 2024 Snowflake Javascript procedure
Use Case: Monitoring Internal Stage Stale Storage By Sachin MittalMay 8, 2024 Snowflake Javascript procedure
Dynamic Merge Procedure: Snowflake’s Enhanced Flexibility By Sachin MittalMay 3, 2024May 3, 2024 Snowflake Javascript procedure
Credit Consumption Notification by Role By Sachin MittalApril 12, 2024 Snowflake Javascript procedure
Identifying Table Types Within a Session By Sachin MittalApril 10, 2024 Snowflake Javascript procedure
Automating Dynamic Table Creation with Event Logging By Sachin MittalFebruary 27, 2024 Snowflake Javascript procedure
SQL Scripting with Event Tables By Sachin MittalJuly 21, 2023July 21, 2023 Snowflake Javascript procedure
Identify underlying table in VIEWS via procedure By Sachin MittalMay 26, 2023 Snowflake Javascript procedure
Transfer ACCOUNTADMIN Ownership to Custom Role By Sachin MittalApril 26, 2023 Snowflake Javascript procedure
Snowflake: Identify NULL Columns in Table By Sachin MittalFebruary 25, 2023 Snowflake Javascript procedure
SHARES: Extract Details about Objects By Sachin MittalDecember 23, 2022 Snowflake Javascript procedure
User Notification: SYSTEM$SEND_EMAIL() By Sachin MittalDecember 5, 2022December 5, 2022 Snowflake Javascript procedure
Account_Usage: Metadata Tables Backup By Gautam SinghNovember 13, 2022November 14, 2022 Snowflake Javascript procedure
Copy and Unload via Javascript Procedure By Sachin MittalOctober 14, 2022 Snowflake Javascript procedure
GET_OBJECT_REFERENCES: Get View and Table count By Sachin MittalOctober 11, 2022 Snowflake Javascript procedure
Identify Long Runner and Kill automatically: JS Proc By Sachin MittalSeptember 28, 2022 Snowflake Javascript procedure
JavaScript to execute DML statements in Table By Sachin MittalAugust 21, 2022 Snowflake Javascript procedure
Snowflake:SQL Scripting Procedure to find Duplicate By Sachin MittalJuly 26, 2022 Snowflake Javascript procedure
UNDROP or RECOVER Table Programmatically By Sachin MittalMarch 27, 2022 Snowflake Javascript procedure
Logging: DBMS_OUTPUT in Snowflake Stored Procedures By Sachin MittalJanuary 23, 2022 Snowflake Javascript procedure
Snowflake: ROLLBACK and COMMIT in JavaScript Procedure By Sachin MittalDecember 30, 2021 Snowflake Javascript procedure
Snowflake: JavaScript Procedure to load Parquet data By Sachin MittalDecember 27, 2021 Snowflake Javascript procedure
Snowflake: Enable CHANGE_TRACKING for multiple tables By Sachin MittalNovember 16, 2021November 16, 2021 Snowflake Javascript procedure
Snowflake: Setting SESSION parameter via Stored Procedure By Sachin MittalOctober 30, 2021 Snowflake Javascript procedure
Snowflake: ERROR LOGGING during COPY Operation (Source-Target) By Sachin MittalOctober 11, 2021 Snowflake Javascript procedure
Stored Procedure: Logging, Looping, Loading, Unloading, Parameters, PROC call By Sachin MittalSeptember 24, 2021 Snowflake Javascript procedure