During this post we will discuss how to extract the DDL of entire user defined tables in particular database. Later on, we will use these DDL to create the same tables in another Database. Very first thing comes to our mind that we can use GET_DDL command to extract the metadata. But […]
Read More
During this post we will discuss connecting Excel with Snowflake using ODBC driver. We can connect the Excel to the snowflake database and execute the query. ODBC Driver will return the data from Database and display in Excel workbook. The benefit of doing this we can leverage the capabilities of […]
Read More
During last post we talked about to Handle Duplicate Records with No matching Key. Consider the scenario where source team would provide the complete file instead of Delta on daily base. Snowflake Developer team has to process this feed file in Database. Instead of consuming the complete file in Snowflake […]
Read More
During this post we will discuss how to access data stored in Snowflake via Python REST API. In our Python code will use FLASK API to get Snowflake data. Consider the case where web applications often want to retrieve that data through http APIs. This API consists of reporting endpoints […]
Read More
During this post we will discuss Materialized View on Shared data in consumer account. Consider the scenario where Consumer has to perform some analysis on data. Analysis require aggregation on this shared data that take a long time to calculate. However, Consumer does not own this data and has asked […]
Read More
During this post we will discuss about the one argument use inside the Snowflake Python Connector. Recently while looking for performance topic I have come across the SnowflakeNoConverterToPython argument. However, As per the documentation this argument is handy to improve Performance by Bypassing Data Conversion. Inside Snowflake python connector, there […]
Read More
