what if my openquery does not show characters that I have in Snowflake? Same querry but it displays some arrows instead of letters? These are some German characters. Collation issue or ODBC driver issue?
When I test my ODBC Snowflake Configuration, it keeps telling me incorrect username or password was specified. I could use some reassurance on connecting
Awesome! Very good! thanks. I could select data from SF but I have some tables that are not able to be queried, the error message is: OLE DB provider "MSDASQL" for linked server "SFPI" returned message "Requested conversion is not supported.". Msg 7341, Level 16, State 2, Line 1 Cannot get the current row value of column "[MSDASQL].FILENAME" from OLE DB provider "MSDASQL" for linked server "SFPI".
Thanks for the video, I had followed the same steps but didn't work it out, it is given me a proxy error. The same way I have done for DBeaver using its driver, it works like a charm, till now what would be the reason that its not been successful using odbc 64. Its quite essential as there is no build in visualization for spatial query output which I need to visualize it in QGIS. The other options for the visualuzation are pretty limited. Looking forward for any sort of pointers.
@@KahanDataSolutions okay, thats what I tries but how I ensure that like I don't know how to give that permission or check weather that permission is there or not.... please help me
@@prakharsaxena9189 I suggest asking your DB administrator for help. The answer to that will be very specific to your environment setup. If you still have questions, feel free to post in the community channel - bit.ly/2XJJwDU
I have tables in Snowflake that have anywhere from 2 million to 20 million rows. The 2.8 million took 58 minutes in a select statement on sql server 2008 R2. Is there anyway to get much better performance? Although I'm pushing to update sql server, would updating sql server help at all?
Hi Kim, for that amount of rows I don't think an update of SQL Server would drastically change it but it's hard to say for sure without knowing the full context. Typically performance issues would be related to how the query is written. There may be ways to optimize it for performance. Try some of the suggestions mentioned in this video - th-cam.com/video/V-4_PAMBSjY/w-d-xo.html
Looking for help with your team's data strategy? → www.kahandatasolutions.com
Looking to improve your data engineering skillset?→ bit.ly/more-kds
This was exactly what I needed. Now I can still use T-SQL when dealing with data in Snowflake!! Thank you!
Good one mate. Very informative 👍
Need videos on snowpipe
Appreciate it! Those will be coming soon
This was exactly what I needed. Thank you for the great content!
thanks @kahanDatasolutions . Can you please let me know how do we authenticate using RSA key?
what if my openquery does not show characters that I have in Snowflake? Same querry but it displays some arrows instead of letters? These are some German characters. Collation issue or ODBC driver issue?
Informative, can we connect snowflake in SSAS multidimentional cube?
When I test my ODBC Snowflake Configuration, it keeps telling me incorrect username or password was specified. I could use some reassurance on connecting
I am facing issue while inserting procedure from Snowflake to IDT(sap bo). Could you please tell the steps?
Thanks for the info. Can you please let me know how to connect using SSO login? say okta kind of login. Is it possible?
Awesome! Very good! thanks.
I could select data from SF but I have some tables that are not able to be queried, the error message is:
OLE DB provider "MSDASQL" for linked server "SFPI" returned message "Requested conversion is not supported.".
Msg 7341, Level 16, State 2, Line 1
Cannot get the current row value of column "[MSDASQL].FILENAME" from OLE DB provider "MSDASQL" for linked server "SFPI".
Useful info.
Glad it was helpful!
Thanks for the video! Great stuff.
Do you know if it is possible to do on Azure SQL Database?
Thank you! I have not tried this with Azure SQL Database, but if there is an option to add an ODBC Linked Server I would imagine its possible.
linked server is super slow with snowflake ( and in general) , so be aware when you are using it
Any comparison please share
Thanks for the video, I had followed the same steps but didn't work it out, it is given me a proxy error. The same way I have done for DBeaver using its driver, it works like a charm, till now what would be the reason that its not been successful using odbc 64. Its quite essential as there is no build in visualization for spatial query output which I need to visualize it in QGIS. The other options for the visualuzation are pretty limited. Looking forward for any sort of pointers.
Informative and well explained. I would like to know if its possible to connect snowflake odbc throu MS ACCESS. Please help.
Hi Vinitha - I have not worked much w/ MS Access but if there is an ODBC connector available then you should be able to make it work.
@@KahanDataSolutions Even excel connection not working.
Can we do the same from Snowflake? Like referencing data from Snowflake WebUI for the SQL Server DBs?
Hi Mohammad - I have not tried that way so I'm not sure if that is possible.
Hey, I did exactly like you said. but I'm getting this error "the current user does not have permissions on that object." Please help me with this.
Make sure the user you connect with also has permissions on the objects you are trying to view.
@@KahanDataSolutions okay, thats what I tries but how I ensure that like I don't know how to give that permission or check weather that permission is there or not.... please help me
@@prakharsaxena9189 I suggest asking your DB administrator for help. The answer to that will be very specific to your environment setup.
If you still have questions, feel free to post in the community channel - bit.ly/2XJJwDU
@@KahanDataSolutions where can I connect with you personally??
I have tables in Snowflake that have anywhere from 2 million to 20 million rows. The 2.8 million took 58 minutes in a select statement on sql server 2008 R2. Is there anyway to get much better performance? Although I'm pushing to update sql server, would updating sql server help at all?
Hi Kim, for that amount of rows I don't think an update of SQL Server would drastically change it but it's hard to say for sure without knowing the full context. Typically performance issues would be related to how the query is written. There may be ways to optimize it for performance. Try some of the suggestions mentioned in this video - th-cam.com/video/V-4_PAMBSjY/w-d-xo.html
very usefull, thank you for the
tutorial
Glad it was helpful!
How we can connect python , mysql with snowflake make a video please ....
Cool