Posts

How we can load the data from AWS S3 into snowflake and unload data from snowflake to s3

Image
            Load the data from AWS S3 into Snowflake and unload data from snowflake to s3 bucket purpose of the article: how we can load the data from aws s3 into snowflake. Intend Audience: useful for the people who working with snowflake and aws .   CSV   File: A comma-separated values (CSV)  file  is a delimited  text file  that uses a  comma  to separate values. Each line of the file is a data  record . Each record consists of one or more  fields , separated by commas. Alternative delimiter-separated files are often given a .csv  extension  despite the use of a non-comma field separator. AWS S3 bucket: Amazon simple storage service (Amazon s3) is an object storage service. Amazon S3 has a simple web services interface that you can use to store and retrieve any amount of data, at any time, from anywhere on the web. IAM User: An AWS Identity and Access Management (IAM) user ...