Conversion Functions- Part1
Conversion functions allow a data item of one datatype supported by Snowflake to be transformed into another datatype.The functions are numerous and are divided... Read more.
INFORMATION SCHEMA
The Information Schema is a tool full of potential that allows us to keep track of numerous aspects of our account and the database in which it exists.Further p... Read more.
Two ways to populate a table with stage data
MATCH_BY_COLUMN_NAME vs Variant data type I found myself having to insert files from my device into my database.The final aim of the process was to obtain a tab... Read more.
How to become a SnowPro
I took the SnowPro Core Certification exam. I will make some observations and give some advice on how I approached preparing for the exam and how I would approa... Read more.
Mockaroo: fake realistic data
In writing previous blogs, I found myself having to search for old tables in which I had data to perform specific processing just to give examples and to make c... Read more.
Chart Visualizations in Snowsight
Along with the interactive results, Snowsight also offers a Chart Visualization service.The section dedicated to this type of charting is located in the window ... Read more.
Interactive results in Snowsight
When we run a query we would like to have a quick overview of the results, to have an immediate picture of the quantities and data in the table on...... Read more.
Saving time: shortcuts in Snowflake!
Often we are faced with time constraints or impending deliveries, it would be handy to have a way to speed up writing, manipulating and navigating Snowflake.The... Read more.
DROP,TRUNCATE and DELETE
Three ways to delete your data. We compare three commands on different characteristics such as: the family of commands they belong to, their usage, the syntax o... Read more.
Micro-partitions and Clustering:
Let’s talk about partitions! The desire to partition large amounts of data organized in large tables within data warehouses stems from the need for better... Read more.
