SnowConvert: Teradata SQL to Snowflake Scripting (Procedures)
Teradata’s ABORT and ROLLBACK statements are replaced by a ROLLBACK statement in Snowflake Scripting.
Importing 3rd party Python packages containing non-Python files using Snowflake stages when creating Python UDFs
ISSUE: When creating a Python UDF, 3rd party Python packages can be imported using a Snowflake stage as long as it complies with the guidelines defined in Limitations on Python UDFs. In cases where the Python package contains more than…
Search Optimization: When & How To Use - Part 2/3
ISSUE: How to check which services to use on a table out of Search Optimization and Auto Clustering.
Solution: Snowsql not generating DDL using GET_DDL('DATABASE','DB') for larger database
ISSUE: The Snowsql tool is not able to generate DDL commands using the command GET_DDL('DATABASE','DB') for database larger than 14 MB. SOLUTION: This is mainly because the formatter does padding (spaces) on top of the fetched data.
How to convert a DynamoDB-formatted JSON to a generic-formatted JSON(Python).
ISSUE: DynamoDB formatted JSON is not the same as generic - formatted JSON. If you need to convert DynamoDB formatted JSON you can use the provided UDF.