© 2023 Hashnode
#snowflake
Snowflake is a cloud-based data warehousing platform that allows you to store, manage, and analyze large amounts of data. Here's a brief tutorial to get you started: Create an Account: Go to the Snowf…
Data tagging is a priority objective, critical to the ability to both locate information and enable automated access control decisions. This document articulates the minimum functional requirements of data tagging standards needed to facili…
Snowflake is a cloud-based data warehousing platform that provides users with an unprecedented level of data integration, management, and analysis. The platform is designed to meet the demands of mode…
By the end of this article, you have learned some frequently used functions used in Snowflake when dealing with Date and Time. To get the current date SELECT CURRENT_DATE AS “CURRENT DATE”; Output…
前言 Javascript 整数表达最大为 2^53-1 位，大约是十进制16位，超过就会导致精度丢失，一般在浏览器中会直接报错。 场景 我们知道，雪花算法(SnowFlake)生成的雪花ID是 2^64 位，如果直接使用雪花算法(SnowFlake)生成器，前端是没办法直接拿到int类型的雪花ID，需要后端先将其转换为string类型才行。 使用雪花算法(SnowFlake)的很重要一个原因就是，int类型对数据库索引是很友好的，为了前后端数据交互方便，在数据库中直接储存s…
dbt (data build tool) is an open-source command-line tool that helps data analysts and data engineers automate the process of transforming and loading data from various sources into a data warehouse. …
Photo by Damian McCoig on Unsplash Snowflake is a cloud-based data warehouse designed to be easy to use and fast, and it is a fully managed, which means there is no software to install or maintain. Sn…
BigTable You may not have heard about Google’s BigTable but it is a thriving NoSQL database offering from the juggernaut, allowing exceptional read/write performance when properly tuned. According to …
With spark-snowflake connector writes We have discussed the internals of spark snowflake writes in the previous post, in this post lets observe how the schema changes such as missing column/extra columns, data type changes behaves with spa…
Cloud Data Warehouses In the past few years, we've seen a rapid growth in the usage of cloud data warehouses (as well as the "warehouse-first" paradigm). Two popular cloud DWH platforms are BigQuery a…
