CODEWITHSUNDEEP
snowflake-cloud-data-platformetl
Mr.Tiffenbox
Mr.Tiffenbox

Reputation: 87

ETL tool to access snowflake internal stage files?

I'm new to snowflake even for data engineering. for me, I want to perform extract and transformation of snowflake internal staged files. like below,

name size md5 last_modified
sales/auto_ingest/3.csv.gz 3915392 b8b6286365965360a2b2ef0b45 Thu, 25 Aug 2022 10:29:43 GMT
sales/auto_ingest/4.csv.gz 3915392 5719ac992cb5c5718c24d13c0 Thu, 25 Aug 2022 10:30:03 GMT

and perform extract and transform using any suggested tool and load it into snowflake table. let me know is it possible? or suggest me any tools for accessing snowflake staged files.

Upvotes: 0

Views: 315

Answers (1)

Sergiu
Sergiu

Reputation: 4578

You cannot access Snowflake staged files directly, you will need to use either a connector/driver or an application like SnowSQL.

To upload files to Snowflake stage you can use the PUT command and to download them from the stage you can use the GET command. Both commands can be used from SnowSQL.

Upvotes: 1

Related Questions