Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Snowflake Bulk Connection using S3 roles/IAM privileges (No Access/Secret Keys)

akihirokomatsu
8 - Asteroid

Hi all,

 

Is it possible to set up bulk data uploading to Snowflake when the AWS S3 I'm using is set up to be password-less? The s3 setup is not using access and secret keys for authentication, but rather roles and IAM privileges.

 

I am able to load data using the Stream-In DB tool, but I suspect that is not bulk uploading but rather row by row inserts.

 

Any help is appreciated.

 

Thanks

2 REPLIES 2
TessaS
Alteryx
Alteryx

Hi @akihirokomatsu ,

 

At this time Alteryx doesn't work with IAM roles but it has been submitted as an idea here: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/RedShift-bulk-load-using-IAM-EC2-role/idi-p/... .

 

You could try creating a DSN-less connection string but you will need the help of your Snowflake DBA to administer it.

 

Thanks!

Tessa Smithers

Sr. Technical Account Manager
Alteryx, Inc.


akihirokomatsu
8 - Asteroid

Thanks Tessa!

Labels