IF table_list IS NULL THEN DROP TABLE IF EXISTS sp_tmp_tablelist ĬREATE temp TABLE sp_tmp_tablelist (tbl_name VARCHAR(100)) SELECT listagg(sc_list, ',') within GROUP ( ORDER BY sc_list) IF schema_list IS NULL THEN DROP TABLE IF EXISTS sp_tmp_schemalist ĬREATE temp TABLE sp_tmp_schemalist (sc_list VARCHAR(100)) ĪND nspname NOT LIKE 'pg_%' GROUP BY nspname IAM ROLE and the Delimiter is hardcoded here You can get these things as variable or hardcoded as per your convenient.Ĭreate a table for maintain the unload history:ĬREATE OR replace PROCEDURE unload_pro(s3_location VARCHAR(10000),
In the stored procedure, I have hardcoded the follow parameters. To understand all other parameters read my previous post. schema_name - Export the tables in this schema.You can refer my previous post to understand how it works and the meaning for the variables I used. Unload all the tables in a specific schema.But after spending few days I found a solution for this. Its because of I can’t give comma separated values in RedShift stored procedure. We should export all the tables, you can’t specify some list of tables or all the tables in a specific schema.
#REDSHIFT UNLOAD WITH GZIP HOW TO#
In my previous post, I explained how to unload all the tables in the RedShift database to S3 Bucket. AWS RedShift Unload Like A Pro - Multiple Tables And Schemas
0 kommentar(er)
