How to export data to a local system from a snow cover data warehouse?

Question

I use a data environment for a cloud of snowflakes, which is similar to a teradata in which data is stored. I can run queries and get results using the web interface itself. But I don’t understand how it is possible to export the results to the local PC so that we can report based on the data.

Thanks in advance

Answer 1

You have 2 options that use sfsql, which is based on henplus. The first option is to export the result of your request to an intermediate S3 file, as shown below:

CREATE STAGE my_stage URL='s3://loading/files/' CREDENTIALS=(AWS_KEY_ID=‘****' AWS_SECRET_KEY=‘****’);
COPY INTO @my_stage/dump
FROM  (select * from orderstiny limit 5) file_format=(format_name=‘csv' compression=‘gzip'');

Another option is to capture the sql result into a file.

Test.sql:

set-property column-delimiter ","; 
set-property sql-result-showheader off;
set-property sql-result-showfooter off;

select current_date() from dual;

$. / sfsql <test.sql> result.txt

- Snowflake Snowflake, Snowflake. → .

, .

Answer 2

COPY ( ) S3 ( "stage" ), GET, . "sfsql" Snowflake ( -).

"", .

Answer 3

Snowflakes S3 unix-

• Use COPY TO to load the table data into the table. https://docs.snowflake.net/manuals/sql-reference/sql/copy-into-location.html

  snowsql $> copy to @% test_table / result / data_ from test_table file_format = (TYPE = '[FILE_TYPE]' compression = '[COMPRESSION_TYPE]');

• Use the GET command to load data from the table into the local FS https://docs.snowflake.net/manuals/sql-reference/sql/get.html

  snowsql $> get @% test_table / result / data_ file: /// tmp /;