is there any other third party tool (like toda, sql developer) we can use to work snowsql. other than command line. If yes please shae the steps to configure and work.

ReplyMore..ReportDelete

nVector01-Apr-20

You want a simple file to load files to a table in snowflake ? I am not aware of a tool. But we can write a tiny script to achieve this. We could make it a generic one, so that the end users can just double click on it to upload data.

When I get time, I will build that script and share here, Keep an eye

ReplyMore..ReportDelete

nilikomal-9116-Aug-20

Hi, I am using Dbeaver to connect to Snowflake on-prem DWH. Dbeaver is a SQL software app which gives you access to almost all the Databases. Install Dbeaver and connect to Snowflake. You can execute the queries in this tool instead of command line.

ReplyMore..ReportDelete

yeshkumarg12-Jul-20

Hi,

1) Regarding table creation. We are using create or replace command, what if table is already exists in the schema? will it overwrite it? if yes, how to handle it. as table might have created by some other user.

2) After insertion how does get stores in database? is there commit; or rollback; like in sql commands?

ReplyMore..ReportDelete

nVector17-Jul-20

1. If you are worried about accidentally overwriting tables, you can remove the "replace" from the statement. And just do a plain create table instead

2. It's autocommited. No need to explicitly mention any commits

ReplyMore..ReportDelete

Sam7324-Sep-21

Hi, how to automate this process?

Could you please give some hints

ReplyMore..ReportDelete