How to load data from UNIX to snowflake

user_18458632 0
Viewed 114

I have created CSV files into UNIX server using Informatica resides in. I want to load those CSV files directly from UNIX box to snowflake using snowsql, can someone help me how to do that?

snowflake-cloud-data-platform
1 Answers
  1. Log into SnowSQL:
    https://docs.snowflake.com/en/user-guide/getting-started-tutorial-log-in.html
  2. Create a Database, Table and Virtual Warehouse, if not done so already:
    https://docs.snowflake.com/en/user-guide/getting-started-tutorial-create-objects.html
  3. Stage the CSV files, using PUT:
    https://docs.snowflake.com/en/user-guide/getting-started-tutorial-stage-data-files.html
  4. Copy the files into the target table using COPY INTO:
    https://docs.snowflake.com/en/user-guide/getting-started-tutorial-copy-into.html
user_10098230
Related