I would like to be able to use BULKUPLOAD and BL_NUM_READ_THREADS when connected to Snowflake. Sample code follows. %let cmsid = &_METAUSER; proc sql noprint; connect to snow as x1 (DATABASE=ADM_PRD DSN=Snowflake_OPI CONOPTS="authenticator=https://xxx.xxx.xxx?snowflake=okta" role=OPIC_ADM_OPI_RWC_P SCHEMA=CMS_ADM_OPI authdomain=SNOW_Auth bl_internal_stage="user/&cmsid" BULKUNLOAD=YES); EXECUTE (create or replace table FIVE_YEARS_HOS as … (many more fields specified) SAS will not complain when I submit this code and it completes in 7.87s. The query never shows up in the Snowflake Classic UI History. Without the BULKUNLOAD=YES option the query runs for 32min 30s. and the table is created.
... View more