Skip to main content
  • Home
  • Product Ideas
  • Is there any way to ODBC DNS for Snowflake Extractor instead of putting username and password in YAML?
Gathering Interest

Is there any way to ODBC DNS for Snowflake Extractor instead of putting username and password in YAML?

Related products:Extractors
Anita Hæhre
  • Anita Hæhre
    Anita Hæhre
T
Seasoned

Hello,

 

I have trying to use the ODBC extractor to pull data from Snowflake, I could do that by following instructions here https://docs.cognite.com/cdf/integration/guides/extraction/configuration/db/#-snowflake

 

However, this requires me to put passwords in YAML config. Is there anyway to use DSN from ODBC instead? I see that connection-string parameter is not supported when I choose type as snowflake.

 

Thanks!

6 replies

Mithila Jayalath
Seasoned Practitioner
Forum|alt.badge.img

Hi @Tanmay Deshpande,

Can you please check whether the documentation here helps for your usecase?

T
Seasoned

Hi @Mithila Jayalath  The question is not if Snowflake supports ODBC, the question is if Cognite ODBC extractor supports passing DSN option while configuring the extractor. https://docs.cognite.com/cdf/integration/guides/extraction/configuration/db/#-snowflake

Aditya Kotiyal
MVP
Forum|alt.badge.img+3

@Peet Cremer  Can you help with this query?

If it is not supported today, it will be good to implement something to avoid security scan failures considering username and password are not encrypted.

Aditya Kotiyal
Aditya Kotiyal
MVP
Forum|alt.badge.img+3

@Mithila Jayalath If it is not supported (once Peet responds), then can we convert this into a product idea?

Aditya Kotiyal
T
Seasoned Practitioner
Forum|alt.badge.img

@Tanmay Deshpande,

Unfortunately, the DB extractor does not currently support DSN configuration for the Snowflake source system "flavor" (personality), and we do not have any plans for supporting it in the near future (next quarter or two) as we're fully loaded with work. I can reassess the need, and our schedule, to consider adding generic DSN support for more DB/ODBC connected flavors supported by the DB Extractor, in about 6 months or so. 

P
Practitioner
  • Peet Cremer
  • Practitioner
  • 4 replies
  • October 8, 2024

@Aditya Kotiyal see Thomas’s response. Not supported for now, but could be evaluated in 6 months.

Reply


Terms & ConditionsCookie Settings

Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings