SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Redshift and SAS

Reply
New Contributor
Posts: 4

Redshift and SAS

Hello,

 

I am trying to upload a large table from SAS to Amazon RedShift using the bulkload option(http://documentation.sas.com/?docsetId=acreldb&docsetTarget=n1getgqem5whhmn1bxx7ct75ns82.htm&docsetV...).

 

It requires the BL_Bucket option (http://documentation.sas.com/?docsetId=acreldb&docsetTarget=n1n1jcqd49bk0kn1r66oe3o3dt47.htm&docsetV...)

 

I have the bucket name, access and secret keys, but I don't know how they should be entered into the data set option. Could someone post an example of proc append with the bl_bucket option?

 

Thank you!

Super User
Posts: 3,309

Re: Redshift and SAS

Posted in reply to test12342341

Here is how I expect it to work. I note you need to be using SAS 9.4M4 for this option to be available.

 

proc datasets library = REDSHIFT;
  append base =  BaseTable
               data = AppendTable (bl_bucket = MyBucketName)
         ;
  run;
quit;
New Contributor
Posts: 4

Re: Redshift and SAS

Thanks for your reply.

 

The data set option should go on the base table since that is the destination.

 

The bulkload=yes option should be used as well.

 

Here is what I tried and it is not working. Gives me an error saying 'Unknown region'. There doesn't seem to be a way to supply region.

 

    proc append base=rds_lib.base_table( bulkload=yes BL_BUCKET=bucket_name)
        data=data_table;
    run;

Respected Advisor
Posts: 4,186

Re: Redshift and SAS

[ Edited ]
Posted in reply to test12342341

@test12342341

The bulkload options need to be on source table (data=) as this is the one you want to load in bulk. 

 

...I stay corrected: The bulkload option needs to be on the target table.

New Contributor
Posts: 4

Re: Redshift and SAS

New Contributor
Posts: 4

Re: Redshift and SAS

Posted in reply to test12342341

I found some documentation on it. There are additional options that should be supplied. The example is here: https://communities.sas.com/t5/SAS-Communities-Library/Redshift-and-SAS/ta-p/361738

 

 

Respected Advisor
Posts: 4,186

Re: Redshift and SAS

Posted in reply to test12342341

@test12342341

Given that the link you've posted provides sample code and demonstrates how to use some of the bulkload options: What's still not working for you?

Ask a Question
Discussion stats
  • 6 replies
  • 184 views
  • 0 likes
  • 3 in conversation