topic Re: Bulkload data from sas to snowflake using sas connector (Invalid option name BL_INTERNAL_STAGE) in SAS Programming

Bulkload data from sas to snowflake using sas connector (Invalid option name BL_INTERNAL_STAGE)

Krushik — Tue, 28 Feb 2023 04:16:25 GMT

Usecase: I want to push data from SAS to user stage.
Problem: bl_internal_stage is not working
When I try to execute the following query , bl_internal_stage is not working

15 LIBNAME snowkipi ODBC datasrc='snow_db_kipi'

16 user='XXXXXXXXXXX'

17 password=XXXXXXXXXXX

18 schema='landing'

19 bulkload=yes bl_internal_stage="user/XXXXXXXXXXX";

-----------------

ERROR: Libref SNOWKIPI is not assigned.

ERROR: Error in the LIBNAME statement.

ERROR 22-7: Invalid option name BL_INTERNAL_STAGE.

Re: Bulkload data from sas to snowflake using sas connector (Invalid option name BL_INTERNAL_STAGE)

s_lassen — Tue, 21 Mar 2023 12:42:06 GMT

As far as I can see the SAS/ODBC connection does not support the bl_internal_stage option directly. But it may be possible to put it in the CONOPTS parameter, something like

conopts='bl_internal_stage="user/XXXXXXXXXXX"'

which may work. I do not have experience with the Snowflake ODBC donnection, though.

Re: Bulkload data from sas to snowflake using sas connector (Invalid option name BL_INTERNAL_STAGE)

LinusH — Tue, 21 Mar 2023 13:22:02 GMT

BL_INTERNAL:_STAGE is only supported in the SNOWFLAKE access engine.

I think this option is a SAS name, so I highly doubt that it could work in a connection options string.

The Snowflake ODBC driver supports specifying internal stage when using PUT. Not sure how make that work from a SAS libname though.

https://docs.snowflake.com/en/sql-reference/sql/put

If you plan to use Snowflake extensively from SAS I suggest you look into using the Snowflake ACCESS engine instead.