Hi @Lukas Yu -MSFT
Sorry for getting back late. Am kind of stuck with testing the connection. I have the 'Snowflake ODBC 32/64 bit' driver installed and configured as 'System DSN' in local with Snowflake Service Account. (By default snowflake driver does not save password, so had to update the 'Registry Editor' to get the password saved)
Now in Visual Studio 2017 (SSDT), when i try to create a sample tabular model to test the connection/import am faced with the below error -
/**
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application, IM014.
A connection could not be made to the data source with the Name of 'SF_Connection'.
**/
It is with 'Integrated Workspace Mode - True' and impersonation as 'Service Account'. I understand this is due to the impersonation i have provided as i could see the query getting parsed/previewed but failed while importing.
Thanks,