No video
Snowflake Real Time Issue || Data Size or Data Length Issue
Рет қаралды 1,934
Күн бұрын#snowflake #sql #snowflaketraining
#sql #snowflakerealtimeissue #snowflaketraining #snowflake #snowflakeissues
Snowflake Real Time Issue:
Employee.Txt File
ID,NAME
1,PRAVEEN KUMAR
2,RAJU
3,RAMESH
Data Length of Name Column is 7, I want to load
all 3 records without throwing Data Size Error
Prerequisites:
Database Creation
Schema Creation
Table Creation
AWS Account
S3 Bucket
Storage Integration Object
External Stage
File Format
List @stg
Copy Statement
Substr
Approaches:
1.TRUNCATECOLUMNS=TRUE
2.ENFORCE_LENGTH=FALSE
3.SUBSTR
@nagendrasrinivas-cj7sr 3 ай бұрын
incredibly helpful! The explanation was clear and concise, providing practical solutions to common data size and length issues in Snowflake. The step-by-step guidance made it easy to follow along and understand the concepts
@praveenkumarbommisetty6093 3 ай бұрын
Thankyou Nagendra
@maghy_kethychannel 7 ай бұрын
superb.plz make more and more real time scenarios like this.they are verymuch helpful to us
@praveenkumarbommisetty6093 7 ай бұрын
Sure
@mohammedvahid5099 Жыл бұрын
Nice sir thnk u
@pib4579 Жыл бұрын
How much salary will get in Accenture for snowflake data warehouse application developer for 4yrs professional exp nd 2 yrs of snowflake exp??
@Achive-Sucess Жыл бұрын
Hi sir sir i want some real time activities will u plzzz send? it will help a lot
@praveenkumarbommisetty6093 Жыл бұрын
Reach out to 9703180969
@user-vy3us9qt7u Жыл бұрын
what if we require praveen kumar in a varchar(7) column and dont want to truncate is there any option?
@praveenkumarbommisetty6093 11 ай бұрын
substr we can use
DemoHub | Demos For Modern Data Tools
Рет қаралды 432
Praveen Kumar Bommisetty
Рет қаралды 4,3 М.
Praveen Kumar Bommisetty
Рет қаралды 2 М.
Handle Deduplication While Loading CSV File Into Snowflake | Ch-07 | Snowflake Data Loading Approach
Data Engineering Simplified
Рет қаралды 5 М.
Chandoo
Рет қаралды 503 М.