Naming Standards
Account Objects Entities
Object Type Naming Rules Examples Entity Type Prefix
User firstname.lastname joseph.kirshenbaum Hub HUB
Role Proj_name_<program>_<business_function> Proj_name_DSS_DEVELOPER Link LINK
Warehouse Proj_name_<business_function>_WH Proj_name_CSI_WH
Database Proj_name_<zone>_DB_<env> Proj_name_CURATED_DB_DEV Satellite SAT
Resource Monitor Proj_name_<warehouse_name>_RM Proj_name_IT_WH_RM_DEV Stage STG
Integration Proj_name_<subject>_<category>_ INT Proj_name_S3_DATALAKE_STORAGE_INT Hierarchical Links HLINK
Schema Proj_name_<subject_area> Proj_name_DATA_VAULT Same-As Links SAL
Table <entity_prefix>_<subject_area>_<table_name> DIM_VIDEO_PROGRAMS Point-in-Time PIT
View VW_<entity_prefix>_<sa>_<view_name> VW_VIDEO_PROGRAMS
External Table EXT_<cloud_storage>_<source_file_name> EXT_S3_CUST_ACCT_TMZN_TMP Bridge BRDG
Stored Procedure SP_<sa>_<stored_proc_name> SP_XGL_REMOVE_DUP Business Hub BHUB
Task TSK_<sa>_<task_name> TSK_CHECK_STRM_HUB_CUSTOMER Business Link BLINK
Stream STRM_<source_table> STRM_HUB_CUSTOMER Business Satellite BSAT
View Dimension VW_DIM
View Fact VW_FACT
Fact FACT
Development Jobs Dimension DIM
Naming Rules Example
Proj_name_ <type_of_job >_ <source_name >_ <service_name >_ <job_function >_ Proj_name_BATCH_NOVAR.ADCOPY_PY_RDV_SAT_ADCOPY
<target_name>
Fields
Attribute Type Column Name / Suffix
Record Source RS
Date Stamps DT
Time Stamps TS
Load Date Time Stamps LDTS
Hash Keys MD5
Hash Differences HASH_DIFF
Coding standards:
There is no coding standards provided by snowflake, since snowflake supports ANSI-SQL , one is free
to employ SQL Standards they would use in any other SQL-Based platform.
Snowflake’s expert DBAs have created a library of frequently used scripts to help you optimize and
manage data faster and easier.
https://community.snowflake.com/s/scripts
